Change the Service Account User

It is possible to change the Pleasant Password Service's user account. This may be necessary when updating your database and is useful for limiting access.

This is may be necessary if:

  • Connecting to an MS-SQL database with Windows Authentication
  • Backing up your Database to a network drive

Otherwise, connections that use SQL Authentication (username/password), this step can be skipped.

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:

For default configurations:

  • That is, if the application is running as a Service (with an IIS Express task, not on an IIS server):
    • Run Services.msc
      • Open the Properties of the Pleasant Password Service -> Change user in Log On tab
        • Ensure your user has necessary access (e.g. administrators, etc.)
        • Ensure your user has access to your Password Server Backup folder. This can be configured to a location on your network.
        • For additional details: https://technet.microsoft.com/en-us/...(v=ws.11).aspx

For IIS Hosting configurations:

MS-SQL Connection Security Settings:

  • Connections using Windows Authentication (instead of username/password):
    • Setup the user with login access & permissions on your Alternate Database
    • For MS-SQL:
      • Login to Microsoft SQL Server Management Studio
      • Open your SQL Server database folder (left-hand window pane) -> Click Security Folder
      • Right-click logins and select "New Login"
      • In the Login Name field either:
        • Select the Login Name of your service user account, or
        • For IIS Applications, type (do not click search):
          • IIS APPPOOL\YourAppPoolName
      • Select the "User Mapping" page
        • Select your Database
        • Set: db_owner (database role membership)
      • Configure SQL Server to allow Windows Authentication mode / mixed authentication
        1. Right-click on SQL Server instance at root of Object Explorer, click on Properties
        2. Select Security from the left pane.
        3. Select the SQL Server and Windows Authentication mode radio button, and click OK.
      • More Information (MS-SQL):
Tag page
You must login to post a comment.