WSUS on Server 2012 R2 on Workstation 11

Discussion in 'Virtualization' started by sandy-bridge, Mar 6, 2015.

  1. sandy-bridge

    sandy-bridge MDL Member

    Feb 19, 2015
    127
    1
    10
    #1 sandy-bridge, Mar 6, 2015
    Last edited by a moderator: Apr 20, 2017
    Hello.

    I am running Windows Server 2012 R2 Essentials on VMWare Workstation 11, and I have a problem with Windows Server Update Services. It fails the post-install configuartion, with the erorr "Failed to start and configure WSUS service". Here's the log file.

    Code:
    2015-03-06 17:11:24  Postinstall started
    2015-03-06 17:11:24  Detected role services: Api, UI, WidDatabase, Services
    2015-03-06 17:11:24  Start: LoadSettingsFromParameters
    2015-03-06 17:11:24  Content local is: False
    2015-03-06 17:11:24  SQL instname is: 
    2015-03-06 17:11:24  End: LoadSettingsFromParameters
    2015-03-06 17:11:25  Start: Run
    2015-03-06 17:11:25  Fetching WsusAdministratorsSid from registry store
    2015-03-06 17:11:25  Value is S-1-5-21-3451436129-195946428-2809620169-1118
    2015-03-06 17:11:25  Fetching WsusReportersSid from registry store
    2015-03-06 17:11:25  Value is S-1-5-21-3451436129-195946428-2809620169-1119
    2015-03-06 17:11:28  Configuring content directory...
    2015-03-06 17:11:28  Configuring groups...
    2015-03-06 17:11:28  Starting group configuration for WSUS Administrators...
    2015-03-06 17:11:28  Found group in regsitry, attempting to use it...
    2015-03-06 17:11:29  Searching for existing group...
    2015-03-06 17:11:30  Existing group was found
    2015-03-06 17:11:30  Writing group to registry...
    2015-03-06 17:11:30  Finished group creation
    2015-03-06 17:11:30  Starting group configuration for WSUS Reporters...
    2015-03-06 17:11:30  Found group in regsitry, attempting to use it...
    2015-03-06 17:11:30  Searching for existing group...
    2015-03-06 17:11:30  Existing group was found
    2015-03-06 17:11:30  Writing group to registry...
    2015-03-06 17:11:30  Finished group creation
    2015-03-06 17:11:30  Configuring permissions...
    2015-03-06 17:11:30  Fetching content directory...
    2015-03-06 17:11:30  Fetching ContentDir from registry store
    2015-03-06 17:11:30  Value is C:\Program Files\Update Services
    2015-03-06 17:11:30  Fetching group SIDs...
    2015-03-06 17:11:30  Fetching WsusAdministratorsSid from registry store
    2015-03-06 17:11:30  Value is S-1-5-21-3451436129-195946428-2809620169-1118
    2015-03-06 17:11:30  Fetching WsusReportersSid from registry store
    2015-03-06 17:11:30  Value is S-1-5-21-3451436129-195946428-2809620169-1119
    2015-03-06 17:11:30  Creating group principals...
    2015-03-06 17:11:32  Granting directory permissions...
    2015-03-06 17:11:33  Granting permissions on content directory...
    2015-03-06 17:11:33  Granting registry permissions...
    2015-03-06 17:11:33  Granting registry permissions...
    2015-03-06 17:11:33  Granting registry permissions...
    2015-03-06 17:11:33  Configuring shares...
    2015-03-06 17:11:34  Configuring network shares...
    2015-03-06 17:11:34  Fetching content directory...
    2015-03-06 17:11:34  Fetching ContentDir from registry store
    2015-03-06 17:11:34  Value is C:\Program Files\Update Services
    2015-03-06 17:11:34  Fetching WSUS admin SID...
    2015-03-06 17:11:34  Fetching WsusAdministratorsSid from registry store
    2015-03-06 17:11:34  Value is S-1-5-21-3451436129-195946428-2809620169-1118
    2015-03-06 17:11:34  Content directory is local, creating content shares...
    2015-03-06 17:11:35  Creating share "UpdateServicesPackages" with path "C:\Program Files\Update Services\UpdateServicesPackages" and description "A network share to be used by client systems for collecting all software packages (usually applications) published on this WSUS system."
    2015-03-06 17:11:36  Deleting existing share...
    2015-03-06 17:11:37  Creating share...
    2015-03-06 17:11:38  Share successfully created
    2015-03-06 17:11:38  Creating share "WsusContent" with path "C:\Program Files\Update Services\WsusContent" and description "A network share to be used by Local Publishing to place published content on this WSUS system."
    2015-03-06 17:11:38  Deleting existing share...
    2015-03-06 17:11:38  Creating share...
    2015-03-06 17:11:38  Share successfully created
    2015-03-06 17:11:38  Creating share "WSUSTemp" with path "C:\Program Files\Update Services\LogFiles\WSUSTemp" and description "A network share used by Local Publishing from a Remote WSUS Console Instance."
    2015-03-06 17:11:38  Deleting existing share...
    2015-03-06 17:11:38  Creating share...
    2015-03-06 17:11:38  Share successfully created
    2015-03-06 17:11:38  Finished creating content shares
    2015-03-06 17:11:38  Stopping service WSUSService
    2015-03-06 17:11:40  Stopping service W3SVC
    2015-03-06 17:11:47  Configuring WID database...
    2015-03-06 17:11:47  Configuring the database...
    2015-03-06 17:11:47  Establishing DB connection...
    2015-03-06 17:11:47  Checking to see if database exists...
    2015-03-06 17:11:52  Database exists
    2015-03-06 17:11:52  Switching database to single user mode...
    2015-03-06 17:11:58  Loading install type query...
    2015-03-06 17:11:58  DECLARE @currentDBVersion       int
    DECLARE @scriptMajorVersion     int = (9600)
    DECLARE @scriptMinorVersion     int = (16384)
    DECLARE @databaseMajorVersion   int 
    DECLARE @databaseMinorVersion   int 
    DECLARE @databaseBuildNumber    nvarchar(10)
    IF NOT EXISTS(SELECT * FROM sys.databases WHERE name='SUSDB')
    BEGIN
        SELECT 1
    END
    ELSE
    BEGIN
        SET @currentDBVersion = (SELECT SchemaVersion FROM SUSDB.dbo.tbSchemaVersion WHERE ComponentName = 'CoreDB')
        SET @databaseBuildNumber = (SELECT BuildNumber FROM SUSDB.dbo.tbSchemaVersion WHERE ComponentName = 'CoreDB')
        DECLARE @delimiterPosition INT = CHARINDEX('.', @databaseBuildNumber)
        IF (@delimiterPosition = 0)
        BEGIN
            RAISERROR('Invalid schema version number', 16, 1) with nowait
            return 
        END 
        SET @databaseMajorVersion = SUBSTRING(@databaseBuildNumber, 1, @delimiterPosition - 1)
        SET @databaseMinorVersion = SUBSTRING(@databaseBuildNumber, (@delimiterPosition + 1), (10 - @delimiterPosition))
        IF @currentDBVersion < 926
        BEGIN
            SELECT 3
        END
        ELSE
        BEGIN
            IF (@scriptMajorVersion > @databaseMajorVersion OR
               (@scriptMajorVersion = @databaseMajorVersion AND @scriptMinorVersion > @databaseMinorVersion))
            BEGIN
                SELECT 2
            END
            ELSE IF (@scriptMajorVersion = @databaseMajorVersion AND
                     @scriptMinorVersion = @databaseMinorVersion)
            BEGIN
                SELECT 0
            END
            ELSE
            BEGIN
                SELECT 4
            END
        END
    END
    
    2015-03-06 17:11:59  Install type is: Reinstall
    2015-03-06 17:11:59  Creating logins...
    2015-03-06 17:11:59  Fetching account info for S-1-5-20
    2015-03-06 17:11:59  Found principal
    2015-03-06 17:11:59  Found account
    2015-03-06 17:11:59  Got binary SID
    2015-03-06 17:12:01  Fetching WsusAdministratorsSid from registry store
    2015-03-06 17:12:01  Value is S-1-5-21-3451436129-195946428-2809620169-1118
    2015-03-06 17:12:01  Fetching account info for S-1-5-21-3451436129-195946428-2809620169-1118
    2015-03-06 17:12:01  Fetching account info for S-1-5-21-3451436129-195946428-2809620169-1118
    2015-03-06 17:12:01  Found principal
    2015-03-06 17:12:01  Found account
    2015-03-06 17:12:01  Got binary SID
    2015-03-06 17:12:01  Setting content location...
    2015-03-06 17:12:01  Fetching ContentDir from registry store
    2015-03-06 17:12:01  Value is C:\Program Files\Update Services
    2015-03-06 17:12:03  Swtching DB to multi-user mode......
    2015-03-06 17:12:15  Finished setting multi-user mode
    2015-03-06 17:12:15  Writing DB settings to registry...
    2015-03-06 17:12:15  Marking PostInstall done for UpdateServices-WidDatabase in the registry...
    2015-03-06 17:12:15  Starting service W3SVC
    2015-03-06 17:12:16  Configuring IIS...
    2015-03-06 17:12:16  Start: ConfigureWebsite
    2015-03-06 17:12:22  Configuring website on port 8530
    2015-03-06 17:13:06  2015-03-06 17:12:43  Info      IISCustomAction    Performing Setup Action, Command /Install 
    2015-03-06 17:13:03  Info      IISCustomAction    Command /Install Succeeded
    
    2015-03-06 17:13:06  End: ConfigureWebsite
    2015-03-06 17:13:06  Configuring performance counters...
    2015-03-06 17:13:06  Configuring Stats.NET perf counter...
    2015-03-06 17:13:06  Configuring reporting perf counter...
    2015-03-06 17:13:06  Configuring client webservice perf counter...
    2015-03-06 17:13:06  Configuring server sync webservice perf counter...
    2015-03-06 17:13:06  Configuring API remoting perf counter...
    2015-03-06 17:13:06  Bringing services online...
    2015-03-06 17:13:06  Checking initialization status... 
    2015-03-06 17:13:35  Database needs initialization.
    2015-03-06 17:13:35  StartServer starting...
    2015-03-06 17:13:35  Generating encryption key to write to the registry...
    2015-03-06 17:13:35  Generating encryption key to write to the database...
    2015-03-06 17:13:42  Generating encryption key succeeded...
    2015-03-06 17:13:42  Setting WSUSService to autostart...
    2015-03-06 17:13:42  WSUSService is set to autostart.
    2015-03-06 17:13:42  Starting WSUSService...
    2015-03-06 17:13:42  WSUSService is now started.
    2015-03-06 17:13:42  Importing default detectoids.
    2015-03-06 17:13:42  Importing CriticalUpdates.xml...
    2015-03-06 17:13:51  Importing Drivers.xml...
    2015-03-06 17:16:22  ImportDefaultDetectoids failed. Exception: System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    Warning: The join order has been enforced because a local join hint is used. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
       at Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
       at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteCommandNoResult()
       at Microsoft.UpdateServices.Internal.DatabaseAccess.CommonDataAccess.ExecuteSPImportUpdate(Int32 upstreamServerLocalId, String xmlUpdateBlob, Byte[] xmlUpdateBlobCompressed, Int32& localRevisionId)
       at Microsoft.UpdateServices.Internal.DatabaseAccess.CommonDataAccess.ImportUpdate(Int32 ussRevLocalId, String xmlUpdateBlob, Byte[] xmlUpdateBlobCompressed, String xmlSdpBlob, Int32& localRevisionId)
       at Microsoft.UpdateServices.Internal.DatabaseAccess.CommonDataAccess.ImportUpdate(Int32 ussRevLocalId, String xmlUpdateBlob, Byte[] xmlUpdateBlobCompressed)
       at Microsoft.UpdateServices.Setup.StartServer.StartServer.ImportDefaultDetectoids()
    ClientConnectionId:baac243a-41a4-402e-a56e-f4be4c529c45
    Error Number:-2,State:0,Class:11
    2015-03-06 17:16:22  StartServer encountered errors. Exception=Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    Warning: The join order has been enforced because a local join hint is used.
    2015-03-06 17:16:22  Microsoft.UpdateServices.Administration.CommandException: Failed to start and configure the WSUS service
       at Microsoft.UpdateServices.Administration.PostInstall.Run()
       at Microsoft.UpdateServices.Administration.PostInstall.Execute(String[] arguments)
    
     
  2. Myrrh

    Myrrh MDL Expert

    Nov 26, 2008
    1,401
    500
    60
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. sandy-bridge

    sandy-bridge MDL Member

    Feb 19, 2015
    127
    1
    10
    Yeah, well, I found a thread on a other forum which instructed me to delete the WSUS Administartion entry in the IIS database. That didn't help.
     
  4. Threat

    Threat Lord of the Files

    Feb 23, 2014
    1,064
    835
    60
    The error is related to SQL. SQL uses the cut down SQL:

    So which are you set to use?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...