Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

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

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

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


Labels (1)
Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎03-30-2023
Views:
543
Contributors