WSUS & Sophus - MSSQL ??

[tech_master]

so i have a very old server thats sat there running sophus and a load of old profile data that i am beginning to archive off (*hopes the copy is still running \ was successfull*)

 

i would ideally like to have this not just to run sophus as that seams a bit of a waste but if i can get WSUS on it that would be usefull

 

:oops: ran the MBSA today and every computer it scaned was "Unable to compleate scan" OR "Severe Risk"

 

so i think its about time we got some updates out to these computers to fix at least some of the problems

 

the sophus server (called eportal just to confuse everyone) has MSSQL on it (2000 as its only a win 2000 server) i know you can install WSUS on 2k but i dont know how to add the instance for the SQL ? not ever used M$ sql before so this is all new to me i have also considered making it a member server as at the moment it is a DC an processes loads of logins whereas the PDC could do all that as it sits there not doing alot all day long

 

*NOTE : this server is only running MS SQL for sophus not for the admin network i have already checked this the admin server runs sql itself i dunno if there linked in anyway yet also dont know how to check*

 

any help with this would be usefull espically if anyone has a combined wsus & sophus server

 

but the backup of the data will probly take till the end of this week at this rate an span over a fare few dvd's as the tape drive seems to hate me so i have no confidence in it at all

[Ric_]

WSUS will create the database for you at install time... just point the installer at your SQL instance rather than creating a new instance when prompted.

[tech_master]

well that seems too simple to me but i'll give it ago

here was me thinki i was missin the sql administrative tools

[Ric_]

i know this because i installed it 3 times on our demo box at BETT... using SQL Express 2005.