Follow

Use a Windows Account for Your Perspective Database

If you want to pair your Perspective Database with a Windows account, you configure Microsoft SQL Server to use a local SQL account or Windows account.

SQL Server Configuration

  1. Open SQL Server Management Studio.

  2. Expand the Security

  3. Right-click Logins.

  4. Click New Login.

  5. Enter the Login name of the Windows account you wish to use for Perspective.

  6. Under Select a page, click User Mapping.

  7. Select the Perspective database checkbox under Users mapped to this login.

  8. Select the db_owner checkbox under the Database role membership for: section.

  9. Click OK.

Web Application Configuration

After installing Perspective Services and Service manager on the application server, you’ll need to use Service Manager to connect to your Perspective database.

  1. Login into the application server with the Windows account used in SQL Server Management Studio.

  2. Hold down the Shift key on your keyboard then right-click Service Manager.

  3. Click Run as different user.

  4. On the database connection screen, select your SQL server from the SQL Server drop-down menu.

  5. Select the Windows Authentication radio button.

  6. Select the Perspective database from the Databases drop-down menu.

  7. Click OK to save your changes.

Failed to Bind Error

After completing the above steps, some users may encounter the following error:

This is error likely appears because the Perspective application pool in the IIS Manager doesn’t have the appropriate rights to allow the program to access the database.

  1. Launch Internet Information Services (IIS) Manager.

  2. Expand the local host node in the Connections pane.

  3. Click Application Pools.

  4. Right-click the Perspective database in the Application Pools pane.

  5. Click Advanced Settings.

  6. Under Process Model, click Identity.

  7. Click the icon.

  8. In the Application Pool Identity window, select the Custom account radio button.

  9. Click Set.

  10. Enter the Windows username and password for the Perspective database.

  11. Click OK to return to the main Internet Information Services (IIS) screen.

  12. Ensure the Perspective database is still selected in the Application Pools pane.

  13. Click Recycle.

    Note: Recycling may need to be repeated for Integration Services application pool if you use the web portal, the Perspective iOS application, or a custom API integration.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk