WSUS 3 died after November patches

Discussion in 'Update Services' started by Mark Morrell, Jan 2, 2008.

  1. Mark Morrell

    Mark Morrell Guest

    Good Morning!

    I'm running WSUS 3 on Windows 2003 SP2 with SQL 2000 SP4
    SQL is also running instances for SMS and EPO (McAfee) that are still
    working fine.
    It's been running fine for about 6 months with no problems

    After the server restarted from the November patches, my console gives me
    the error:
    Error: Database Error
    An error occurred when trying to perform a database operation.
    Along with the usual explanation of why it can happen and then it says to
    contact myself.
    Reseting the console doesn't do anything.

    In the Application event log I get event ID 18456 Failure Aud
    Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: <named pipe>]

    I've never done much with this since the initial install except approve
    updates. The only changes to the server were the Nov updates.

    Any ideas?

    Thanks
    Mark
     
    Mark Morrell, Jan 2, 2008
    #1
    1. Advertisements

  2. Okay.. first thing you're going to need to recheck -- what database server
    you're using.

    I promise you that you are *not* running WSUS 3 on SQL 2000!

    Now, you may well have SQL 2000 installed on that system, and SMS and EPO
    are quite likely using it -- but WSUS 3.0 is not.

    If you installed WSUS 3.0 on a machine with SQL 2000 installed, WSUS 3.0
    ignored the SQL 2000 installation, and installed a second database server
    (Windows Internal Database), which is what WSUS 3.0 is using. If you
    previously had WSUS 2.0 installed on that SQL 2000 installation and upgraded
    to WSUS 3.0, the WSUS 3.0 installer migrated the databases from the SQL 2000
    installation to the Windows Internal Database.

    What updates were installed???


    --
    Lawrence Garvin, M.S., MCBMSP, MCTS, MCP
    Senior Data Architect, APQC, Houston, Texas
    Microsoft MVP - Software Distribution (2005-2008)

    MS WSUS Website: http://www.microsoft.com/wsus
    My Websites: http://www.onsitechsolutions.com;
    http://wsusinfo.onsitechsolutions.com
    My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
     
    Lawrence Garvin [MVP], Jan 3, 2008
    #2
    1. Advertisements

  3. Mark Morrell

    Mark Morrell Guest

    Well, that explains why there wasn't an instance called WSUS in SMS!
    Now I feel like an idiot! :)
    I have to admit that I don't know much about the internals on this thing. I
    just installed it and it worked so I didn't worry.

    Anyway.
    Here are the updates:
    KB
    941568
    941569
    942615
    942763
    942840
    944653
    943460
    943649
    943591

    ..NET Framework 2.0 SP1
    .NET Framework 2
    Dr Watson
    .Net Framework 1
    PREXP
    WINFORMS
    CLR
    ASP.NET
    CA
    CRT

    ..NET Framework 3.0 SP1
    .NET Framework WPF 2x86
    WPF 3x86
    WF x86
    WPF 2
    XPS
    WCF
    WPF1
    WCS
    WF
    WPF3

    Thanks
    Mark
     
    Mark Morrell, Jan 3, 2008
    #3
  4. Mark Morrell

    Mark Morrell Guest

    ACK! Not awake yet. I meant SQL instead of SMS.
    And I re-read it twice!!
     
    Mark Morrell, Jan 3, 2008
    #4

  5. Couple of questions from the updates:
    - For KB942615 -- IE6 or IE7?
    - For KB943649 and KB943591 -- does your WSUS Server have Outlook 2003
    installed?


    The only update that has any relation to any components of WSUS is KB942840,
    which applies a performance enhancement for sites using Ajax (I'm curious
    that it was classified as a =critical= update, given that's it's reported as
    a "performance enhancement".)

    Even more interesting is the actual update description: "You may experience
    slow Web browser performance when you view a Web page that uses JScript in
    Internet Explorer 6 on a Windows Server 2003-based computer or on a Windows
    XP-based computer".

    So... one option to consider is that unless you're using a JScript based web
    page in IE6 on your WSUS Server, you might consider uninstalling this
    update, and retesting.

    Otherwise, there's nothing in that group of updates that's likely to have
    had any effect on WSUS, and I've successfully installed all updates on my
    WSUS front-end server with no similar behavior.

    Also, I'd like to see the actual text in this error message.


    And.. can you explain the meaning of the below inclusion in your reply?
    --
    Lawrence Garvin, M.S., MCBMSP, MCTS, MCP
    Senior Data Architect, APQC, Houston, Texas
    Microsoft MVP - Software Distribution (2005-2008)

    MS WSUS Website: http://www.microsoft.com/wsus
    My Websites: http://www.onsitechsolutions.com;
    http://wsusinfo.onsitechsolutions.com
    My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
     
    Lawrence Garvin [MVP], Jan 5, 2008
    #5
  6. Mark Morrell

    Mark Morrell Guest

    Yes (used so the backup software can talk to Exchange)
    Uninstalled. Didn't fix.
    The WSUS administration console was unable to connect to the WSUS Server
    Database.

    Verify that SQL server is running on the WSUS Server. If the problem
    persists, try restarting SQL.


    System.Data.SqlClient.SqlException -- Cannot open database "SUSDB" requested
    by the login. The login failed.
    Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

    Source
    ..Net SqlClient Data Provider

    Stack Trace:
    at
    Microsoft.UpdateServices.Internal.BaseApi.SoapExceptionProcessor.DeserializeAndThrow(SoapException
    soapException)
    at
    Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccessProxy.ExecuteSPGetTargetGroupById(Guid
    id)
    at
    Microsoft.UpdateServices.Internal.BaseApi.ComputerTargetGroup.GetById(Guid
    id, UpdateServer updateServer)
    at
    Microsoft.UpdateServices.Internal.BaseApi.UpdateServer.GetComputerTargetGroup(Guid
    id)
    at
    Microsoft.UpdateServices.UI.AdminApiAccess.AdminApiTools.TestSqlConnection(IUpdateServer
    server)
    at
    Microsoft.UpdateServices.UI.AdminApiAccess.AdminApiTools.GetUpdateServer(String
    serverName, Boolean useSecureConnection, Int32 portNumber)
    at
    Microsoft.UpdateServices.UI.SnapIn.Scope.ServerSummaryScopeNode.GetUpdateServer(PersistedServerSettings
    settings)
    at
    Microsoft.UpdateServices.UI.SnapIn.Scope.ServerSummaryScopeNode.ConnectToServer()
    at
    Microsoft.UpdateServices.UI.SnapIn.Scope.ServerSummaryScopeNode.get_ServerTools()


    You asked for the updates. These were listed with the same dates as the KB
    updates I listed. I am guessing they are updates to the updates of .NET.


    Thanks
    Mark
     
    Mark Morrell, Jan 6, 2008
    #6
  7. Mark Morrell

    Mark Morrell Guest

    Disregard
    I uninstalled and reinstalled.
    Was easier and less time involved.

    Thanks for the help!
    Mark
     
    Mark Morrell, Jan 8, 2008
    #7
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.