Passwordstate Documentation

SQL Server Express, and SQL Port Number Considerations ​

If you intend to use SQL Server Express to host your Passwordstate database, please consider the following before installing Passwordstate:

  1. If you're using SQL Server Express on a different server to where you installed Passwordstate, you may need to check if the TCP/IP Protocol is enabled (use SQL Server Configuration Manager -> SQL Server Network Configuration), and also the Windows Service 'SQL Server Browser' is set to 'Automatic' Startup Type, and has been started.
  2. By default, SQL Server Express installs with an ‘instance’ name of SQLExpress. When you’re configuring Passwordstate for first time use, specifically the ‘Database Settings’ page, please ensure you have specified the name of the instance correctly i.e. fill out both the Database Server Name and Instance Name fields
  3. If you intend to also install the High Availability instance of Passwordstate, SQL Server Express can only be used as the Subscriber for data replication, not the Publisher or Distribution database, which means you cannot use it for your primary Passwordstate server.

If you are running SQL Server on a non-standard port number, you will need to append the port number to the end of the Database Server Name during ‘Configuring Passwordstate for First Time Use’ in the following way: ServerHostName,PortNumber i.e. sqlserver1,8484