WSUS database. Can it be on Remote SQL box ?

Hi,

I'm in the process of installing WSUS, and i can't seem to find any options
where i can store the database it wants in a SQL 2000 server on another
machine. It appears to only allow MSDE or SQL on the server where you install
WSUS.

Please let me know if it's possible to use a SQL 2000 server on a different
machine to that where you install WSUS.

Thank you

rcu wrote:

> Hi,
>
> I'm in the process of installing WSUS, and i can't seem to find any options
> where i can store the database it wants in a SQL 2000 server on another
> machine. It appears to only allow MSDE or SQL on the server where you install
> WSUS.
>
> Please let me know if it's possible to use a SQL 2000 server on a different
> machine to that where you install WSUS.
Hi,

Some doc links for you:

From the "Deploying Microsoft Windows Server Update Services" available at
http://www.microsoft.com/technet/pro...11bb06b40.mspx

see:
Choose the Database Used for WSUS
http://www.microsoft.com/technet/pro...accd1ff63.mspx

and:
Appendix C: Remote SQL
http://www.microsoft.com/technet/pro...7ad0cd638.mspx


You might want to take a look here as well:

Upgrading MSDE or WMSDE to SQL Server 2000
http://www.wsuswiki.com/UpgradingMSDEtoSQL2000


And a FYI:

Please post WSUS questions to the newsgroup dedicated to WSUS:
microsoft.public.windows.server.update_services

(the microsoft.public.softwareupdatesvcs newsgroup is for SUS)


WebNews link to the WSUS newsgroup:
http://www.microsoft.com/communities...pdate_services


Or use a newsgroup reader (default Outlook Express) to access this new
group:

Clicking on this link should open this group in OE:

news://msnews.microsoft.com/microsof...pdate_services




--
torgeir, Microsoft MVP Scripting and WMI, Porsgrunn Norway
Administration scripting examples and an ONLINE version of
the 1328 page Scripting Guide:
http://www.microsoft.com/technet/scr...r/default.mspx