WSUS DB SUSPECT

[Boxalld]

Having trouble with WSUS, I have seen in the Log file that the Database is suspect. How can i repair the database ?????

To get WSUS running again.

 

[tfg13]

What are you using as the DB? Is it the WMSDE? Have you successfully been able to log into the DB using the OSQL.exe command?

 

[Boxalld]

Using MSDE I tried conecting using osql.exe as follows

osql.exe -S localhost -d susdb -U administrator

I tried my domain admin account as well

Could not connect to the database

says either access denied or no sql running ( checked the MSSQL$WSUS and its runing

 

[tfg13]

Try typing (with servername replaced with your server name)

osql.exe -E -S servername\WSUS

If a 1> shows up, type "use master", then a 2> should show up. Type go. Also, look to see which groups have access. Should look something like this:

1>use master
2>go
1>select name from sysusers
2>go

You should have WSUS administrators in the permissions. If not, you'll need to add them. This article will help you:

http://support.microsoft.com/kb/325003/

Also, try running sqlmngr.exe, just to make sure....