You received a Change Summary or a report containing the following warning message:
“Warning: Collect ‘Database’ information warning on server: server_name DB: db_name. Database ‘ db_name ‘ is already open and can only have one user at a time”.
Access to the database is restricted to one user at a time. Netwrix Auditor failed to access the database because another user was working with it.
To change the database access restriction, perform the following steps:
- Open Microsoft SQL Server Management Studio and connect to your server.
- Navigate to the required database, right-click it and select Properties.
- Open the Options tab and change the “Restrict Access” value to “MULTI_USER”.