Results 1 to 2 of 2

Thread: WSUS cannot connect to database

  1. #1
    Join Date
    Sep 2004
    Posts
    59

    WSUS cannot connect to database

    I was using WSUS on Windows 2000 SP4 server using MSDE database but now i have built 2003 SP1 server which uses SQL 2000. I have installed all required hacks ans fixes so that SQL version/patch level matches my previous MSDE installation.msdb databases have been restored in new SQL installation and WSUS has created the SUSDB database within SQL as well but now when i am trying to access WSUS admin page then i am getting an message saying "Error connecting to the Windows Server Update Services database". I have gone through event log and i see this:

    Connection to database failed. Reason=Cannot open database requested in
    login 'SUSDB'. Login fails.
    Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.. Connection string:

    I want to know if i can do anything to to get back access to WSUS admin page?

  2. #2
    Join Date
    Jun 2009
    Posts
    4,145
    I will like to inform you that database "user" account is associated with SID, to the SQL Login because of which when database is restored to another server, SIDs gets changed. Anyways you can go through below article for understanding system stored procedures and for sorting out the issue you are facing.
    PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete

Similar Threads

  1. Database Size and Requirement for WSUS 3.0
    By Ascetica in forum Server Update Service
    Replies: 5
    Last Post: 20-04-2010, 08:21 PM
  2. How to move wsus 3.0 database
    By MikeY007 in forum Server Update Service
    Replies: 3
    Last Post: 25-10-2008, 12:29 AM
  3. moving wsus 3.0 int. database to a new hard disk
    By Christopher in forum Server Update Service
    Replies: 4
    Last Post: 30-10-2007, 02:15 AM
  4. WSUS client unable to connect WSUS server
    By BoanHed in forum Server Update Service
    Replies: 3
    Last Post: 28-10-2007, 03:29 AM
  5. can't uninstall WSUS - Windows internal database problems..
    By 2muchreality in forum Server Update Service
    Replies: 4
    Last Post: 17-08-2007, 01:34 PM

Posting Permissions

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