Find a Connection String

Find a connection string for connecting Password Server to a fresh new database, either from the ones listed below, or refer to The Connection Strings Reference.

Choose a Connection Method:

• Windows Authentication: (Recommended)
  
  • You will need to also change the Service account user
• SQL Authentication: which includes userid/password in the connection string
  
  • The connection string is encrypted in storage

  • Access to this can also be further restricted on the Security Configuration exe properties

Trust the Default Placeholder Certificate:

• Using MS-SQL with the default Certificate, set this: TrustServerCertificate=True;

Connection Strings

Select one of the following strings based on database, server host, & connection; & replace the parameter values:

• MS-SQL (Windows Authentication):

  • Server=YourServerName;Database=YourDatabaseName;Encrypt=TrueOrFalse;
    Integrated Security=SSPI;TrustServerCertificate=TrueOrFalse;

  • Server=YourServerNameyourInstanceName;Database=YourDatabaseName;Encrypt=TrueOrFalse;
    Integrated Security=SSPI;TrustServerCertificate=TrueOrFalse;

•  MS-SQL (SQL Authentication):

  • Server=YourServerName;Database=YourDatabaseName;Encrypt=TrueOrFalse;
    User Id=myUsername;Password=myPassword;TrustServerCertificate=TrueOrFalse;

  • Server=YourServerNameyourInstanceName;Database=YourDatabaseName;Encrypt=TrueOrFalse;
    User Id=myUsername;Password=myPassword;TrustServerCertificate=TrueOrFalse;

• PostgreSQL (Windows Authentication):

  • Server=IP Address or 127.0.0.1;Port=5432;Database=myDataBase;Integrated Security=true;

• PostgreSQL (SQL Authentication):

  • Server=127.0.0.1;Port=5432;Database=myDataBase;User ID=myUsername;Password=myPassword;

  • Server=IP Address;Port=5432;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

• Azure SQL DB:

  • Server=tcp:YourServerName.database.windows.net,1433;Database=YourDatabaseName;
    User ID=YourUserName@YourServerName; Password=YourPassword;

  • Note: You can also copy your connection string from your Azure Manager.