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…


One Thought on “Connecting to the WSUS database with SQL 2005’s tools

  1. FostWare on June 12, 2007 at 7:21 pm said:

    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 :(

Post Navigation