How to check if WSUS using correct database instance

It is easy to check which database instance used by WSUS,

You can check it directly browsing you registry.

Or by running the command below.

Reg query "HKLMSOFTWAREMicrosoftUpdate ServicesServerSetup" /v SqlServerName

And if you have sqlcmd.exe on your computer you can also easily check connection by running

sqlcmd -S SqlServerName -E -d SUSDB

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

np:\.pipeMSSQL$MICROSOFT##SSEEsqlquery

and review any error messages and correct the problems.

For more information about the sqlcmd utility, see sqlcmd Utility.