[jaxisland]

Source: Windows Server Update
Type: Error
Event ID: 421

Connection to database failed. Reason=Login failed for `NT Authority\Network Service`..Connection String: Data Source=ServerName\WSUS;Initial Catalog=SUSDB;Connection Timeout= 60;Application Name=WSUS SQL
Connection; Trusted_Connection=Yes;Pooling=`true`;Max Pool Size=100

That is in the application log.

This is what I get when I put in my admin credentials to open WSUS:

Error connecting to the Windows Server Update Services database
There was an error connecting to the Windows Server Update Services database. Either the database is not available or you do not have the correct privileges to access the database.

If you believe you have received this message in error, please check with your system administrator.

Click here to reload the site: Windows Server Update Services


Anyone have any ideas?

[Advertisements]

So far it seems like the database is corrupt and I will need to do a complete reinstall.

If anyone has any ideas before that let me know, please.

[jaxisland]

So far it seems like the database is corrupt and I will need to do a complete reinstall.

If anyone has any ideas before that let me know, please.

[dsenette]

has wsus been up for long? just wondering for the reinstall consequences

are you using the MSDE or an acutal sql instance?

[jaxisland]

It has been up for about 8 months on this server. New hardware.

I actually just did a full delete and reinstall and it seems to work now without any problems.

I was using the sql instance.

I figured after hours of looking around for answers a reinstall was the best option and so far it seems true. The one thing I did find is that you have to make sure you remove all the components and do a fresh install.

That way you make sure everything is all set.

Thanks though.

[dsenette]

yeah...WSUS is odd...i've found that when it messes up...reinstallng it is the easiest way to go..to my knowledge the server retains all the update files so it's not like you've got to re DL those...but i could be wrong

[jaxisland]

You can choose to save the files if you want. For my case, I found the best thing was to wipe it out completely and i will re-download them over the weekend.

Our company is closed Sat and Sun so I dont mind dealing with it then. Its less of a headache then fighting with it all day today just to find out that I will have to reinstall it anways later.