Sitemap

Find a Connection String

Discover how Pleasant Password Server will enhance KeePass for business

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)
    • Recommend: Further to disable SQL authentication
    • You will need to also change the Service account user of the service/site that is running Password Server
  • 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

Other MS-SQL Parameters:

  • Production settings:
    • TrustServerCertificate=False   [The certificate chain will be validated]
    • Encrypt=True;                       [Encrypt communications between Password Server and Database]
  • Initial setup (with only a Placeholder Certificate):
    • TrustServerCertificate=True    [The certificate chain will be trusted and not validated]

Connection Strings

For Reference, here is the default format of the SQLite connection string:

  • SQLite:
    • Data Source=[DataFolder]\PleasantPassServer.db;Key=aes256:xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

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=YourServerName\yourInstanceName;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=YourServerName\yourInstanceName;Database=YourDatabaseName;Encrypt=TrueOrFalse;
      User Id=myUsername;Password=myPassword;TrustServerCertificate=TrueOrFalse;

  • Azure SQL DB:

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

    • Note: Port is required. You can also copy your connection string from your Azure Manager.
  • 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;