Export (0) Print
Expand All

Issues with the Database

Applies To: Windows Server 2003 with SP2, Windows Server Update Services

If you have problems with the SQL Server database or Windows Internal Database, make sure that the WSUS database in question is in the correct SQL instance before starting to troubleshoot SQL issues.

noteNote
You will need to use the sqlcmd utility, which can be downloaded from Feature Pack for Microsoft SQL Server 2005 (http://go.microsoft.com/fwlink/?LinkId=81081). For more information about the sqlcmd utility, see sqlcmd Utility (http://go.microsoft.com/fwlink/?LinkId=81183).

  1. Verify the SQL server name by opening a command window and typing the following:

    Reg query "HKLM\SOFTWARE\Microsoft\Update Services\Server\Setup" /v SqlServerName

    The output contains the SQL server name to be used in the next step.

  2. Type the following:

    sqlcmd -S  SqlServerName  -E -d SUSDB

    Review any error messages and correct the problems.

If you are using Windows Internal Database as the WSUS database, use the following string in place of SqlServerName in the above command:

np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft