Looking for a definitive answer & explanation on the best route to install WSUS on SBS 2003 Premium. Actually, this is a question copied almost verbatim from one of the newsgroups that didn't get a definitive answer IMHO.
1) Should I use the SQL2000 database as the WSUS database or should
I stick with WMSDE? (Note that when I installed the Premium technologies I
upgraded all the databases - except SBSMONITORING - to use SQL2000)
2) If I do use SQL2000 then do I just install onto the default instance or
should I create another? I'm not clear here on when or if you should create
another SQL instance and exactly how to do it so any advice appreciated. I
do have another 3rd party application that will need to use SQL2000 later on
if that matters.
3) If I do use SQL2000 what do I need to before the WSUS install to "prepare
it" for the install?
4) My server is not OEM, so I don't expect to run into any strange install
problems like I've seen documented in the NG's & BLOG's with OEM SBS
servers. Are there any other issues that I am not aware of?
And as for the choice of database, can someone please explain the reasoning behind their choice...
The Microsoft step-by-step talks about extracting the wsus files, running a command line command to create the wmsde database and then running WSUS setup. There is a reference in the newsgroup thread to an article to smallbizserver.net, but that content is no longer publicly available.
Feel free to answer just a part of this question!