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.
rookeydooksAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Acronis Data Cloud 7.8 Enhances Cyber Protection

A closer look at five essential enhancements that benefit end-users and help MSPs take their cloud data protection business further.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft IIS Web Server

From novice to tech pro — start learning today.