WSUS MSDE Password and DB Schema

[Allanoo]

I did a default installation of WSUS on a server by using the provided MSDE DB, but I was not given the option to set a password for the database. So, can anyone tell me where can I find what the installer set the password to and thus change the password as well. Also is there anyone to tell me a program to view the backend of the WSUS database or anywhere that I can find out its table structure? Thanks for any information in advance.

[kattman]

You can try out the EMS SQL Manager for SQL Server which is a high performance tool for the development and management of databases of Microsoft SQL Server. SQL Manager is compatible with all versions of SQL Server from version 7 to the latest version. The tool is compaible with all the new features of SQL Server, including sequences, indexes, and spatial indexes columnstore, FileTables, autonomous databases, server roles etc.

[absolute55]

You can try to use the Microsoft Query on the server to veiw the db and then run the queries. You can then create the data source using the servername\Wsus instead of just the server name and then use the SQL driver.

[Dr.pter]

I think that the SQL 2005 Express Manager is trying to use the TCP/IP by default and the WSUS (W)MSDE installation had the option to diable the networking and thus there will be no TCP/IP but only Named Pipes. If thats the case then you can try to fix by making sure that the SQL 2005 Express Manager is configured to use the Named Pipes for communication with the (W)MSDE instance.

[techguru1]

To connect to SUSDB where WSUS 3.0 is install locally ( LOCALHOST ) and uses the Windows Internal Database ( SQL 2005 Express ), use SQL Server Management Studio Express and reference the Named Pipe location exactly as shown below:

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

To connect to the SUSDB using VB.NET, ensure that your connection for the WSUS Server points to the aforementioned Named Pipes location and that the database is "SUSDB".

You may find interest in a 3rd party tool named "WSUS Easy Reporter" from Swarmsoft.net. Note that, at the time of writing this, the product had a bug: the web.config file was missing an appSettings entry for WSUSDB. It is easily corrected by manually adding the entry as:

<add key="WSUSDB" value="SUSDB" />

As noted above, the WSUSServer value should be defined as:

<add key="WSUSServer" value="\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query" />

Best Regards,
Paul