Environment
- App Control Server: 8.8.x - 8.10.0
- 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 tracked under EP-16680 involving the method in which the remote database was called.
Resolution
This issue was tracked under EP-16680 and resolved with the release of Server 8.10.2. Previously the workaround involved:
- Launch the Server installer, but do not continue the installation yet.
- Navigate to:
C:\Users\SRVC_ACCT\AppData\Local\Temp\{GUID-FOR-INSTALL}\{GUID-FOR-INSTALL}
- 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)
- Locate the line:
USE [das]
- Change to:
-- USE [das]
- 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
