troubleshooting Question

Installing WSUS on SBS 2003 Premium

Avatar of budchawla
budchawlaFlag for United Kingdom of Great Britain and Northern Ireland asked on
5 Comments1 Solution368 ViewsLast Modified:
Hi all,

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, but that content is no longer publicly available.

Feel free to answer just a part of this question!


Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros