App Control: Installation on Remote SQL Server Fails With "A database script 'add_remote_user' needed" or add_server_role needed error

[#1]

Environment

• App Control Server: 8.8.x and Higher
• Microsoft SQL Server: All Supported Versions
• Two Tier Environment

Symptoms

• Installing (or upgrading) App Control and pointing it to a Remote SQL Server Fails with errors containing:
  • "A database script 'add_remote_user'"
  • "A database script 'add_server_role needed"

Cause

Known Issue where we incorrectly call the remote database

Resolution

1. Launch the Server installer, but do not continue the installation yet.
2. Navigate to:

   C:\Users\SRVC_ACCT\AppData\Local\Temp\{GUID-FOR-INSTALL}\{GUID-FOR-INSTALL}

3. Open add_remote_user.sql (or add_app_pool_user.sql and add_server_role.sql depending on the error) with a text editor (such as notepad)
4. Locate the line:

   USE [das]

5. Change to:

   -- USE [das]

6. Save, and continue install.

Additional Notes

• This issue is scheduled to be fixed in the upcoming 8.10.2 server release (EP-16680).
• If the install from an existing database has already failed then the database will need to be restored before another install is attempted.

Related Content

App Control: Where Are Server Install Logs Located?
App Control: What SQL Permissions Are Required for the App Control Service Account?