WSUS Front-End, Back-End Questions

Discussion in 'Update Services' started by sascha, Jul 12, 2005.

  1. sascha

    sascha Guest

    Hello all!

    We like to install some WSUS with remote connections to one MSSQL 2000
    Server database. So a lot of WSUS-Server should use this one and only SQL
    2000 Server. Is this supported? And how to license?


    sascha, Jul 12, 2005
    1. Advertisements

  2. Sascha,

    From the WSUS Deployment Guide:
    "WSUS does not support multiple WSUS databases on a single computer running
    SQL Server"

    As for licensing -- you'll have to come up with some pretty good reasons to
    want to use SQL. Every managed client (desktop, server) requires a separate
    SQL CAL - unless you opt for the per processor SQL license. Either way, it
    is very expensive to use SQL 2000 instead of MSDE/WMSDE. What is your
    justification for wanting SQL 2000 over MSDE/WMSDE?

    Jeff Centimano [MVP - Windows Server], Jul 12, 2005
    1. Advertisements

  3. sascha

    sascha Guest

    Thnaks for answering, Jeff!

    The Scenario is:

    One WSUS is the master and gets his downloads from microsoft. We have more
    then 70 branches with their own fileservers. Ever of these branches schould
    have a WSUS which replicates from the master. To query, if an important patch
    is installed on every client in the company, we don't want to query every

    The deployment guide says that with more then 500 clients a SQL Server is
    recommanded. At the headquarter we have about 700 clients and don't want to
    install more then one WSUS.
    sascha, Jul 13, 2005
  4. Honestly, if you use Win2003 and WMSDE you can scale to 700 without any
    problem. WMSDE doesn't have the storage or performance limitations of
    straight-up MSDE... so this changes things a little. The guide is a little
    fuzzy in this area, but you should be ok.

    Jeff Centimano [MVP - Windows Server], Jul 13, 2005
  5. sascha

    sascha Guest

    Many thanks for your helpfull tips! I'll try the WMSDE.

    sascha, Jul 14, 2005
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.