Skip to content
Trending
Simplify Windows Devices to Run Only the Required Applications using Intune Enhance macOS Compliance with Custom Security and Compliance Checks to Improve Device Security using Microsoft Intune Manage Samsung Galaxy Firmware Versions to Improve Security and Compliance using Microsoft Intune MS Intune Adds Windows Registry Data Collection to Device Inventory for Single Values All Key Values and Subkeys Updated Windows Device Sync Experience Enhances Per-Device Troubleshooting Configure Windows Sandbox vGPU Policy using Intune for Better Graphics Performance or Reduced Attack Surface Simplify Windows Devices to Run Only the Required Applications using Intune Enhance macOS Compliance with Custom Security and Compliance Checks to Improve Device Security using Microsoft Intune Manage Samsung Galaxy Firmware Versions to Improve Security and Compliance using Microsoft Intune MS Intune Adds Windows Registry Data Collection to Device Inventory for Single Values All Key Values and Subkeys Updated Windows Device Sync Experience Enhances Per-Device Troubleshooting Configure Windows Sandbox vGPU Policy using Intune for Better Graphics Performance or Reduced Attack Surface
SCCM How to Fix the Error the Database is in Single User Mode Configuration

SCCM How to Fix the Error the Database is in Single User Mode Configuration

Written By Anoop C Nair
Last Updated August 7, 2024
Posted In SCCM
SHARE

Let’s discuss How to Fix the Error the Database is in Single User Mode Configuration. Through this post I will explain single-user mode configuration.

In single-user mode, only one user can access the database at a time. Whenever you set the database to single-user mode without any information, all the other connections are closed.

With the release of SCCM, we can have multiple SUPs under one primary server. One scenario that I want to test is Remote SUP with shared DB.

Before installing the SUP role, we must install WSUS 3.0 SP2 on the remote SUP server, along with the WSUS patches (2720211 and 2734608). SCCM How to Fix the Error the Database is in Single User Mode Configuration.

Patch My PC

SCCM How to Fix the Error the Database is in Single User Mode Configuration

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

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

The second log was more specific.

SCCM How to Fix the Error the Database is in Single User Mode Configuration - Fig.1
SCCM How to Fix the Error the Database is in Single User Mode Configuration – Fig.1

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.  Single User Mode Configuration

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

ALTER DATABASE statement failed.

Now, how do we 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, the search helped to find a solution. Following are the SQL queries to resolve the issue. SCCM How to Fix the Error the Database is in Single User Mode Configuration.

1. Need to find out the 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

SCCM How to Fix the Error the Database is in Single User Mode Configuration

We are on WhatsApp now. To get the latest step-by-step guides, news, and updates, Join our Channel. Click here – HTMD WhatsApp.

Author

Anoop C Nair is Microsoft MVP! He is a Device Management Admin 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 primary focus is Device Management technologies like SCCM 2012, Current Branch, and Intune. He writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc.

Written by

Anoop C Nair is Workplace Technology solution architect with 25+ years of experience in global enterprise organizations such as JP Morgan, Capgemini, etc. Microsoft Certified Trainer. Microsoft MVP from 2015 onwards for consecutive 11+ years! He also conducts Intune and modern workplace tech training for enterprise organizations. He is Blogger, Speaker, and Founder of HTMD Community and HTMD Conference. His main focus is on Device Management technologies like Intune, Windows, Cloud PC. He writes about technologies like Intune, SCCM, Windows, Cloud PC, Windows, Entra, Microsoft Security.

Discussion · 7 comments

  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

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

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

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

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

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

Join the discussion

Your email address will not be published. Required fields are marked *

Related guides

Intune

Windows 11 KB5101650 KB5099414 July 2026 Patch and 3 Zero Day Vulnerabilities and 570 Flaws

Key Takeaways Windows 11 KB5101650 KB5099414 July 2026 Patch and 3 Zero Day Vulnerabilities and 570 Flaws! In the July 2026 Patch, Microsoft introduced new features designed to improve the overall Windows experience. The update adds enhancements to Windows Update for more flexible update management and introduces Point-in-Time Restore, providing an additional recovery option for […]

AC Anoop C Nair 9 min read
Intune

2026 June KB5094126 KB5093998 Windows 11 Patch | 3 Zero Day Vulnerabilities and 200 Flaws

Key Takeaways 2026 June KB5094126 KB5093998 Windows 11 Patch | 3 Zero Day Vulnerabilities and 200 Flaws! The June 2026 Windows 11 Patch Tuesday update brings several improvements to File Explorer. It adds support for additional archive formats, including UU, CPIO, XAR, and NuGet Packages (NUPKG). The update also preserves View and Sort preferences in […]

AC Anoop C Nair 10 min read
Intune

2026 May KB5089549 KB5087420 Windows 11 Patch | 0 Zero Day Vulnerabilities and 120 Flaws

Key Takeaways The Windows 11 May 2026 Patch KB5089549 KB5087420 Update brings important security fixes, performance improvements, and reliability enhancements across the operating system. The update introduces new features such as Xbox Mode for gaming, File Explorer improvements, enhanced input and sharing experiences, better taskbar and Windows Hello reliability, and additional enterprise management capabilities for […]

AC Anoop C Nair 8 min read
SCCM

ConfigMgr 2603 Introduces New Early Update Enrollment Process

Key Takeaways In this post we are discussing the ConfigMgr 2603 Introduces New Early Update Enrollment Process. Microsoft has officially released Configuration Manager version 2603 to the Early Update Ring, giving organizations an opportunity to test upcoming improvements before the global production rollout. The release is targeted at enterprises running ConfigMgr version 2409 or later […]

AC Anoop C Nair 3 min read