App Control: Database Connection Fails Due to Single User Mode
book
Article ID: 288715
calendar_today
Updated On:
Products
Carbon Black App Control (formerly Cb Protection)
Issue/Introduction
Console instability, including difficulty loading pages or logging in.
Errors in ParityReporter.log similar to:
ERROR DatabaseConnectionWrapper - Database connection failed. Further database connect errors will not be logged. Login failed for user 'DOMAIN\ServiceAccount'. Reason: Server is in single user mode. Only one administrator can connect at this time.
Environment
App Control Server: All Supported Versions
Microsoft SQL Server: All Supported Versions
Cause
The Restrict Access setting has been set to SINGLE_USER instead of MULTI_USER for the App Control database.
Resolution
Log in to the application server hosting the Console as the Service Account.
Stop the App Control Server and Reporter services.
Open SQL Server Management Studio and connect to the SQL Server.
Expand the Server Name > Databases > right click das > Properties.
From the Options page > State > Restrict Access > select MULTI_USER.
Click OK
Start the App Control Server and Reporter services.