SCCM How to Fix the Error the database is in Single User Mode Configuration Endpoint Manager

SCCM How to Fix the Error the database is in Single User Mode Configuration Endpoint Manager. With the release of SCCM, We can have multiple SUPs under one primary server. One scenario that I want to test was Remote SUP with shared DB.

Prior to SUP role installation, we need to install WSUS 3.0 SP2 on the remote SUP server along with WSUS patches (2720211 and 2734608).

SCCM How to Fix the Error the database is in Single User Mode

WSUS is installed successfully with shared DB (DB is located at my primary server). However, when I tried to install the patch it was giving me the following error.

I’ve checked the MSI3f93c.log file and then MWusCa.log.

Patch My PC

The second log was more specific.

SCCM How to Fix the Error the database is in Single User Mode
SCCM How to Fix the Error the database is in Single User Mode

Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor.  Action ExInstallSqlQuery, location: C:\Windows\Installer\MSIC2B8.tmp, command: -S ACNCMPRI -Q “

Database ‘SUSDB’ is already open and can only have one user at a time.

Changes to the state or options of database ‘SUSDB’ cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.Msg 5069, Level 16, State 1, Server ACNCMPRI,  Line 1

Adaptiva

ALTER DATABASE statement failed.

Now how to resolve this issue? Logged into SQL studio at my ConfigMgr 2012 SP1 primary server and checked SUSDB. Yes, that was in single-user mode. Now, how to change single-user mode to Multi-User mode? Again search helped to find out a solution. Following are the SQL queries to resolve the issue.

1. Need to find out that user and session id.

SQL query/statement –

select d.name, d.dbid, spid, login_time, nt_domain, nt_username, loginame
from sysprocesses p inner join sysdatabases d on p.dbid = d.dbid
where d.name = ‘SUSDB’

go

2. Note down the “spid” of the user from the above query result and kill that session.

SQL Statement – “kill 52

Where 52 was session ID.

3. Change the SUSDB to multi-user mode.

SQL Statement –

ALTER DATABASE SUSDB
SET MULTI_USER

Author

Anoop is Microsoft MVP! He is a Solution Architect in enterprise client management with more than 20 years of experience (calculation done in 2021) in IT. He is a blogger, Speaker, and Local User Group HTMD Community leader. His main focus is on Device Management technologies like SCCM 2012, Current Branch, and Intune. E writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc…

7 thoughts on “SCCM How to Fix the Error the database is in Single User Mode Configuration Endpoint Manager”

  1. If the first SQL query fails at ‘SUSDB’ on the third line you might try using ‘SUSDB’, this is probably due to regional settings. You might not be able to see it on the screen, but the quotation marks are different.

    Reply
  2. Seems the only login connection is my login through SQL Management Studio. If I ‘kill” it, I’m informed I can’t kill my own session. This seems to be a catch-22. I have to connect to it, to alter it to multi-user mode, yet no one (including me) can be connected to it when it’s changed.

    Reply
  3. Well, I guess my unmediated post can be deleted, along with this one. I ended up uninstalling WSUS, uninstalling WID, and after a reboot, reinstalling them both. First thing on the list, decline kb3148812 and kb3159706. I’m tired of being the MS guineapig on this one.

    Reply
  4. You can run from master and so SP_WHO this will get you what is running with the database.. So you are not in a UserDB. Runs a Stored Procedure.

    Reply
  5. Thanks big time man, this instruction helped me a lot. I managed to change single user to multi user mode.
    WSUS now working like a charm.

    Reply
  6. No, it will fail sometimes with the following message. mssql is not well designed, the only way to get out this situation is to restart mssql services.

    Msg 924, Level 14, State 1, Line 51
    Database adsfadf is already open and can only have one user at a time.

    Reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.