Change the Service Account User

It is possible to change the Pleasant Password Service's user account. This may be necessary when changing the database for Pleasant Password Server when:

Please Note:

  • This particular setting will not persist in an upgrade, and will need to be updated.
  • Please keep this step in your upgrade plans. 

Steps: Switch the Service Account User

For IIS Hosting configurations:

For IISExpress hosting (default configuration):

  1. Run Services.msc
  2. Open the Properties of the Pleasant Password Service -> Click on "Log On" tab -> Change the user
  3. Type with this format:
    • DomainUserName

      Note: Pleasant Password Server does NOT currently support authentication with a UPN (User Principal Name) format, i.e. username@domain.

      However, a workaround is setup your directory alias the same as your domain (or email domain), and to use username@directoryalias.

  4. Double-Check:
    • Ensure your user has necessary access: local admin may be necessary to open/close ports
    • Ensure your user has access to your Password Server Backup folder. This can be configured to a location on your network.

 

MS-SQL Connection Security Settings

Setup the user with login access & permissions on your Alternate Database.

  1. Add a new Login User
    • Login to Microsoft SQL Server Management Studio
    • Open your SQL Server database folder (left-hand window pane) -> Click Security Folder
    • Right-click logins -> Select "New Login"
    • Login Name:
      • Select the Login Name of your service user account, OR
      • For IIS Applications, type (do not click search):
        • IIS APPPOOLYourAppPoolName
    • Select the "User Mapping" page
      • Select your Database
      • Set: db_owner (database role membership)
  2. Enable the authentication mode (Windows and/or SQL)
    • Choose "Windows Authentication" mode or "Mixed authentication" mode
      • Right-click on SQL Server instance at root of Object Explorer, click on Properties
      • Select Security from the left pane.
      • Select the SQL Server and Windows Authentication mode radio button, and click OK.

 

For More Information: