+ Post New Thread
Results 1 to 4 of 4
Windows Thread, WSUS & Sophus - MSSQL ?? in Technical; so i have a very old server thats sat there running sophus and a load of old profile data that ...
  1. #1

    Join Date
    Jan 2007
    Location
    Birmingham UK
    Posts
    13
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    WSUS & Sophus - MSSQL ??

    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

    ops: 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

  2. #2

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,582
    Thank Post
    107
    Thanked 761 Times in 592 Posts
    Rep Power
    179

    Re: WSUS & Sophus - MSSQL ??

    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.

  3. #3

    Join Date
    Jan 2007
    Location
    Birmingham UK
    Posts
    13
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: WSUS & Sophus - MSSQL ??

    well that seems too simple to me but i'll give it ago
    here was me thinki i was missin the sql administrative tools

  4. #4

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,582
    Thank Post
    107
    Thanked 761 Times in 592 Posts
    Rep Power
    179

    Re: WSUS & Sophus - MSSQL ??

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

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS on MSSQL 2005
    By AlexB in forum MIS Systems
    Replies: 9
    Last Post: 7th November 2007, 09:20 AM
  2. Open Source CMS that can use MSSQL
    By ICTNUT in forum Windows
    Replies: 4
    Last Post: 29th March 2007, 03:08 PM
  3. MSSQL Trigger (i think) Question
    By k-strider in forum Coding
    Replies: 3
    Last Post: 28th November 2006, 12:15 PM
  4. MSSQL Trigger (i think) Question
    By k-strider in forum Coding
    Replies: 0
    Last Post: 27th November 2006, 11:45 AM
  5. Autocreate AD accounts from MSSQL
    By CyberNerd in forum Coding
    Replies: 9
    Last Post: 12th July 2006, 03:00 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •