8.10.4 Server upgrade error due to a critical database script "add_server_role"
book
Article ID: 286671
calendar_today
Updated On:
Products
Carbon Black App Control (formerly Cb Protection)
Issue/Introduction
The following popup error is displayed during the upgrade process:
A critical database script "add_server_role" needed to install the App Control Server failed with an error.
Once the "Ok" button is selected the upgrade completes. At this point the server was partially upgraded, the database was successfully upgraded, but the web console and some registry values were only partially updated.
Environment
App Control Server 8.10.2-8.10.4
Cause
The error is displayed when the SQL Server doesn't have a login principal with name "SA" configured.
Resolution
To resolve this please uninstall and re-install the 8.10.4 server version installation (this will use the existing database so no config will be lost):
Log in to the server with the App Control Service Account