App Control: Database Connection Fails Due to Single User Mode

[#1]

Environment

• App Control Server: All Supported Versions
• Microsoft SQL Server: All Supported Versions

Symptoms

• 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.

Cause

The Restrict Access setting has been set to SINGLE_USER instead of MULTI_USER for the App Control database.

Resolution

1. Log in to the application server hosting the Console as the Service Account.
2. Stop the App Control Server and Reporter services.
3. Open SQL Server Management Studio and connect to the SQL Server.
4. Expand the Server Name > Databases > right click das > Properties.
5. From the Options page > State > Restrict Access > select MULTI_USER.
6. Click OK
7. Start the App Control Server and Reporter services.

Related Content

App Control : SQL Server Consumes High Memory in a Single-Tier Environment
App Control: How to Collect Database Logs for Performance Issues (SQL Server)
App Control: Collecting Historical Logs for Server Troubleshooting (Locally)