locked
Cant complete postinstall Server 2012 Single_User Mode RRS feed

  • Question

  • Well Ive been moving from 2008 R2 to 2012. I didnt think I had any issues until I got to the postinstall step. In Sql 2012 the susdb is stuck in Single_User mode. If I try and change it I get the following error:

    Msg 3605, Level 16, State 1, Line 2
    Schema verification failed for database 'SUSDB'.
    Msg 5069, Level 16, State 1, Line 2
    ALTER DATABASE statement failed.

    OR

    TITLE: Microsoft SQL Server Management Studio
    ------------------------------

    Alter failed for Database 'SUSDB'.  (Microsoft.SqlServer.Smo)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.3000.0+((SQL11_PCU_Main).121019-1325+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476

    ------------------------------
    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    Schema verification failed for database 'SUSDB'.
    ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 3605)

    I'm logged in with admin rights, and using the account I installed under. I don't recall having this issue in 2008. Can anyone help me get passed this?

    thanks

    Tuesday, April 15, 2014 8:14 PM

Answers

  • I uninstalled everything and got a little further. Now getting Failed to start and configure the WSUS service. (its running when I look)

    Here is the log.
    2014-04-15 17:33:29  Postinstall started
    2014-04-15 17:33:29  Detected role services: Api, UI, WidDatabase, Services
    2014-04-15 17:33:29  Start: LoadSettingsFromParameters
    2014-04-15 17:33:29  Content local is: False
    2014-04-15 17:33:29  SQL instname is:
    2014-04-15 17:33:29  End: LoadSettingsFromParameters
    2014-04-15 17:33:29  Start: Run
    2014-04-15 17:33:29  Fetching WsusAdministratorsSid from registry store
    2014-04-15 17:33:29  Value is S-1-5-21-3572222371-3558205439-3559500119-1002
    2014-04-15 17:33:29  Fetching WsusReportersSid from registry store
    2014-04-15 17:33:29  Value is S-1-5-21-3572222371-3558205439-3559500119-1003
    2014-04-15 17:33:29  Configuring content directory...
    2014-04-15 17:33:29  Configuring groups...
    2014-04-15 17:33:29  Starting group configuration for WSUS Administrators...
    2014-04-15 17:33:29  Found group in regsitry, attempting to use it...
    2014-04-15 17:33:31  Writing group to registry...
    2014-04-15 17:33:31  Finished group creation
    2014-04-15 17:33:31  Starting group configuration for WSUS Reporters...
    2014-04-15 17:33:31  Found group in regsitry, attempting to use it...
    2014-04-15 17:33:31  Writing group to registry...
    2014-04-15 17:33:31  Finished group creation
    2014-04-15 17:33:31  Configuring permissions...
    2014-04-15 17:33:31  Fetching content directory...
    2014-04-15 17:33:31  Fetching ContentDir from registry store
    2014-04-15 17:33:31  Value is F:\
    2014-04-15 17:33:31  Fetching group SIDs...
    2014-04-15 17:33:31  Fetching WsusAdministratorsSid from registry store
    2014-04-15 17:33:31  Value is S-1-5-21-3572222371-3558205439-3559500119-1002
    2014-04-15 17:33:31  Fetching WsusReportersSid from registry store
    2014-04-15 17:33:31  Value is S-1-5-21-3572222371-3558205439-3559500119-1003
    2014-04-15 17:33:31  Creating group principals...
    2014-04-15 17:33:31  Granting directory permissions...
    2014-04-15 17:33:32  Granting permissions on content directory...
    2014-04-15 17:33:32  Granting registry permissions...
    2014-04-15 17:33:32  Granting registry permissions...
    2014-04-15 17:33:32  Granting registry permissions...
    2014-04-15 17:33:32  Configuring shares...
    2014-04-15 17:33:32  Configuring network shares...
    2014-04-15 17:33:32  Fetching content directory...
    2014-04-15 17:33:32  Fetching ContentDir from registry store
    2014-04-15 17:33:32  Value is F:\
    2014-04-15 17:33:32  Fetching WSUS admin SID...
    2014-04-15 17:33:32  Fetching WsusAdministratorsSid from registry store
    2014-04-15 17:33:32  Value is S-1-5-21-3572222371-3558205439-3559500119-1002
    2014-04-15 17:33:32  Content directory is local, creating content shares...
    2014-04-15 17:33:33  Creating share "UpdateServicesPackages" with path "F:\UpdateServicesPackages" and description "A network share to be used by client systems for collecting all software packages (usually applications) published on this WSUS system."
    2014-04-15 17:33:33  Deleting existing share...
    2014-04-15 17:33:33  Creating share...
    2014-04-15 17:33:33  Share successfully created
    2014-04-15 17:33:33  Creating share "WsusContent" with path "F:\WsusContent" and description "A network share to be used by Local Publishing to place published content on this WSUS system."
    2014-04-15 17:33:33  Deleting existing share...
    2014-04-15 17:33:33  Creating share...
    2014-04-15 17:33:33  Share successfully created
    2014-04-15 17:33:33  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."
    2014-04-15 17:33:33  Deleting existing share...
    2014-04-15 17:33:33  Creating share...
    2014-04-15 17:33:33  Share successfully created
    2014-04-15 17:33:33  Finished creating content shares
    2014-04-15 17:33:33  Stopping service WSUSService
    2014-04-15 17:36:56  Stopping service W3SVC
    2014-04-15 17:38:27  Configuring WID database...
    2014-04-15 17:38:27  Configuring the database...
    2014-04-15 17:38:27  Establishing DB connection...
    2014-04-15 17:38:27  Checking to see if database exists...
    2014-04-15 17:38:27  Database exists
    2014-04-15 17:38:27  Switching database to single user mode...
    2014-04-15 17:38:30  Loading install type query...
    2014-04-15 17:38:30  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

    2014-04-15 17:38:30  Install type is: Reinstall
    2014-04-15 17:38:30  Creating logins...
    2014-04-15 17:38:30  Fetching account info for S-1-5-20
    2014-04-15 17:38:30  Found principal
    2014-04-15 17:38:30  Found account
    2014-04-15 17:38:30  Got binary SID
    2014-04-15 17:38:30  Fetching WsusAdministratorsSid from registry store
    2014-04-15 17:38:30  Value is S-1-5-21-3572222371-3558205439-3559500119-1002
    2014-04-15 17:38:30  Fetching account info for S-1-5-21-3572222371-3558205439-3559500119-1002
    2014-04-15 17:38:33  Found principal
    2014-04-15 17:38:33  Found account
    2014-04-15 17:38:33  Got binary SID
    2014-04-15 17:38:33  Setting content location...
    2014-04-15 17:38:33  Fetching ContentDir from registry store
    2014-04-15 17:38:33  Value is F:\
    2014-04-15 17:38:33  Swtching DB to multi-user mode......
    2014-04-15 17:38:34  Finished setting multi-user mode
    2014-04-15 17:38:34  Writing DB settings to registry...
    2014-04-15 17:38:34  Marking PostInstall done for UpdateServices-WidDatabase in the registry...
    2014-04-15 17:38:34  Starting service W3SVC
    2014-04-15 17:38:34  Configuring IIS...
    2014-04-15 17:38:34  Start: ConfigureWebsite
    2014-04-15 17:38:35  Configuring website on port 8530
    2014-04-15 17:39:41  2014-04-15 17:38:49  Info      IISCustomAction    Performing Setup Action, Command /Install
    2014-04-15 17:39:39  Info      IISCustomAction    Command /Install Succeeded

    2014-04-15 17:39:41  End: ConfigureWebsite
    2014-04-15 17:39:41  Configuring performance counters...
    2014-04-15 17:39:41  Configuring Stats.NET perf counter...
    2014-04-15 17:39:41  Configuring reporting perf counter...
    2014-04-15 17:39:41  Configuring client webservice perf counter...
    2014-04-15 17:39:41  Configuring server sync webservice perf counter...
    2014-04-15 17:39:41  Configuring API remoting perf counter...
    2014-04-15 17:39:41  Bringing services online...
    2014-04-15 17:39:41  Checking initialization status...
    2014-04-15 17:40:07  StartServer starting...
    2014-04-15 17:40:08  Generating encryption key to write to the registry...
    2014-04-15 17:40:08  Generating encryption key to write to the database...
    2014-04-15 17:40:34  Generation of encryption key to save to the database failed. Error=System.InvalidOperationException: Cannot save configuration because the server is still processing a previous
    configuration change. ---> System.Data.SqlClient.SqlException: spSetConfiguration was called while a Reset Process was Needed/InProgress cannot change Configuration at this time
       at Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
       at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteCommandNoResult()
       at Microsoft.UpdateServices.Internal.NoResultSPHandler.ExecuteStoredProcedure(DBConnection connection)
       at Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String spName, DBParameterCollection args, IExecuteSPHandler handler, Int32 queryTimeoutInSeconds)
       at Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String spName, DBParameterCollection args, IExecuteSPHandler handler)
       at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPSetConfiguration(ConfigurationTableRow row, IDictionary changedLanguages, IEnumerable`1 programKeys)
       --- End of inner exception stack trace ---
       at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPSetConfiguration(ConfigurationTableRow row, IDictionary changedLanguages, IEnumerable`1 programKeys)
       at Microsoft.UpdateServices.Internal.BaseApi.UpdateServerConfiguration.Save(Boolean detectConfigChange)
       at Microsoft.UpdateServices.Setup.StartServer.StartServer.GenerateNewDatabaseEncryptionKey()
    2014-04-15 17:40:34  StartServer encountered errors. Exception=Cannot save configuration because the server is still processing a previous
    configuration change.
    2014-04-15 17:40:34  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)

    The only thing I see is:
    2014-04-15 17:40:34  StartServer encountered errors. Exception=Cannot save configuration because the server is still processing a previous configuration change. Not sure what else to do. I dont see anything going on

    • Marked as answer by Daniel JiSun Wednesday, April 23, 2014 1:52 AM
    Tuesday, April 15, 2014 10:46 PM
  • Ok did a server restart and added another gb of ram to 2 gb from another post and the ImportDefaultDetectoids failed went away.

    Slowly but surely

    • Marked as answer by Daniel JiSun Wednesday, April 23, 2014 1:52 AM
    Tuesday, April 15, 2014 11:25 PM
  • Thanks Lawrence. I was using this guide and perhaps I'm doing it all wrong?

    http://technet.microsoft.com/en-us/library/hh852339.aspx
    Migrate Windows Server Update Services to Windows Server 2012

    Hmmm.. no.. you probably did it right. The procedure is somewhat complicated, convoluted, and I see people have issues with it more often than not. In addition, it was written to document migrating the role to a Windows Server 2008 R2 server, and I'm not even sure the procedures are valid for migration to a Windows Server 2012 server.

    Both servers are using the built in database (WID) not a standalone SQL.

    So... we actually have a couple of choices here. Since you apparently still have the original server available, the simplest way to "migrate" a WSUS server is to just replicate it using the native replication capability.

    1. Ensure the original (WSUS v3.2?) server is patched with KB2734608.
    2. Set synchronization to manual.
    3. Install a fresh WSUS on the new server as a replica of the original.
    4. When the sync/download is completed, reconfigure the new server as an upstream from Microsoft, reset the correct Product Category & Update Classification settings, and enable synchronization from Microsoft.
    5. When the sync with Microsoft completes successfully, point the clients to the new server.
    6. When all of the clients have registered/reported with the new server, take the old one offline.

    Or you could continue "patching up" what you've got, and hope it all cleans itself up in the end. It does seem you've made progress so both are probably legit choices at this point.


    Lawrence Garvin, M.S., MCSA, MCITP:EA, MCDBA
    SolarWinds Head Geek
    Microsoft MVP - Software Packaging, Deployment & Servicing (2005-2014)
    My MVP Profile: http://mvp.microsoft.com/en-us/mvp/Lawrence%20R%20Garvin-32101
    http://www.solarwinds.com/gotmicrosoft
    The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.


    Thursday, April 17, 2014 8:43 PM

All replies

  • Well Ive been moving from 2008 R2 to 2012. I didnt think I had any issues until I got to the postinstall step. In Sql 2012 the susdb is stuck in Single_User mode.

    I suspect it's going to be necessary for us to understand how you got to this point. First, you're migrating from "2008R2 to 2012".. is that Windows or SQL Server? Second, WSUS v3 is not supported on SQL Server 2012. Third, if we're talking about Windows, and "migrating" WSUS v3 to WSUS v6, there's an entirely separate conversation to be had there. Those are a few key points to start with, but there are many other possibilities as well, which will sort themselves out once we get the necessary background.

    Lawrence Garvin, M.S., MCSA, MCITP:EA, MCDBA
    SolarWinds Head Geek
    Microsoft MVP - Software Packaging, Deployment & Servicing (2005-2014)
    My MVP Profile: http://mvp.microsoft.com/en-us/mvp/Lawrence%20R%20Garvin-32101
    http://www.solarwinds.com/gotmicrosoft
    The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.


    Tuesday, April 15, 2014 8:22 PM
  • Thanks Lawrence. I was using this guide and perhaps I'm doing it all wrong?

    http://technet.microsoft.com/en-us/library/hh852339.aspx
    Migrate Windows Server Update Services to Windows Server 2012

    Both servers are using the built in database (WID) not a standalone SQL.

    Tuesday, April 15, 2014 8:27 PM
  • I installed WSUS role and requirements onto 2012
    Added Network Service account to .netxxx and temp in Windows
    Installed 2012 Mgt Studio
    Copied orig server binaries to new server
    (On the new server i did notice there was no WSUS Administrators or Reports group) I assume this is because I have not completed the postinstall yet?

    I backed up the orig database and copied to new server and restored
    RESTORE DATABASE [SUSDB] FROM DISK = N'C:\SUSDB.bak' WITH FILE = 1, MOVE N'SUSDB' TO N'c:\Windows\WID\Data\susdb.mdf', MOVE N'SUSDB_log' TO N'c:\Windows\WID\Data\SUSDB_log.ldf', NOUNLOAD, STATS = 10

    I restarted and according to the doc I should be doing the wsusutil.exe postinstall now

    Tuesday, April 15, 2014 8:32 PM
  • I uninstalled everything and got a little further. Now getting Failed to start and configure the WSUS service. (its running when I look)

    Here is the log.
    2014-04-15 17:33:29  Postinstall started
    2014-04-15 17:33:29  Detected role services: Api, UI, WidDatabase, Services
    2014-04-15 17:33:29  Start: LoadSettingsFromParameters
    2014-04-15 17:33:29  Content local is: False
    2014-04-15 17:33:29  SQL instname is:
    2014-04-15 17:33:29  End: LoadSettingsFromParameters
    2014-04-15 17:33:29  Start: Run
    2014-04-15 17:33:29  Fetching WsusAdministratorsSid from registry store
    2014-04-15 17:33:29  Value is S-1-5-21-3572222371-3558205439-3559500119-1002
    2014-04-15 17:33:29  Fetching WsusReportersSid from registry store
    2014-04-15 17:33:29  Value is S-1-5-21-3572222371-3558205439-3559500119-1003
    2014-04-15 17:33:29  Configuring content directory...
    2014-04-15 17:33:29  Configuring groups...
    2014-04-15 17:33:29  Starting group configuration for WSUS Administrators...
    2014-04-15 17:33:29  Found group in regsitry, attempting to use it...
    2014-04-15 17:33:31  Writing group to registry...
    2014-04-15 17:33:31  Finished group creation
    2014-04-15 17:33:31  Starting group configuration for WSUS Reporters...
    2014-04-15 17:33:31  Found group in regsitry, attempting to use it...
    2014-04-15 17:33:31  Writing group to registry...
    2014-04-15 17:33:31  Finished group creation
    2014-04-15 17:33:31  Configuring permissions...
    2014-04-15 17:33:31  Fetching content directory...
    2014-04-15 17:33:31  Fetching ContentDir from registry store
    2014-04-15 17:33:31  Value is F:\
    2014-04-15 17:33:31  Fetching group SIDs...
    2014-04-15 17:33:31  Fetching WsusAdministratorsSid from registry store
    2014-04-15 17:33:31  Value is S-1-5-21-3572222371-3558205439-3559500119-1002
    2014-04-15 17:33:31  Fetching WsusReportersSid from registry store
    2014-04-15 17:33:31  Value is S-1-5-21-3572222371-3558205439-3559500119-1003
    2014-04-15 17:33:31  Creating group principals...
    2014-04-15 17:33:31  Granting directory permissions...
    2014-04-15 17:33:32  Granting permissions on content directory...
    2014-04-15 17:33:32  Granting registry permissions...
    2014-04-15 17:33:32  Granting registry permissions...
    2014-04-15 17:33:32  Granting registry permissions...
    2014-04-15 17:33:32  Configuring shares...
    2014-04-15 17:33:32  Configuring network shares...
    2014-04-15 17:33:32  Fetching content directory...
    2014-04-15 17:33:32  Fetching ContentDir from registry store
    2014-04-15 17:33:32  Value is F:\
    2014-04-15 17:33:32  Fetching WSUS admin SID...
    2014-04-15 17:33:32  Fetching WsusAdministratorsSid from registry store
    2014-04-15 17:33:32  Value is S-1-5-21-3572222371-3558205439-3559500119-1002
    2014-04-15 17:33:32  Content directory is local, creating content shares...
    2014-04-15 17:33:33  Creating share "UpdateServicesPackages" with path "F:\UpdateServicesPackages" and description "A network share to be used by client systems for collecting all software packages (usually applications) published on this WSUS system."
    2014-04-15 17:33:33  Deleting existing share...
    2014-04-15 17:33:33  Creating share...
    2014-04-15 17:33:33  Share successfully created
    2014-04-15 17:33:33  Creating share "WsusContent" with path "F:\WsusContent" and description "A network share to be used by Local Publishing to place published content on this WSUS system."
    2014-04-15 17:33:33  Deleting existing share...
    2014-04-15 17:33:33  Creating share...
    2014-04-15 17:33:33  Share successfully created
    2014-04-15 17:33:33  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."
    2014-04-15 17:33:33  Deleting existing share...
    2014-04-15 17:33:33  Creating share...
    2014-04-15 17:33:33  Share successfully created
    2014-04-15 17:33:33  Finished creating content shares
    2014-04-15 17:33:33  Stopping service WSUSService
    2014-04-15 17:36:56  Stopping service W3SVC
    2014-04-15 17:38:27  Configuring WID database...
    2014-04-15 17:38:27  Configuring the database...
    2014-04-15 17:38:27  Establishing DB connection...
    2014-04-15 17:38:27  Checking to see if database exists...
    2014-04-15 17:38:27  Database exists
    2014-04-15 17:38:27  Switching database to single user mode...
    2014-04-15 17:38:30  Loading install type query...
    2014-04-15 17:38:30  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

    2014-04-15 17:38:30  Install type is: Reinstall
    2014-04-15 17:38:30  Creating logins...
    2014-04-15 17:38:30  Fetching account info for S-1-5-20
    2014-04-15 17:38:30  Found principal
    2014-04-15 17:38:30  Found account
    2014-04-15 17:38:30  Got binary SID
    2014-04-15 17:38:30  Fetching WsusAdministratorsSid from registry store
    2014-04-15 17:38:30  Value is S-1-5-21-3572222371-3558205439-3559500119-1002
    2014-04-15 17:38:30  Fetching account info for S-1-5-21-3572222371-3558205439-3559500119-1002
    2014-04-15 17:38:33  Found principal
    2014-04-15 17:38:33  Found account
    2014-04-15 17:38:33  Got binary SID
    2014-04-15 17:38:33  Setting content location...
    2014-04-15 17:38:33  Fetching ContentDir from registry store
    2014-04-15 17:38:33  Value is F:\
    2014-04-15 17:38:33  Swtching DB to multi-user mode......
    2014-04-15 17:38:34  Finished setting multi-user mode
    2014-04-15 17:38:34  Writing DB settings to registry...
    2014-04-15 17:38:34  Marking PostInstall done for UpdateServices-WidDatabase in the registry...
    2014-04-15 17:38:34  Starting service W3SVC
    2014-04-15 17:38:34  Configuring IIS...
    2014-04-15 17:38:34  Start: ConfigureWebsite
    2014-04-15 17:38:35  Configuring website on port 8530
    2014-04-15 17:39:41  2014-04-15 17:38:49  Info      IISCustomAction    Performing Setup Action, Command /Install
    2014-04-15 17:39:39  Info      IISCustomAction    Command /Install Succeeded

    2014-04-15 17:39:41  End: ConfigureWebsite
    2014-04-15 17:39:41  Configuring performance counters...
    2014-04-15 17:39:41  Configuring Stats.NET perf counter...
    2014-04-15 17:39:41  Configuring reporting perf counter...
    2014-04-15 17:39:41  Configuring client webservice perf counter...
    2014-04-15 17:39:41  Configuring server sync webservice perf counter...
    2014-04-15 17:39:41  Configuring API remoting perf counter...
    2014-04-15 17:39:41  Bringing services online...
    2014-04-15 17:39:41  Checking initialization status...
    2014-04-15 17:40:07  StartServer starting...
    2014-04-15 17:40:08  Generating encryption key to write to the registry...
    2014-04-15 17:40:08  Generating encryption key to write to the database...
    2014-04-15 17:40:34  Generation of encryption key to save to the database failed. Error=System.InvalidOperationException: Cannot save configuration because the server is still processing a previous
    configuration change. ---> System.Data.SqlClient.SqlException: spSetConfiguration was called while a Reset Process was Needed/InProgress cannot change Configuration at this time
       at Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
       at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteCommandNoResult()
       at Microsoft.UpdateServices.Internal.NoResultSPHandler.ExecuteStoredProcedure(DBConnection connection)
       at Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String spName, DBParameterCollection args, IExecuteSPHandler handler, Int32 queryTimeoutInSeconds)
       at Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String spName, DBParameterCollection args, IExecuteSPHandler handler)
       at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPSetConfiguration(ConfigurationTableRow row, IDictionary changedLanguages, IEnumerable`1 programKeys)
       --- End of inner exception stack trace ---
       at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPSetConfiguration(ConfigurationTableRow row, IDictionary changedLanguages, IEnumerable`1 programKeys)
       at Microsoft.UpdateServices.Internal.BaseApi.UpdateServerConfiguration.Save(Boolean detectConfigChange)
       at Microsoft.UpdateServices.Setup.StartServer.StartServer.GenerateNewDatabaseEncryptionKey()
    2014-04-15 17:40:34  StartServer encountered errors. Exception=Cannot save configuration because the server is still processing a previous
    configuration change.
    2014-04-15 17:40:34  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)

    The only thing I see is:
    2014-04-15 17:40:34  StartServer encountered errors. Exception=Cannot save configuration because the server is still processing a previous configuration change. Not sure what else to do. I dont see anything going on

    • Marked as answer by Daniel JiSun Wednesday, April 23, 2014 1:52 AM
    Tuesday, April 15, 2014 10:46 PM
  • Well I got passed that error by doing this:
    http://social.technet.microsoft.com/Forums/en-US/300a580c-80c7-44e7-905d-9b3299ba0043/rebuild-of-wsus-failed-due-to-reset-process-in-progress?forum=winserverwsus

    Now I am getting this:
    2014-04-15 18:13:04  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.
    The statement has been terminated. ---> 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:4358c7a4-fae3-4471-9a7f-2a18114cc74e
    2014-04-15 18:13:04  StartServer encountered errors. Exception=Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    The statement has been terminated.
    2014-04-15 18:13:04  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)

    Tuesday, April 15, 2014 11:15 PM
  • Ok did a server restart and added another gb of ram to 2 gb from another post and the ImportDefaultDetectoids failed went away.

    Slowly but surely

    • Marked as answer by Daniel JiSun Wednesday, April 23, 2014 1:52 AM
    Tuesday, April 15, 2014 11:25 PM
  • Thanks Lawrence. I was using this guide and perhaps I'm doing it all wrong?

    http://technet.microsoft.com/en-us/library/hh852339.aspx
    Migrate Windows Server Update Services to Windows Server 2012

    Hmmm.. no.. you probably did it right. The procedure is somewhat complicated, convoluted, and I see people have issues with it more often than not. In addition, it was written to document migrating the role to a Windows Server 2008 R2 server, and I'm not even sure the procedures are valid for migration to a Windows Server 2012 server.

    Both servers are using the built in database (WID) not a standalone SQL.

    So... we actually have a couple of choices here. Since you apparently still have the original server available, the simplest way to "migrate" a WSUS server is to just replicate it using the native replication capability.

    1. Ensure the original (WSUS v3.2?) server is patched with KB2734608.
    2. Set synchronization to manual.
    3. Install a fresh WSUS on the new server as a replica of the original.
    4. When the sync/download is completed, reconfigure the new server as an upstream from Microsoft, reset the correct Product Category & Update Classification settings, and enable synchronization from Microsoft.
    5. When the sync with Microsoft completes successfully, point the clients to the new server.
    6. When all of the clients have registered/reported with the new server, take the old one offline.

    Or you could continue "patching up" what you've got, and hope it all cleans itself up in the end. It does seem you've made progress so both are probably legit choices at this point.


    Lawrence Garvin, M.S., MCSA, MCITP:EA, MCDBA
    SolarWinds Head Geek
    Microsoft MVP - Software Packaging, Deployment & Servicing (2005-2014)
    My MVP Profile: http://mvp.microsoft.com/en-us/mvp/Lawrence%20R%20Garvin-32101
    http://www.solarwinds.com/gotmicrosoft
    The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.


    Thursday, April 17, 2014 8:43 PM
  • Thanks Lawrence. Not sure about the moving the role to a w8 server. The doc says:

    This document describes the process to migrate an existing Windows Server Update Services (WSUS) 3.0 SP2 server role to a destination server that is running Windows Server 2012 or Windows Server 2012 R2.

    Anyhow I did get it. Everything is online. The new server is synching fine, sending emails fine and Ive updated all the GPOs. Restarted a few machines and registried reflect the new server. They all appear fine. Ive also since then removed the role from the old server.

    Thursday, April 17, 2014 8:51 PM
  • Thanks Lawrence. Not sure about the moving the role to a w8 server. The doc says:

    This document describes the process to migrate an existing Windows Server Update Services (WSUS) 3.0 SP2 server role to a destination server that is running Windows Server 2012 or Windows Server 2012 R2.

    Sticking my neck out here to be grabbed by a noose.. but I suspect if you compare this incarnation of the document to the incarnation in the Windows Server 2008 R2 documentation set... you'll likely find that the only real changes are adding the references to Windows Server 2012. I'd like to hope I'm wrong, and I'll add a to-do item to my task list to do my own comparisons, but . . .

    Lawrence Garvin, M.S., MCSA, MCITP:EA, MCDBA
    SolarWinds Head Geek
    Microsoft MVP - Software Packaging, Deployment & Servicing (2005-2014)
    My MVP Profile: http://mvp.microsoft.com/en-us/mvp/Lawrence%20R%20Garvin-32101
    http://www.solarwinds.com/gotmicrosoft
    The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.

    Friday, April 18, 2014 6:04 PM