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:
and review any error messages and correct the problems.
For more information about the sqlcmd utility, see sqlcmd Utility.