• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 54
  • Last Modified:

WSUS wont load after win updates were istalled on the same server

The server thats is also running WSUS failed to install its updates and was stuck in Win Logo screen.
The only way i could get it to boot is to manually remove all pending updates using DISM cmd.
From this guide.
https://social.technet.microsoft.com/wiki/contents/articles/36400.windows-server-20082012-incl-r2-uninstall-updates-while-your-machine-is-in-reboot-loop.aspx

Now my server boots but WSUS is not working. I think some other updates may have been removed which made the WSUS install older than the WID database
I cant load the mmc, i tried deleting the mmc file. But it wont connect its complaining about the DB.
And also running the post install steps failed saying the DB is not same version as WSUS and I need to patch WSUS
C:\Windows\system32>"C:\Program Files\Update Services\Tools\wsusutil.exe" postinstall /servicing
Log file is located at C:\Users\administrator\AppData\Local\Temp\2\tmpF11.tmp
Post install is starting
Fatal Error: 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.
ALTER DATABASE statement failed.


Since the issue is on WSUS server it cant update it self
Right now im trying to point it to MS Updates and get the latest updates from Internet instead if it self.

Here are some errors I see in event log.

Error      4/14/2018 5:04:07 PM      MSSQL$MICROSOFT##WID      18056      Server
Error      4/14/2018 5:01:59 PM      Windows Server Update Services      12042      9
Error      4/14/2018 5:01:59 PM      Windows Server Update Services      12032      9
Error      4/14/2018 4:43:47 PM      Windows Server Update Services      507      1
Error      4/14/2018 4:43:02 PM      Windows Server Update Services      7053      None
Warning      4/14/2018 4:37:23 PM      Windows Server Update Services      7032      None
Ideally id like to fix this without loosing my WSUS db or data.
0
baysysadmin
Asked:
baysysadmin
  • 3
  • 2
1 Solution
 
Shaun VermaakTechnical Specialist/DeveloperCommented:
Try to exit single user mode with SQLCMD.exe
ALTER DATABASE 'SUSDB' SET MULTI_USER

Open in new window

0
 
baysysadminAuthor Commented:
Ive never used that exe before, is it located somewhere on the server?

Today i noticed WSUS service crashed on its own (not that it was working right to begin with)

Even with service off, the post install cmd returns

Fatal Error: Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
ALTER DATABASE statement failed.

In task manager there is no PID 51 so what could be locking the DB?

even if I figure out how to run the sqlcmd.exe you gave me, i imagine it wont work when its locked by another process.
0
 
baysysadminAuthor Commented:
I had to install SQL Manager on this DC, and was able to connect via GUI

\\.\pipe\MICROSOFT##WID\tsql\query

I could not alter state because it was locked by PID 51 so I ran a kill cmd along with alter and that worked.
my WSUS console connects now.

kill 51 
go
alter database SUSDB set multi_user;
go

Open in new window


Im testing now to see if my servers connect to WSUS

Thanks
0
 
Shaun VermaakTechnical Specialist/DeveloperCommented:
What process was id 51?
0
 
baysysadminAuthor Commented:
it was for SUSDB i dont know what in detail, i didnt drill into it.

It wasnt the WSUS Service, because that was off.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now