Sitemap

4) Changing databases for Pleasant Password Server

See why customers enjoy using Pleasant Password Server with a KeePass client

By default, Pleasant Password Server installs quickly with a securely encrypted SQLite database on the server machine. However, by using the powerful, built-in "Restore from Backup" functionality, it's possible to convert and migrate all the Password Server data (see Items included in database) to a database of another type, for example, MS-SQL, Azure DB, or PostgreSQL.

High-Level Overview:

  • Create a new database instance
  • Switch the database connection string to the new database
  • Use the built-in "Restore from Backup," which converts and re-populates your data into the new database.

For detailed steps: see Configure Your Database section below.

Have Questions?  Contact Us

Related:

 

Sections:

 

Supported Databases

See Supported Databases for more information on database types and user size recommendations.

For performance considerations, see when to upgrade the database.

Database Encryption

When changing to a new database, ensure that the database is secured and review these steps to Encrypt your Database.

Create a Backup

Ensure you have created a backup:

Configure Your Database

To change or move the database used by Password Server, follow these steps:

  1. Before starting: make sure you've read sections above:

    • Create a Backup,

    • Encrypt your DB (above).

  2. Stop the Password Server service.

  3. Change the database:

  4. Open the Service Configuration Utility

    • (See how to open this utility from the Backup section above)

    • Click Database Configuration & Choose Database Provider:

      • for Azure SQL DB choose MSSQL

    • Enter the Connection String to connect Password Server to a fresh new database.
    • Click Save Changes and exit the Service Configuration Utility

  5. Change the Service Account User for Pleasant Password Server:

    • Note: This particular setting will not persist in an upgrade! and will need to be updated. Please keep this step in your upgrade plans.
    •  This step can be skipped if using SQL Authentication (connection string has username/password).

  6. Start the Password Server service. This will automatically create all the tables in the database and set up the default admin user.

  7. Login with your browser to your server.

  8. (optional) Restore all your data from backup:

    • Now you can migrate all your data (folders, entries, application settings, etc.) that you had in the previous database type.

    • Use the database backup and restore to: Restore from backup (Enterprise edition)

  9. Double-check license activation.

  10. Restart your service/site.

  11. See the Troubleshooting section below if necessary.

 

These settings will persist through future updates of Pleasant Password Server (except step 6).

Troubleshooting

If you run into any issues with your chosen database please check the items below:

  • Ensure your Firewall or Anti-Virus are not interfering with network traffic

  • Increase logging details for the Password Server. Restart the service, and review the log outputs.

  • Specific Checks (MS-SQL):
    • Ensure the Authentication mode is properly set:
      • SQL authentication (userid/password), requires enabling Mixed Mode or SQL authentication (under the Instance properties security)
    • Start the services for SQL Server (using services.msc):
      • SQL Server
    • SQL Server requires that TCP/IP connectivity is turned on, and by default the port is 1433
      • Otherwise the ERROR: "The System cannot find the file specified." Problem creating a connection to the SQL Server Database.
      • We can check listening ports with this command:
        • netstat -ano | find ":1433"
      • Open SQL Server Configuration Manager (compmgmt.msc) > Click SQL Server Network Configuration:
        • Set TCP/IP = Enabled
        • Set TCP Port = 1433
        • Restart the website
    • Detailed MS-SQL troubleshooting: see Connectivity issues

  • Problem 1:
    • Error: "The target principal name is incorrect" (found in EventViewer / Log files)
    • Resolution: 
      • Add "TrustServerCertificate=true" to your Connection String

  • Problem 2:
    • Service fails to start, after an upgrade
    • Error in Weblogs file:
      • Cannot open database "CustomerDatabase" requested by the login. The login failed.
      • Login failed for user 'DOMAIN\USERNAME'.
    • Resolution:
      • The database was changed to MS-SQL, and the Service User Account was switched.
      • On Upgrade, this information is lost, and needs to be re-applied.
      • Close the upgrade’s “Starting the service” window
      • Open Services.msc, make the change, and re-start

  • Problem 3:
    • Empty database; no tables
    • Resolution:
      • Double-check the security permissions for the user
      • Double-check that the service account in format: Domain\UserName
        • Note: Pleasant Password Server does NOT currently support authentication with a UPN (User Principal Name) format, i.e. username@domain.

 

If you continue to experience problems, please don't hesitate to send us your detailed log files (at Contact Us), and let us know your situation.

 

Previous Versions Notes

 

Version 3.5.0 or Older