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

wsus system center 2012 sup service pack 1 cm2012  How to Fix the Error the database is in Single User ModeWith the release of SCCM 2012 SP1, 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).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 MSI3f93c.log file and then MWusCa.log. The second log was more specific.

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

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

Posted in: CM2012, Service Pack 1, SUP, System Center 2012, WSUS

2 Comments

  1. Tom Floor says:

    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.

Leave a Comment and Contact Anoop

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On YoutubeVisit Us On LinkedinCheck Our Feed