Find a Connection String

Table of contents
  1. 1. Connection Strings

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:

  • If using the default Certificate, add this to the end of your Connection String:
    • TrustServerCertificate=True;

Connection Strings

Select a string & replace the parameter values:

  • MS-SQL (Windows Authentication):

    • Server=YourServerName\yourInstanceName;Encrypt=trueOrFalse;Database=YourDatabaseName;Integrated Security=SSPI;
  •  MS-SQL (SQL Authentication):

    • Server=YourServerName\yourInstanceName;Encrypt=trueOrFalse;Database=YourDatabaseName;User Id=myUsername;Password=myPassword;
  • PostgreSQL (Windows Authentication):

    • Server=YourServerName;Port=5432;Database=myDataBase;Integrated Security=true;
  • 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.
Tag page
You must login to post a comment.