Solved

WSUS 3.0 & SQL Server 2000 SP4

Posted on 2007-11-21
3
926 Views
Last Modified: 2010-05-18
Would like to run WSUS 3.0 on a box running WS2K3SP2 and host teh WSUS DB on a server running W2K3SP2 & SQL Server 2000 SP4.

Is this possible? The requirements for WSUS say to use SQL 2005, but I do not have it and do not want to pay for it. I also do not want to run poopy MSDE.

0
Comment
Question by:keatscon
  • 2
3 Comments
 
LVL 8

Expert Comment

by:rjwesley
ID: 20331102
Poopy MSDE works without issues on the three servers I run it on.

I'd say your simplest option is WSUS 3 and MDSE.

from reading:

http://technet2.microsoft.com/windowsserver/en/library/d7183651-b9fb-4288-a15f-33032c40ce2d1033.mspx?pf=true (Remote SQL limitations)

and

http://technet2.microsoft.com/windowsserver/en/library/9e01d057-6b39-4eb7-b151-dff7ad0cd6381033.mspx?pf=true

I'd say keep it simple.

Rob
0
 

Author Comment

by:keatscon
ID: 20331125
Thank you Rob, but I do not want to run MSDE on any of my servers, would rather run on SQL 2000 SP4, but do not want to pay for 2005, especially if it has nothing new to offer that we can use.

I do want to keep it simple, that is why I want to put the db on an existing server rather than mess with another sql.
0
 
LVL 8

Accepted Solution

by:
rjwesley earned 500 total points
ID: 20331625
Windows Server Update Services 2.0 with Service Pack 1 is your only option.

http://technet.microsoft.com/en-ca/wsus/bb466206.aspx

Rob
(Yes I agree upgrading is not always viable)
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Numerous times I have been asked this questions that what is it that makes my machine log on so slow, there have been cases where computers took 23 minute exactly after taking password and getting to the desktop. Interesting thing was the fact th…
Many of us need to configure DHCP server(s) in their environment. We can do that simply via DHCP console on server or using MMC snap-in on each computer with Administrative Tools installed in a network. But what if we have to configure many DHCP ser…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now