If you are running SBS standard and you want to control the SQL that comes with WSUS 3.0 the EXACT tool you need can be obtained from THIS link:


(Image courtesy of Handy Andy Goodman as I still haven’t figured out how to connect to mine)

Once you install that on your server you can adjust the RAM value there for WSUS and control the instance (and other SQL instances in fact)


One Response to Controling your SQL instances without the full blown SQL

  1. Wayne Kent says:

    Here is how to connect http://www.wssdemo.com/blog/Lists/Posts/Post.aspx?ID=258

    Here is the maintenance info

    I could not get the script to run using sqlcmd but it ran just fine from SQL Manager