Find a Connection String
Discover how Pleasant Password Server will enhance KeePass for business
Choose from the example connection strings below to connect Password Server to a fresh new database. More info: The Connection Strings Reference.
NOTE 1 - 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
NOTE 2 - Choose other Parameters (MS-SQL/Azure)
- Test settings (e.g. using only the default placeholder certificate):
-
TrustServerCertificate=True [The certificate chain will be trusted and not validated]
-
- Production settings:
- TrustServerCertificate=False [The certificate chain will be validated]
- Encrypt=True; [Encrypt communications between Password Server and Database]
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;PostgreSQL (Windows Authentication):
Server=IP Address or 127.0.0.1;Port=5432;Database=myDataBase;Integrated Security=true;
SSL=trueORfalse;SslMode=requireORdisable;PostgreSQL (SQL Authentication):
Server=127.0.0.1;Port=5432;Database=myDataBase;User ID=myUsername;Password=myPassword;
SSL=trueORfalse;SslMode=requireORdisable;Server=IP Address;Port=5432;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
SSL=trueORfalse;SslMode=requireORdisable;- Note: some values are Case Sensitive, e.g. "require" for SslMode
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.