[There's a reason that Yoda is the unofficial mascot of SBS. Size indeed matters not.] Connecting to the WSUS database with SQL 2005's tools - THE OFFICIAL BLOG OF THE SBS "DIVA"
Tue, Jun 12 2007 15:20 bradley

Connecting to the WSUS database with SQL 2005's tools

I'm not a command line gal and I wanted to document that in order to use the SQL management studio included in SQL 2005 workgroup/R2 to do this, doing this didn't work. Instead as the comment said in the prior blog post, I have to use a pipe string locally....

http://projectdream.org/wordpress/2007/05/10/wsus-v3-and-connections-to-its-internal-database/

\\.\pipe\mssql$microsoft##ssee\sql\query

Once you use that, you can connect to that embedded database just fine and use the tools to adjust accordingly.

Hmmm just realized it installed on the C: drive ...wonder how I can move that...

Filed under:

# re: Connecting to the WSUS database with SQL 2005's tools

Tuesday, June 12, 2007 7:21 PM by FostWare

There's MSDN articles on moving WSUS to SQL2005... I move all MSDE instances I can to SQL Server as it means backup flexibility, management features, and memory savings. It also means I can further justify SBS Premium ^_^ The only MSDE on SBS that apparently can't be moved is SBSMonitoring Possibly because the registry instances only allow you to reference a MSDE instance :(

# Detach and reattach

Saturday, August 11, 2007 12:03 PM by E-Bitz - SBS MVP the Official Blog of the SBS "Diva"

So you need to move a SQL database 'eh? First off the trick is to "get" to that database