Windows Server 2012 Thread, WSUS Post Installation Error in Technical; Hi,
Installed WSUS on Server 2012 R2 RTM today and get the following error when trying to load the post ...
14th October 2013, 01:41 PM #1
WSUS Post Installation Error
Installed WSUS on Server 2012 R2 RTM today and get the following error when trying to load the post installation tasks:
Seems to be an SQL problem. Backup Exec uses a database but it did on the old server I'm moving it from...
The database is in single-user mode, and a user is currently connected to it.ALTER DATABASE statement failed.
Cannot seem to find a solution on the net. Anybody come across this?
14th October 2013, 05:28 PM #2
Its not that you need to give logon as a service rights to wsus. There is a ms article.
15th October 2013, 11:31 AM #3
That hasn't solved it.
Originally Posted by free780
This is the error I get.
15th October 2013, 08:31 PM #4
- Rep Power
It's difficult to imagine what would have caused the database to get stuck in SINGLE_USER mode on a WS2012/WSUS v6.x installation, but there is only ONE way to resolve this issue.
1. STOP the Update Services service. (The reason you cannot get your console connection to work is because the SERVICE has already consumed that one authorized "user".)
2. Open SQL Server Management Studio. (When using WID, you may need to download and install SQL Server 2012 Management Studio Express Edition.)
3. Execute this command: ALTER DATABASE SUSDB SET MULTI_USER;
4. Restart the Update Services service.
16th October 2013, 09:50 AM #5
Originally Posted by LawrenceGarvin
That's what makes this situation weird. The Update Service service isn't showing....
16th October 2013, 10:06 PM #6
- Rep Power
Well, that makes it simple. If there's no Update Services service, then it's not a WSUS Server, and without the service, that'll make it near impossible to connect to the database. Either the installation is corrupted, or the role was partially uninstalled. Inasmuch as it seems the WID was in SINGLE_USER mode when WSUS was being installed (we know that's where it was when the post-install wizard was launched), this thing could be all sorts of sideways. Your best option may be to start from scratch.
16th October 2013, 10:56 PM #7
I have to agree, it looks like a corrupted installation to me. WSUS behaves in a similar way in 2008 R2 when things go wrong.
18th October 2013, 11:06 AM #8
I have checked multi user mode and a host of other suggestions on another forum. Hate to say it but I give up. I've going to set up a virtual machine and just have it dedicated to WSUS. There is obviously something conflicting with my current setup. I had it running fine on a test machine.
Thanks for your help.
By cookie_monster in forum Network and Classroom Management
Last Post: 22nd August 2008, 05:06 PM
Last Post: 21st May 2008, 01:16 PM
By danIT in forum MIS Systems
Last Post: 7th December 2007, 05:23 PM
By DaveP in forum Windows
Last Post: 22nd January 2007, 12:05 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)