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

WSUS 3.2.7 not working / missing connect to server name

Our WSUS server stopped working around a week ago and we kept getting - Error: Connecting to database. I tried resetting the node but no good.

After a few days looking at recommended fixes i now have WSUS Update Services opening but the name of my server is now missing on the left hand tree menu ? I must have deleted it somehow following the online solutions - Please see image attached.

I now have Update Services in the left hand pane with a right click option to "Connect to Server". What server do i need to connect too ?

I have tried connecting to its own Server Name and its own IP address but it errors. I've also tried a list of Microsoft update addresses:

 http://windowsupdate.microsoft.com
http://*.windowsupdate.microsoft.com
https://*.windowsupdate.microsoft.com
http://*.update.microsoft.com
https://*.update.microsoft.com
http://*.windowsupdate.com
http://download.windowsupdate.com
http://download.microsoft.com
http://*.download.windowsupdate.com
http://wustat.windows.com
http://ntservicepack.microsoft.com
http://go.microsoft.com

I am running WSUS version 3.2.76000.226 on a physical Windows Server 2003 R2 (Service Pack 2) box.
0
rookeydooks
Asked:
rookeydooks
  • 8
  • 7
1 Solution
 
rookeydooksAuthor Commented:
Attached screenshot
Capture.JPG
0
 
Peter HutchisonSenior Network Systems SpecialistCommented:
All you need to do is type in the name of the server which has the 'Update Services' service running. You can view list of services by opening the Services.msc or use Server Manager, Configuration, Services.

I have found that migrating the database from the Internal Database to a full SQL Server will improve performance and reduce the connection errors. This is what we did when I old WSUS server kept dropping the connection when we tried to administer WSUS
0
 
rookeydooksAuthor Commented:
Hi Peter, i checked Update Services and it wasn't running so i started it.

I still can't connect to the server though. Please see new screenshot attached.

I also tried ticking Use SSL with port 443 but got the same error.
Capture1.JPG
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
Peter HutchisonSenior Network Systems SpecialistCommented:
Check that the IIS Admin and World wide Web Publishing services have started ok.
Open Internet Information Services console to confirm that the Default Web Site has started ok.
0
 
rookeydooksAuthor Commented:
It all looks ok. Please see screenshot below.
Capture2.JPG
0
 
Peter HutchisonSenior Network Systems SpecialistCommented:
Open MS SQL Management Studio and see if you can connect and view the database ok.

Also check that any database services have started up ok.
0
 
rookeydooksAuthor Commented:
Can't see MS SQL Management Studio ?

I can run >>
NET STOP MSSQL$MICROSOFT##SSEE
NET START MSSQL$MICROSOFT##SSEE
Captur3.JPG
0
 
Peter HutchisonSenior Network Systems SpecialistCommented:
You can install the Management Studio separately. If you have SQL Express/WID try this:
http://www.microsoft.com/en-us/download/details.aspx?id=8961

Configure remote access:
http://akawn.com/blog/2012/01/configuring-sql-server-2008-r2-express-edition-for-remote-access/
0
 
rookeydooksAuthor Commented:
Sorry Peter, i can't find SQL Server Configuration Manager to configure remote access. Also i am using Windows 2003 R2.

I have installed Microsoft SQL Server Manager but when loggin in i get the screenshot error attached.
Capture4.JPG
0
 
Peter HutchisonSenior Network Systems SpecialistCommented:
Configuration manager should be here.
 C:\windows\SysWOW64\SQLServerManager10.msc

Or try load mmc.exe and attach the appropriate snapin.
For access, you need to open properties of the instance, set 'Hide instance' to No and restart the service to able to access it.
0
 
rookeydooksAuthor Commented:
It says cannot find C:\windows\SysWOW64.

Also can't see teh snapin on the list - see attached.
Capture5.JPG
0
 
Peter HutchisonSenior Network Systems SpecialistCommented:
Do you have SQL server or something else installed for the database?
0
 
rookeydooksAuthor Commented:
Hi Peter,

I fran WSUS30-KB972455-x86.exe which removed WSUS 3.0. I didn't tick any of the 3 options.

I then run WSUS30-KB972455-x86.exe again and installed WSUS and ran through the wizard.

It now all seems to be working. The console has loaded and so far synchronization is at 40%.

I'll let if finish synchronizing and then aprove some updates and see if its back working again.

Thank you for your advice to troubleshoot.
0
 
Peter HutchisonSenior Network Systems SpecialistCommented:
Excellent, I was going to suggest a reinstall if any of the other suggestions didn't work.
0
 
rookeydooksAuthor Commented:
Removing and re-installing WSUS solved my issue using WSUS30-KB972455-x86.exe.
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.

  • 8
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now