+ Post New Thread
Results 1 to 8 of 8
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 ...
  1. #1
    gmonks's Avatar
    Join Date
    Oct 2012
    Location
    Bedfordshire
    Posts
    203
    Thank Post
    112
    Thanked 24 Times in 17 Posts
    Rep Power
    11

    WSUS Post Installation Error

    Hi,

    Installed WSUS on Server 2012 R2 RTM today and get the following error when trying to load the post installation tasks:

    The database is in single-user mode, and a user is currently connected to it.ALTER DATABASE statement failed.
    Seems to be an SQL problem. Backup Exec uses a database but it did on the old server I'm moving it from...

    Cannot seem to find a solution on the net. Anybody come across this?

    Thanks
    George.

  2. #2
    free780's Avatar
    Join Date
    Sep 2012
    Posts
    1,086
    Thank Post
    46
    Thanked 88 Times in 83 Posts
    Rep Power
    23
    Its not that you need to give logon as a service rights to wsus. There is a ms article.
    http://support.microsoft.com/kb/2832204

  3. #3
    gmonks's Avatar
    Join Date
    Oct 2012
    Location
    Bedfordshire
    Posts
    203
    Thank Post
    112
    Thanked 24 Times in 17 Posts
    Rep Power
    11
    Quote Originally Posted by free780 View Post
    That hasn't solved it.

    This is the error I get.

    error.png

  4. #4

    Join Date
    Dec 2012
    Location
    Austin
    Posts
    7
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    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.

  5. #5
    gmonks's Avatar
    Join Date
    Oct 2012
    Location
    Bedfordshire
    Posts
    203
    Thank Post
    112
    Thanked 24 Times in 17 Posts
    Rep Power
    11
    Quote Originally Posted by LawrenceGarvin View Post
    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.
    Lawrence,

    That's what makes this situation weird. The Update Service service isn't showing....

    srvices.png

    George.

  6. #6

    Join Date
    Dec 2012
    Location
    Austin
    Posts
    7
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    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.

  7. #7

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,345
    Thank Post
    242
    Thanked 1,602 Times in 1,278 Posts
    Rep Power
    346
    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.

  8. #8
    gmonks's Avatar
    Join Date
    Oct 2012
    Location
    Bedfordshire
    Posts
    203
    Thank Post
    112
    Thanked 24 Times in 17 Posts
    Rep Power
    11
    Hi,


    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.


    George.



SHARE:
+ Post New Thread

Similar Threads

  1. Ranger client install error after SP3
    By cookie_monster in forum Network and Classroom Management
    Replies: 2
    Last Post: 22nd August 2008, 05:06 PM
  2. Vmware server install error
    By stu in forum *nix
    Replies: 5
    Last Post: 21st May 2008, 01:16 PM
  3. SIMS Install Error
    By danIT in forum MIS Systems
    Replies: 4
    Last Post: 7th December 2007, 05:23 PM
  4. Shockwave Install Error
    By DaveP in forum Windows
    Replies: 2
    Last Post: 22nd January 2007, 12:05 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •