locked
Reinstalling WSUS fails miserably RRS feed

  • Question

  • I have an 2012 R2 SCCM server that was configured for Windows Updates.  We made an attempt to use https and PKI certs. There were dns issues that caused others issues, so we reverted everything back to http.  Things were good for a week when we attempted to enable PKI certs one more time.  Everything looked great and was working until I realized that there was an issue with clients reporting back.  I reverted everything again thinking I would try another time.  I then realized that something was wrong with WSUS.  In an failed troubleshooting attempt, I uninstalled the WSUS role, deleted the WSUS IIS entry and application pool, and the other files per a Google recommendation.  I needed to log into the SSMS using an sa account to delete the SUSDB.  

    Once I verified everything was gone, I figured I'd just start fresh and reinstall WSUS.  Everytime, the post installation update fails.  I have uninstalled .NET 4.8 and rebooted countless times only to have the process continually fail.  The farthest I got was the SUSDB finally got reinstalled during the post installation tasks, but then did not complete with an error that says:   System.InvalidOperationException: Security groups have not been configured

    I am trying to open a ticket with MSFT, but it is taking a while so I figured I would ask here.  Be happy to post whatever is needed.  


    Matt Dillon

    Monday, June 22, 2020 8:36 PM

Answers

  • We ended up restoring the server from a few days before I removed WSUS as I needed to get back in business  Problem "solved".  

    Matt Dillon

    • Marked as answer by pugmohone Thursday, June 25, 2020 12:58 PM
    Thursday, June 25, 2020 12:58 PM

All replies

  • Hi Matt Dillon,
     
    Thanks for your posting on this forum.
     
    I guess this phenomenon may be due to WSUS uninstall not complete. It is recommended to try the following steps to fully uninstall WSUS:
    To remove the WSUS completely, we need to:
    1. Remove the following server roles and features through Server Manager:
    Roles: Windows Server Update Server
    features: Windows Server Update Services Tools(at Remote Server Administration Tools -> Role Administration Tools)
    Follow the wizard prompts to complete the deletion. Then restart the server.

    2. After the server is restarted, manually delete the folder or file of the following path:
    - C:\WSUS (this depends on where you choose to install WSUS)
    - C:\Program Files\Update Services

    3. Delete database files
    If you use SQL Server Management Studio to delete a database, you can try as follow.
    In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance. Expand Databases, right-click the database to delete, and then click Delete. Confirm the correct database is selected, and then click OK.

    4. In the IIS Information Services (IIS) Manager, manually remove the WSUS Administration site. Then restart the server. 
    Or, you can also consider using the Powershell command Remove-WebSite -Name "WSUS Administration" for deletion.
     
    After uninstall WSUS totally, please consider reinstalling WSUS role.
     
    If you any updates about this issue, please keep us in touch. I will try my best to help.
     
    Regards,
    Rita 

    Please remember to mark as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Tuesday, June 23, 2020 2:01 AM
  • Thanks for replying.  I have done everything you requested prior to posting here including deleting WSUS file from MMC folder.  I have installed via Server Manager and PowerShell with better results with PowerShell.  The Post-Installation tasks fail after creating SUSDB with System.InvalidOperationException: Security groups have not been configured.



    Matt Dillon

    Tuesday, June 23, 2020 2:13 PM
  • 2020-06-23 13:03:35  Postinstall started
    2020-06-23 13:03:35  Detected role services: Api, Database, UI
    2020-06-23 13:03:35  Start: LoadSettingsFromParameters
    2020-06-23 13:03:35  Content local is: True
    2020-06-23 13:03:35  Content directory is: E:\WSUS
    2020-06-23 13:03:35  SQL instname is: CL3SCCM01
    2020-06-23 13:03:35  End: LoadSettingsFromParameters
    2020-06-23 13:03:35  Start: Run
    2020-06-23 13:03:35  Fetching WsusAdministratorsSid from registry store
    2020-06-23 13:03:35  Value is (null)
    2020-06-23 13:03:35  Configuring database...
    2020-06-23 13:03:35  Configuring the database...
    2020-06-23 13:03:35  Establishing DB connection...
    2020-06-23 13:03:35  Checking to see if database exists...
    2020-06-23 13:03:35  Database does not exist
    2020-06-23 13:03:35  Loading install type query...
    2020-06-23 13:03:35  DECLARE @currentDBVersion       int
    DECLARE @scriptMajorVersion     int = (9600)
    DECLARE @scriptMinorVersion     int = (18694)
    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

    2020-06-23 13:03:35  Install type is: Fresh
    2020-06-23 13:03:35  Creating database...
    2020-06-23 13:03:38  Changed database context to 'SUSDB'.
    2020-06-23 13:03:38  Changed database context to 'SUSDB'.
    2020-06-23 13:03:38  Creating Procedures spDropForeignKeyConstraint
    2020-06-23 13:03:38  Adding function spDropTableColumnIfExists
    2020-06-23 13:03:38  Adding function spAddTableColumnIfNotExists
    2020-06-23 13:03:38  Adding function spDropPrimaryKeyConstraint
    2020-06-23 13:03:38  Creating table dbo.tbPrerequisiteDependency
    2020-06-23 13:03:38  Creating table dbo.tbBundleDependency
    2020-06-23 13:03:38  Creating table tbUpdateStatusPerComputer
    2020-06-23 13:03:38  Creating table tbUpdateSummaryForAllComputers
    2020-06-23 13:03:38  Creating table tbComputerSummaryForMicrosoftUpdates
    2020-06-23 13:03:38  Creating table dbo.tbRequestedTargetGroup
    2020-06-23 13:03:38  Creating table dbo.tbRequestedTargetGroupsForTarget
    2020-06-23 13:03:38  Creating table tbDeletedComputer
    2020-06-23 13:03:38  Creating table dbo.tbComputerTargetDetail
    2020-06-23 13:03:38  Creating table dbo.tbComputerTarget
    2020-06-23 13:03:39  Creating table dbo.tbClientWithRecentNameChange
    2020-06-23 13:03:39  Creating table dbo.tbDownstreamServerTarget
    2020-06-23 13:03:39  Creating table dbo.tbDownstreamServerSummaryRollup
    2020-06-23 13:03:39  Creating table dbo.tbDownstreamServerClientSummaryRollup
    2020-06-23 13:03:39  Creating table dbo.tbDownstreamServerClientActivityRollup
    2020-06-23 13:03:39  Creating table dbo.tbTarget
    2020-06-23 13:03:39  Creating table dbo.tbTargetType
    2020-06-23 13:03:39  Creating table dbo.tbDeployment
    2020-06-23 13:03:39  tbDeployment does not exist, creating it now
    2020-06-23 13:03:39  Creating table dbo.tbDeadDeployment
    2020-06-23 13:03:40  Creating table dbo.tbRevisionLanguage
    2020-06-23 13:03:40  Creating table dbo.tbProperty
    2020-06-23 13:03:40  Creating table dbo.tbRevisionExtendedProperty
    2020-06-23 13:03:40  Creating table dbo.tbKBArticleForRevision
    2020-06-23 13:03:40  Creating table dbo.tbMoreInfoURLForRevision
    2020-06-23 13:03:40  Creating table dbo.tbSecurityBulletinForRevision
    2020-06-23 13:03:40  Creating table dbo.tbLocalizedPropertyForRevision
    2020-06-23 13:03:40  Creating table dbo.tbFileForRevision
    2020-06-23 13:03:40  Creating table dbo.tbFileHash
    2020-06-23 13:03:40  Creating table dbo.tbRevisionSupersedesUpdate
    2020-06-23 13:03:40  Creating table dbo.tbInstalledUpdateSufficientForPrerequisite
    2020-06-23 13:03:40  Creating table dbo.tbBundleAtLeastOne
    2020-06-23 13:03:40  Creating table dbo.tbBundleAll
    2020-06-23 13:03:40  Creating table dbo.tbPrerequisite
    2020-06-23 13:03:40  Creating table dbo.tbDriver
    2020-06-23 13:03:40  Creating table dbo.tbCompatiblePrinterProvider
    2020-06-23 13:03:40  Creating table dbo.tbDriverClass
    2020-06-23 13:03:40  Creating table dbo.tbTargetGroup
    2020-06-23 13:03:40  Creating table dbo.tbFlattenedTargetGroup
    2020-06-23 13:03:40  Creating table dbo.tbTargetGroupType
    2020-06-23 13:03:40  Creating table dbo.tbExpandedTargetInTargetGroup
    2020-06-23 13:03:40  Creating table dbo.tbTargetInTargetGroup
    2020-06-23 13:03:40  Creating table dbo.tbEulaProperty
    2020-06-23 13:03:40  Creating table dbo.tbEulaAcceptance
    2020-06-23 13:03:41  Creating table dbo.tbLocalizedProperty
    2020-06-23 13:03:41  Creating table dbo.tbFile
    2020-06-23 13:03:41  Creating table dbo.tbXml
    2020-06-23 13:03:41  Creating table dbo.tbGroupAuthorization
    2020-06-23 13:03:41  Creating table dbo.tbAuthorization
    2020-06-23 13:03:41  Creating table dbo.tbFileOnServer
    2020-06-23 13:03:41  Creating table dbo.tbFileDownloadProgress
    2020-06-23 13:03:41  Creating table dbo.tbSingletonData
    2020-06-23 13:03:41  Creating table dbo.tbReference
    2020-06-23 13:03:41  Creating table dbo.tbFrontEndServersHealth
    2020-06-23 13:03:41  Creating table dbo.tbConfigurationC
    2020-06-23 13:03:41  Creating table dbo.tbConfigurationB
    2020-06-23 13:03:41  Creating table dbo.tbConfigurationA
    2020-06-23 13:03:41  Creating table dbo.tbConfiguration
    2020-06-23 13:03:41  Creating table dbo.tbImplicitCategory
    2020-06-23 13:03:41  Creating table dbo.tbCategoryInSubscription
    2020-06-23 13:03:41  Creating table dbo.tbLanguageInSubscription
    2020-06-23 13:03:41  Creating table dbo.tbSchedule
    2020-06-23 13:03:41  Creating table dbo.tbEmailNotificationRecipient
    2020-06-23 13:03:41  Creating table dbo.tbRevisionInCategory
    2020-06-23 13:03:41  Creating table dbo.tbCategory
    2020-06-23 13:03:41  Creating table dbo.tbRevision
    2020-06-23 13:03:41  Creating table dbo.tbRevisionExtendedLanguageMask
    2020-06-23 13:03:42  Creating table dbo.tbUpdate
    2020-06-23 13:03:42  Creating table dbo.tbUpdateType
    2020-06-23 13:03:42  Creating table dbo.tbUpdateFlag
    2020-06-23 13:03:42  Creating table dbo.tbHandler
    2020-06-23 13:03:42  Creating table dbo.tbLanguage
    2020-06-23 13:03:42  Creating table dbo.tbCategoryType
    2020-06-23 13:03:42  Creating table dbo.tbStateMachine
    2020-06-23 13:03:42  Creating table dbo.tbStateMachineState
    2020-06-23 13:03:42  Creating table dbo.tbStateMachineEvent
    2020-06-23 13:03:42  Creating table dbo.tbStateMachineTransition
    2020-06-23 13:03:42  Creating table dbo.tbStateMachineEventTransitionLog
    2020-06-23 13:03:42  Adding View vwStateMachineEventTransitionLog
    2020-06-23 13:03:42  Creating table dbo.tbNotificationEvent
    2020-06-23 13:03:42  Creating table dbo.tbChangeTracking
    2020-06-23 13:03:42  Creating table dbo.tbFlattenedRevisionInCategory
    2020-06-23 13:03:42  Creating table dbo.tbServerSyncResult
    2020-06-23 13:03:42  Creating table dbo.tbAutoDeploymentRule
    2020-06-23 13:03:42  Creating table dbo.tbUpdateClassificationInAutoDeploymentRule
    2020-06-23 13:03:42  Creating table dbo.tbCategoryInAutoDeploymentRule
    2020-06-23 13:03:42  Creating table dbo.tbTargetGroupInAutoDeploymentRule
    2020-06-23 13:03:42  Creating table dbo.tbSchemaVersion
    2020-06-23 13:03:42  Creating table dbo.tbSchemaVersionHistory
    2020-06-23 13:03:42  Creating table dbo.tbServerHealth
    2020-06-23 13:03:42  Creating table dbo.tbProgramKeys
    2020-06-23 13:03:42  Creating table tbComputersThatNeedDetailedRollup
    2020-06-23 13:03:42  Adding indexed view ivwApiUpdateRevision
    2020-06-23 13:03:42  Creating Procedure spAddConstraint
    2020-06-23 13:03:42  executing stored PROCEDURE spAddConstraint
    2020-06-23 13:03:42  Adding FUNCTION fn_GetGrade 
    2020-06-23 13:03:42  Adding FUNCTION fnGetOnlineSummaryFlags
    2020-06-23 13:03:42  Adding PROCEDURE spUpdateChangeTrackingNumber
    2020-06-23 13:03:42  Creating PROCEDURE spUpdateChangeTrackingNumber
    2020-06-23 13:03:42  Adding Trigger trOnUpdatingConfiguration
    2020-06-23 13:03:42  Adding Trigger trOnInsertingUpdateStatus
    2020-06-23 13:03:42  Adding Trigger trOnDeletingUpdateStatus
    2020-06-23 13:03:42  Adding Trigger trOnUpdatingUpdateStatus
    2020-06-23 13:03:42  Adding FUNCTION fn_GetBestRevisionForEvaluateDeployment
    2020-06-23 13:03:42  Adding PROCEDURE spMoveEvaluateDeploymentsAsNeeded
    2020-06-23 13:03:42  Adding PROCEDURE spDeleteUneededPrerequisiteDeployments
    2020-06-23 13:03:42  Adding PROCEDURE spDeleteUneededBundleDeployments
    2020-06-23 13:03:42  Adding PROCEDURE spProcessPrerequisitesForRevision
    2020-06-23 13:03:42  Adding TRIGGER trOnUpdatingRevision
    2020-06-23 13:03:43  Adding TRIGGER trOnUpdatingDeployment
    2020-06-23 13:03:43  Adding TRIGGER trOnAddingDeployment
    2020-06-23 13:03:43  The module 'trOnAddingDeployment' depends on the missing object 'dbo.spGetUpdateThrottlingSettings'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:43  The module 'trOnAddingDeployment' depends on the missing object 'dbo.spFireStateMachineEventEx'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:43  Adding PROCEDURE spGetUpdateThrottlingSettings
    2020-06-23 13:03:43  Creating PROCEDURE spGetUpdateThrottlingSettings
    2020-06-23 13:03:43  Adding Trigger trOnDeletingDeployment
    2020-06-23 13:03:43  The module 'trOnDeletingDeployment' depends on the missing object 'dbo.spGetStringFromContextInfo'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:43  Adding trigger trAdjustIsLeaf_reduce 
    2020-06-23 13:03:43  Adding trigger trAdjustPrerequisite 
    2020-06-23 13:03:43  Adding triggers trExpandRevisionInCategory 
    2020-06-23 13:03:43  Adding triggers trExpandFlattenedRevisionInCategory 
    2020-06-23 13:03:43  Adding triggers trExpandRevisionLanguage 
    2020-06-23 13:03:43  Adding triggers trAdjustIsLeaf_increase 
    2020-06-23 13:03:43  Adding trigger trOnAddingUpdatingGroupAuthorization
    2020-06-23 13:03:43  Adding trigger trOnDeletingGroupAuthorization
    2020-06-23 13:03:43  Adding trigger trOnAddingUpdatingAuthorization
    2020-06-23 13:03:43  Adding trigger trOnDeletingAuthorization
    2020-06-23 13:03:43  Adding trigger trOnAddingLanguage
    2020-06-23 13:03:43  Adding trigger trOnChangingLanguage
    2020-06-23 13:03:43  Adding trigger trOnDeletingLanguage
    2020-06-23 13:03:43  Adding trigger trOnAddingDriver
    2020-06-23 13:03:43  Adding trigger trOnDeletingDriver
    2020-06-23 13:03:43  Adding trigger tr_insert_ExpandedTargetInTargetGroup
    2020-06-23 13:03:43  Adding trigger tr_delete_ExpandedTargetInTargetGroup
    2020-06-23 13:03:43  Adding FUNCTION fn_later_date 
    2020-06-23 13:03:43  Adding PROCEDURE spSaveXmlFragment 
    2020-06-23 13:03:43  Creating Procedure spSaveXmlFragment
    2020-06-23 13:03:43  Adding PROCEDURE spGetChildCategories 
    2020-06-23 13:03:43  Creating Procedure spGetChildCategories
    2020-06-23 13:03:43  Adding PROCEDURE spGetUssDeployments 
    2020-06-23 13:03:43  Creating Procedure spGetUssDeployments
    2020-06-23 13:03:43  Adding PROCEDURE spUpdateSubTimestamp 
    2020-06-23 13:03:43  Creating Procedure spUpdateSubTimestamp
    2020-06-23 13:03:43  Adding PROCEDURE spPopulateLanguageInSubscription 
    2020-06-23 13:03:43  Creating Procedure spPopulateLanguageInSubscription
    2020-06-23 13:03:43  Adding PROCEDURE spAddNewLanguage 
    2020-06-23 13:03:43  Creating Procedure spAddNewLanguage
    2020-06-23 13:03:43  Adding PROCEDURE spCheckRevisionExists 
    2020-06-23 13:03:43  Creating Procedure spCheckRevisionExists
    2020-06-23 13:03:43  Adding PROCEDURE spCheckUpdateExists 
    2020-06-23 13:03:43  Creating Procedure spCheckUpdateExists
    2020-06-23 13:03:43  Adding PROCEDURE spGetFilter 
    2020-06-23 13:03:43  Creating procedure spUpdateOnlineSummaryTablesForUpdateVisible
    2020-06-23 13:03:43  Creating procedure spUpdateOnlineSummaryTablesForUpdateNotVisible
    2020-06-23 13:03:43  Creating Procedure spImportUpdate
    2020-06-23 13:03:43  The module 'spImportUpdate' depends on the missing object 'dbo.spFireStateMachineEventEx'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:43  The module 'spImportUpdate' depends on the missing object 'dbo.spPopulateMissingExpandedUpdateContentThrottlingInfo'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:43  Creating Procedure spDeploymentAutomation
    2020-06-23 13:03:43  The module 'spDeploymentAutomation' depends on the missing object 'spDeployUpdate'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:43  The module 'spDeploymentAutomation' depends on the missing object 'dbo.spAddReportingEventInternal'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:43  The module 'spDeploymentAutomation' depends on the missing object 'spDeployUpdate'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:43  The module 'spDeploymentAutomation' depends on the missing object 'dbo.spAddReportingEventInternal'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:43  The module 'spDeploymentAutomation' depends on the missing object 'dbo.spDeclineUpdate'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:43  The module 'spDeploymentAutomation' depends on the missing object 'dbo.spRefreshDeployments'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:43  Creating Procedure spSetInitialDeploymentStatus
    2020-06-23 13:03:43  Creating Procedure spImportUpdateForServerSync
    2020-06-23 13:03:43  Adding FUNCTION fn_FormatError 
    2020-06-23 13:03:43  Adding FUNCTION fn_FormatLog 
    2020-06-23 13:03:43  Adding FUNCTION fn_BuildDeploymentMessage
    2020-06-23 13:03:43  Creating Procedure spSelectProcFortbNotificationEvent
    2020-06-23 13:03:43  Creating Procedure spUpdateProcFortbNotificationEvent
    2020-06-23 13:03:43  Creating Procedure spSelectProcFortbSubscription
    2020-06-23 13:03:43  Creating Procedure spUpdateProcFortbSubscription
    2020-06-23 13:03:43  Creating Procedure spSelectProcFortbRevision
    2020-06-23 13:03:43  Creating Procedure spUpdateProcFortbRevision
    2020-06-23 13:03:43  Creating Procedure spSelectProcFortbFileOnServerDesired
    2020-06-23 13:03:43  Creating Procedure spUpdateProcFortbFileOnServerDesired
    2020-06-23 13:03:43  Creating Procedure spSelectProcFortbFileOnServerActual
    2020-06-23 13:03:43  Creating Procedure spUpdateProcFortbFileOnServerActual
    2020-06-23 13:03:43  Creating Procedure spFireStateMachineEventEx
    2020-06-23 13:03:43  Creating Procedure spFireStateMachineEvent
    2020-06-23 13:03:43  Adding PROCEDURE spGetNotificationEventItem
    2020-06-23 13:03:43  Creating Procedure spGetNotificationEventItem
    2020-06-23 13:03:43  Adding PROCEDURE spGetNotificationEventNamesToWakeUp
    2020-06-23 13:03:43  Creating PROCEDURE spGetNotificationEventNamesToWakeUp
    2020-06-23 13:03:43  The module 'spGetNotificationEventNamesToWakeUp' depends on the missing object 'dbo.spStartCatalogSync'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:43  The module 'spGetNotificationEventNamesToWakeUp' depends on the missing object 'dbo.spWakeUpEmailNotificationAgent'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:43  Adding PROCEDURE spGetNotificationEventNamesToWakeUpOnStartup
    2020-06-23 13:03:43  Creating PROCEDURE spGetNotificationEventNamesToWakeUpOnStartup
    2020-06-23 13:03:43  Adding PROCEDURE spCleanupIntermediateFileStatesOnStartup
    2020-06-23 13:03:43  Creating PROCEDURE spCleanupIntermediateFileStatesOnStartup
    2020-06-23 13:03:43  Adding PROCEDURE spStartCatalogSync
    2020-06-23 13:03:43  Creating Procedure spStartCatalogSync
    2020-06-23 13:03:43  Adding PROCEDURE spCancelCatalogSync
    2020-06-23 13:03:43  Creating Procedure spCancelCatalogSync
    2020-06-23 13:03:43  Adding PROCEDURE spSetHandshakeAnchor
    2020-06-23 13:03:43  Creating Procedure spSetHandshakeAnchor
    2020-06-23 13:03:43  Adding PROCEDURE spResetNotificationState
    2020-06-23 13:03:43  Creating Procedure spResetNotificationState
    2020-06-23 13:03:43  Adding PROCEDURE spGetLocalIdList 
    2020-06-23 13:03:43  Creating Procedure spGetLocalIdList
    2020-06-23 13:03:43  Adding PROCEDURE spQueueCatalogSyncRequest
    2020-06-23 13:03:43  Creating Procedure spQueueCatalogSyncRequest
    2020-06-23 13:03:43  The module 'spQueueCatalogSyncRequest' depends on the missing object 'dbo.spSetSubscriptionProgress'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:43  Adding PROCEDURE spGetSubscriptionProgress
    2020-06-23 13:03:43  Creating Procedure spGetSubscriptionProgress
    2020-06-23 13:03:43  Adding PROCEDURE spSetSubscriptionProgress
    2020-06-23 13:03:43  Creating Procedure spSetSubscriptionProgress
    2020-06-23 13:03:43  Adding PROCEDURE spSetCatalogSyncFail
    2020-06-23 13:03:43  Creating Procedure spSetCatalogSyncFail
    2020-06-23 13:03:43  Adding PROCEDURE spNotifySyncCancel
    2020-06-23 13:03:43  Creating Procedure spNotifySyncCancel
    2020-06-23 13:03:43  Adding PROCEDURE spSyncWorkDone
    2020-06-23 13:03:43  Creating Procedure spSyncWorkDone
    2020-06-23 13:03:43  Adding PROCEDURE spGetNextQueuedSubscription
    2020-06-23 13:03:43  Creating Procedure spGetNextQueuedSubscription
    2020-06-23 13:03:43  Adding PROCEDURE spGetSubscriptionState
    2020-06-23 13:03:43  Creating Procedure spGetSubscriptionState
    2020-06-23 13:03:43  Adding PROCEDURE spFixCatalogSyncStates
    2020-06-23 13:03:43  Creating Procedure spFixCatalogSyncStates
    2020-06-23 13:03:43  Creating Procedure spCancelFilesAndRelatedRevisions
    2020-06-23 13:03:43  Creating Procedure spDeactivateDeploymentsAndNotifyParentRevisionsChildNotReady
    2020-06-23 13:03:43  Creating Procedure spCheckRevisionsNeedingFile
    2020-06-23 13:03:43  The module 'spCheckRevisionsNeedingFile' depends on the missing object 'dbo.spNotifyFileActualStateImportNeeded'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:43  Creating Procedure spNotifyFileActualStateMUUrlNeeded
    2020-06-23 13:03:43  Creating Procedure spNotifyFileActualStateDownloadNeeded
    2020-06-23 13:03:43  Creating Procedure spNotifyFileActualStateImportNeeded
    2020-06-23 13:03:43  Creating Procedure spNotifyFileActualStateNotNeeded
    2020-06-23 13:03:43  Creating Procedure spNotifyActualStateAndRevisionsFileCancelled
    2020-06-23 13:03:43  Creating Procedure spWakeUpContentAgent
    2020-06-23 13:03:43  Creating Procedure spRemoveFileFromProgress
    2020-06-23 13:03:43  Creating Procedure spRemoveFileFromProgressAndWakeUpContentAgent
    2020-06-23 13:03:43  Creating Procedure spNotifyRevisionsFileReady
    2020-06-23 13:03:43  Creating Procedure spNotifyRevisionsFileFailed
    2020-06-23 13:03:43  Creating Procedure spCheckFileDesiredState
    2020-06-23 13:03:43  Creating Procedure spCheckFileDownloadQueue
    2020-06-23 13:03:43  Creating Procedure spCheckDesiredStateAndNotifyRevisionsFileReady
    2020-06-23 13:03:43  Creating Procedure spCheckFileDownloadQueueAndNotifyRevisionsFileFailed
    2020-06-23 13:03:43  Creating Procedure spCheckDesiredStateAndNotifyRevisionsFileFailed
    2020-06-23 13:03:43  Creating Procedure spNotifyRevisionsFileNotReadyAndCheckDesiredState
    2020-06-23 13:03:44  Creating Procedure spCheckFileDownloadQueueAndRemoveFileFromProgress
    2020-06-23 13:03:44  Creating Procedure spCheckFileDownloadQueueAndDesiredState
    2020-06-23 13:03:44  Creating Procedure spUpdateQueueEntryTimeAndCheckFileDownloadQueue
    2020-06-23 13:03:44  Creating Procedure spNotifyContentSyncNotificationEventWorking
    2020-06-23 13:03:44  Creating Procedure spGetNextContentSyncWorkItem
    2020-06-23 13:03:44  Creating Procedure spGetNextContentSyncWorkItemOnStartup
    2020-06-23 13:03:44  Creating PROCEDURE spUpdateFileDownloadProgress
    2020-06-23 13:03:44  Creating Procedure spSetFileMUUrl
    2020-06-23 13:03:44  Creating Procedure spGetUpdatesForFile
    2020-06-23 13:03:44  Creating Procedure spRetrieveFileDigestFromRowID
    2020-06-23 13:03:44  Creating Procedure spNotifyEulaFilesNeeded
    2020-06-23 13:03:44  The module 'spNotifyEulaFilesNeeded' depends on the missing object 'dbo.spCheckEulasAndChildRevisionsReady'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:44  Creating Procedure spCheckRevisionInstallationPossibility
    2020-06-23 13:03:44  Creating Procedure spNotifyParentsEulasReadyAndCheckRevisionInstallationPossibility
    2020-06-23 13:03:44  Creating Procedure spCheckRevisionNeededAndNotifyParentsChildInstallationPossible
    2020-06-23 13:03:44  Adding procedure spAddDownstreamServerToTargetGroup
    2020-06-23 13:03:44  The module 'spAddDownstreamServerToTargetGroup' depends on the missing object 'dbo.spDeployRevisionToDss'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:44  The module 'spAddDownstreamServerToTargetGroup' depends on the missing object 'dbo.spAddTargetToTargetGroup'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:44  Adding procedure spPreregisterDownstreamServer
    2020-06-23 13:03:44  The module 'spPreregisterDownstreamServer' depends on the missing object 'dbo.spCreateTargetEntry'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:44  Adding PROCEDURE spGetDssTargetGroup 
    2020-06-23 13:03:44  Adding PROCEDURE spUpdateDownstreamServerID 
    2020-06-23 13:03:44  Adding PROCEDURE spReturnStateMachineTransitionEventLogEntriesFromError
    2020-06-23 13:03:44  Creating Procedure spReturnStateMachineTransitionEventLogEntriesFromError
    2020-06-23 13:03:44  Creating Procedure spCheckFilesAndChildRevisionsReady
    2020-06-23 13:03:44  Creating Procedure spNotifyFilesAndChildRevisionsNeeded
    2020-06-23 13:03:44  Creating Procedure spActivateDeploymentsAndNotifyParentRevisionsChildReady
    2020-06-23 13:03:44  Creating Procedure spFailParentRevisions
    2020-06-23 13:03:44  Creating Procedure spCheckEulasAndChildRevisionsReady
    2020-06-23 13:03:44  Creating Procedure spDeactivateDeploymentsNotifyFilesNotNeeded
    2020-06-23 13:03:45  Creating Procedure spResetStateMachineAndReEvaluate
    2020-06-23 13:03:45  Creating Procedures spCancelAllNotReadyRevisions
    2020-06-23 13:03:45  Creating Procedures spDownloadAllNotNeededRevisions
    2020-06-23 13:03:45  Creating Procedures spWakeUpResetAgent
    2020-06-23 13:03:45  Creating Procedures spWakeUpEmailNotificationAgent
    2020-06-23 13:03:45  Creating Procedures spNotifyResetAgentNotificationEventWorking
    2020-06-23 13:03:45  Creating Procedures spNotifyResetAgentNotificationEventDone
    2020-06-23 13:03:45  Creating Procedures spWakeUpRollupAgent
    2020-06-23 13:03:45  Creating Procedures spNotifyRollupAgentNotificationEventWorking
    2020-06-23 13:03:45  Creating Procedures spNotifyRollupAgentNotificationEventDone
    2020-06-23 13:03:45  Creating Procedures spNotifyEmailNotificationAgentNotificationEventWorking
    2020-06-23 13:03:45  Creating Procedures spNotifyEmailNotificationAgentNotificationEventDone
    2020-06-23 13:03:45  Creating Procedure spSaveUssHostOnMU
    2020-06-23 13:03:45  Creating Procedure spRetrieveUssHostOnMU
    2020-06-23 13:03:45  Creating Procedure spGetLastServerSyncCookie 
    2020-06-23 13:03:45  Creating Procedure spSetLastServerSyncCookie 
    2020-06-23 13:03:45  Creating Procedure spResetServer 
    2020-06-23 13:03:45  Creating Procedure spGetLastSyncTime 
    2020-06-23 13:03:45  Creating Procedure spSetLastSyncTime 
    2020-06-23 13:03:45  The module 'spSetLastSyncTime' depends on the missing object 'dbo.spMarkComputerAsNeedingDetailedRollup'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:45  The module 'spSetLastSyncTime' depends on the missing object 'spIsRegistrationRequired'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:45  Creating Procedure spIsRegistrationRequired 
    2020-06-23 13:03:45  Creating Procedure spGetComputerTargetGroup 
    2020-06-23 13:03:45  The module 'spGetComputerTargetGroup' depends on the missing object 'dbo.spMarkComputerAsNeedingDetailedRollup'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:45  The module 'spGetComputerTargetGroup' depends on the missing object 'dbo.spMarkComputerAsNeedingDetailedRollup'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:45  Creating Procedure spCheckForClientNameChange 
    2020-06-23 13:03:45  Creating Procedure spGetFrontEndServers 
    2020-06-23 13:03:45  Creating Procedure spRemoveFrontEndServer 
    2020-06-23 13:03:45  Creating Procedure spGetClientsWithRecentNameChange 
    2020-06-23 13:03:45  Creating Procedure spGetComputerTargetGroupEx 
    2020-06-23 13:03:45  The module 'spGetComputerTargetGroupEx' depends on the missing object 'dbo.spDeleteComputer'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:45  The module 'spGetComputerTargetGroupEx' depends on the missing object 'dbo.spMarkComputerAsNeedingDetailedRollup'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:45  The module 'spGetComputerTargetGroupEx' depends on the missing object 'dbo.spMarkComputerAsNeedingDetailedRollup'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:45  Adding PROCEDURE spRegisterComputer 
    2020-06-23 13:03:45  The module 'spRegisterComputer' depends on the missing object 'dbo.spMarkComputerAsNeedingDetailedRollup'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:45  Creating Procedure spSetBatchURL
    2020-06-23 13:03:45  Creating Procedure spUpdateServerHealthStatus
    2020-06-23 13:03:46  Creating PROCEDURE spGetExportData
    2020-06-23 13:03:46  Creating Procedure spGetExportUpdateData
    2020-06-23 13:03:46  Adding PROCEDURE spGetDataForSyncPackage
    2020-06-23 13:03:46  Creating Procedure spGetDataForSyncPackage
    2020-06-23 13:03:48  Creating Procedure spGetBundedByDataForSyncPackage
    2020-06-23 13:03:48  Creating Procedure spGetUpdateDataForSyncPackage
    2020-06-23 13:03:48  Creating Procedure spGetUpdateTypeByRevisionID
    2020-06-23 13:03:48  Creating Procedure spEnableReplica
    2020-06-23 13:03:48  Creating Procedure spGetAllExplicitComputerDeployments
    2020-06-23 13:03:48  Adding procedure spGetUpdatesForBulkHideInReplicaSync
    2020-06-23 13:03:48  Adding Procedure spDeleteRevision
    2020-06-23 13:03:49  Creating Procedure spGetCompressionThesholds
    2020-06-23 13:03:49  Adding Procedure spGetUpdatesWithPermanantlyInactiveDeployments
    2020-06-23 13:03:49  Adding Procedure spDeleteDeploymentsForUpdatesWithPermanantlyInactiveDeployments
    2020-06-23 13:03:49  The module 'spDeleteDeploymentsForUpdatesWithPermanantlyInactiveDeployments' depends on the missing object 'dbo.spSetStringInContextInfo'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:49  Adding Procedure spSetUpdateFlagCatalogSite
    2020-06-23 13:03:49  Adding Procedure spGetUpdatesWithCatalogSiteFlag
    2020-06-23 13:03:49  Adding Procedure spMarkComputerAsNeedingDetailedRollup
    2020-06-23 13:03:49  Adding Procedure spMarkComputerAsDeletedForDss
    2020-06-23 13:03:49  Adding Procedure spUpdateDownstreamServerTarget
    2020-06-23 13:03:49  The module 'spUpdateDownstreamServerTarget' depends on the missing object 'dbo.spCreateTargetEntry'. The module will still be created; however, it cannot run successfully until the object exists.
    2020-06-23 13:03:49  Adding Procedure spUpdateDownstreamServerSummaryRollup
    2020-06-23 13:03:49  Adding Procedure spUpdateDownstreamServerClientSummaryRollup
    2020-06-23 13:03:51  Adding Procedure spUpdateDownstreamServerClientActivityRollup
    2020-06-23 13:03:51  Adding Procedure spGetDownstreamServerClientSummaries
    2020-06-23 13:03:51  Adding Procedure spClearAllClientActivityCounts
    2020-06-23 13:03:51  Adding Procedure spGetClientSummaryForAllServers
    2020-06-23 13:03:51  Adding Procedure spGetClientActivityForAllServers
    2020-06-23 13:03:51  Adding Procedure spSetLastTimeReportToMU
    2020-06-23 13:03:51  Adding Procedure spGetLastTimeReportToMU
    2020-06-23 13:03:51  Adding PROCEDURE spGetTempContentCache
    2020-06-23 13:03:51  Creating PROCEDURE spGetTempContentCache
    2020-06-23 13:03:51  Creating PROCEDURE spPopulateMissingExpandedUpdateContentThrottlingInfo
    2020-06-23 13:03:51  Creating PROCEDURE spSetStringInContextInfo
    2020-06-23 13:03:51  Creating PROCEDURE spGetStringFromContextInfo
    2020-06-23 13:03:51  Creating PROCEDURE spSetOfflineSyncExclusionList
    2020-06-23 13:03:51  Creating PROCEDURE spGetEncryptedProxyPasswordFromDatabaseForUpgrade
    2020-06-23 13:03:51  Creating PROCEDURE spResetDssRequestedStateForFiles
    2020-06-23 13:03:51  Creating PROCEDURE spAllowComputersWithDuplicateNames
    2020-06-23 13:03:51  Creating PROCEDURE spGetAllUpdateUrls
    2020-06-23 13:03:51  Creating PROCEDURE spGetStartServerInitializationStatus
    2020-06-23 13:03:51  Creating PROCEDURE spSetStartServerInitializationStatus
    2020-06-23 13:03:51  Changed database context to 'SUSDB'.
    2020-06-23 13:03:51  Adding function fnGetConfigurationValue
    2020-06-23 13:03:51  Adding view vwConfiguration 
    2020-06-23 13:03:51  Adding PROCEDURE spConfiguration 
    2020-06-23 13:03:51  Creating Procedure spConfiguration
    2020-06-23 13:03:51  Creating Procedure spGetUpstreamServerInfo
    2020-06-23 13:03:51  Adding PROCEDURE spGetUpdateXmlFromRevision 
    2020-06-23 13:03:51  Creating Procedure spGetUpdateXmlFromRevision
    2020-06-23 13:03:52  Adding PROCEDURE spGetChangeTrackingInformation
    2020-06-23 13:03:52  Creating PROCEDURE spGetChangeTrackingInformation
    2020-06-23 13:03:52  Adding PROCEDURE spGetChangeTrackingNumber
    2020-06-23 13:03:52  Creating PROCEDURE spGetChangeTrackingNumber
    2020-06-23 13:03:52  Adding procedure spGetAllLanguagesWithEnabledState
    2020-06-23 13:03:52  Adding procedure spCheckConnection
    2020-06-23 13:03:52  Adding procedure spGetChangeTrackingNumbersForCache
    2020-06-23 13:03:52  Adding procedure spGetLanguageListForCache
    2020-06-23 13:03:52  Adding procedure spGetRevisionIdListForCache
    2020-06-23 13:03:52  Adding Procedure spGetRelatedRevisionsForUpdateID
    2020-06-23 13:03:52  Adding Procedure spGetAllUpdateIDs
    2020-06-23 13:03:52  Adding procedure spGetProgramKeys
    2020-06-23 13:03:52  Creating Procedure spGetUpdateDecryptionData
    2020-06-23 13:03:52  Creating Procedure spSetUpdateDecryptionData
    2020-06-23 13:03:52  Changed database context to 'SUSDB'.
    2020-06-23 13:03:52  Creating Function fnCsvToInt
    2020-06-23 13:03:52  Creating Function fnCsvToUniqueID
    2020-06-23 13:03:52  Creating Procedure spGetCoreUpdateXml
    2020-06-23 13:03:52  Creating Procedure spGetLocalizedUpdateXml
    2020-06-23 13:03:52  Creating Procedure spGetLocaleNames
    2020-06-23 13:03:52  Creating Procedure spGetGlobalUpdates
    2020-06-23 13:03:52  Creating Procedure spGetHardwareDrivers
    2020-06-23 13:03:52  Creating Procedure spGetMonitorableStatus
    2020-06-23 13:03:52  Creating Procedure spGetFileLocations
    2020-06-23 13:03:52  Adding procedure spGetAllTargetGroups
    2020-06-23 13:03:52  Creating Procedure spGetFrontEndServerInfo
    2020-06-23 13:03:52  Creating Procedure spSetFrontEndServerInfo
    2020-06-23 13:03:52  Creating Procedure spSetFileLocationChange
    2020-06-23 13:03:52  Creating Procedure spGetRevisionInfo
    2020-06-23 13:03:53  Creating Procedure spGetDeltaRevisionInfo
    2020-06-23 13:03:53  Changed database context to 'SUSDB'.
    2020-06-23 13:03:53  Adding procedure spAdduser
    2020-06-23 13:03:53  Adding procedure spGrantAsp 
    2020-06-23 13:03:53  Adding procedure spSetupLogin
    2020-06-23 13:03:53  Adding procedure spSetContentCacheLocation
    2020-06-23 13:03:53  Adding procedure spSetDefaults
    2020-06-23 13:03:53  Adding database version 
    2020-06-23 13:03:53  Changed database context to 'SUSDB'.
    2020-06-23 13:03:53  Creating table tbEventMessageTemplate
    2020-06-23 13:03:53  Creating table tbEventInstance
    2020-06-23 13:03:53  Creating table tbEvent
    2020-06-23 13:03:53  Creating table tbEventSource
    2020-06-23 13:03:53  Creating table tbEventNamespace
    2020-06-23 13:03:53  Alter table tbEvent with foreign key
    2020-06-23 13:03:53  Alter table tbEventSource with foreign key
    2020-06-23 13:03:53  Alter table tbEventMessageTemplate with foreign key
    2020-06-23 13:03:53  Alter table tbEventInstance with foreign keys
    2020-06-23 13:03:53  Adding procedure spImportEventNamespaceDescriptor
    2020-06-23 13:03:53  Adding procedure spAutoPurgeReportingEvents 
    2020-06-23 13:03:53  Adding procedure spLoadReportingEventAttributes
    2020-06-23 13:03:53  Changed database context to 'SUSDB'.
    2020-06-23 13:03:53  Creating table tbLocaleMap
    2020-06-23 13:03:53  Creating table tbOSMap
    2020-06-23 13:03:53  Creating table tbDownstreamServerRollupConfiguration
    2020-06-23 13:03:53  Creating table tbEventRollupCounters
    2020-06-23 13:03:53  Adding function fnFindOsID 
    2020-06-23 13:03:53  Adding function fnGetSummarizationState 
    2020-06-23 13:03:53  Adding function fnGetEffectiveDeployment 
    2020-06-23 13:03:53  Adding function fnGetTargetGroupIDForComputer
    2020-06-23 13:03:53  Adding procedure spAddReportingEventBatch 
    2020-06-23 13:03:54  Adding procedure spProcessActivityEvents 
    2020-06-23 13:03:54  Adding procedure spAddReportingEventInternal 
    2020-06-23 13:03:54  Adding procedure spAddUpdateStatusEventBatch 
    2020-06-23 13:03:54  Adding procedure spHandleClientRebootedEvent 
    2020-06-23 13:03:54  Adding procedure spUpdateLatestRollupEventTime
    2020-06-23 13:03:54  Adding procedure spGetCurrentSqlServerTime
    2020-06-23 13:03:54  Adding procedure spGetLatestRollupEventTime
    2020-06-23 13:03:54  Adding procedure spUpdateCurrentRollupState
    2020-06-23 13:03:54  Adding procedure spGetCurrentRollupState
    2020-06-23 13:03:54  Adding procedure spGetRollupCounter
    2020-06-23 13:03:54  Adding procedure spUpdateRollupCounter
    2020-06-23 13:03:54  Adding procedure spSetLastRollupInfo
    2020-06-23 13:03:54  Adding procedure spGetLastRollupInfo
    2020-06-23 13:03:54  Adding procedure spResetOnlineSummaryTables
    2020-06-23 13:03:54  Changed database context to 'SUSDB'.
    2020-06-23 13:03:54  Adding procedure spGetComputersToRollup
    2020-06-23 13:03:54  Adding procedure spMarkComputersAsNeedingFullComputerRollup
    2020-06-23 13:03:54  Adding procedure spUpdateComputersAfterRollup
    2020-06-23 13:03:54  Adding procedure spAddRollupComputers
    2020-06-23 13:03:54  Adding procedure spGetComputerLastRollupNumbers
    2020-06-23 13:03:54  Adding procedure spGetOutOfSyncComputers
    2020-06-23 13:03:54  Adding procedure spMarkComputersAsNeedingFullStatusRollup
    2020-06-23 13:03:54  Adding procedure spGetComputerStatusToRollup
    2020-06-23 13:03:54  Adding procedure spUpdateComputerStatusAfterRollup
    2020-06-23 13:03:54  Adding procedure spAddRollupStatus
    2020-06-23 13:03:54  Adding procedure spAddRollupStatusNoStatus
    2020-06-23 13:03:54  Adding procedure spMarkDataForFullRollup
    2020-06-23 13:03:54  Changed database context to 'SUSDB'.
    2020-06-23 13:03:54  Adding function fnMapLocalUpdateIDToGlobal 
    2020-06-23 13:03:54  Adding function fnMapGlobalToLocalUpdateID 
    2020-06-23 13:03:54  Adding function fnHasStaleDeployments
    2020-06-23 13:03:54  Adding function fnHasSupersededUpdates
    2020-06-23 13:03:54  Adding function fnIsEulaAcceptanceRequired
    2020-06-23 13:03:54  Adding function fnGetTargetGroupTypeID
    2020-06-23 13:03:54  Adding function fnGetComputerTargetID 
    2020-06-23 13:03:54  Adding function fnGetLatestRevisionNumber
    2020-06-23 13:03:54  Adding function fnIsInReplicaMode
    2020-06-23 13:03:54  Adding function fnComputeAutoApprovalDeadline
    2020-06-23 13:03:54  Adding view vwUpdatesToReport
    2020-06-23 13:03:54  Adding view vwUpdateInCategory
    2020-06-23 13:03:54  Adding view vwApiUpdateType
    2020-06-23 13:03:54  Adding view vwMinimalUpdate 
    2020-06-23 13:03:54  Adding view vwUpdateLanguage 
    2020-06-23 13:03:54  Adding view vwDefaultLocalizedProperty 
    2020-06-23 13:03:54  Adding view vwUpdateLocalizedProperties 
    2020-06-23 13:03:54  Adding view vwCategoryProperties 
    2020-06-23 13:03:54  Adding view vwEventHistory 
    2020-06-23 13:03:54  Adding function fnTbUpdateTypeNamesToGet
    2020-06-23 13:03:54  Adding function fnTbComputersInTargetGroup
    2020-06-23 13:03:54  Adding procedure spFilterUpdatesByScopeInternal
    2020-06-23 13:03:54  Adding procedure spGetCategories
    2020-06-23 13:03:54  Adding procedure spGetTopLevelCategories
    2020-06-23 13:03:54  Adding procedure spGetCategoryPropertiesByID
    2020-06-23 13:03:54  Adding procedure spGetSubCategoriesByUpdateID
    2020-06-23 13:03:54  Adding procedure spGetUpdatesUnderACategory
    2020-06-23 13:03:54  Adding procedure spGetTotalSummary
    2020-06-23 13:03:54  Adding procedure spGetSummariesPerComputer
    2020-06-23 13:03:54  Adding procedure spGetSummariesPerUpdate
    2020-06-23 13:03:54  Adding procedure spGetTotalUpdateSummaryForTargetGroup
    2020-06-23 13:03:55  Adding procedure spGetUpdateSummariesForTargetGroup
    2020-06-23 13:03:55  Adding procedure spGetTotalSummaryForComputer
    2020-06-23 13:03:55  Adding procedure spGetComputerSummariesForTargetGroup
    2020-06-23 13:03:55  Adding procedure spGetTargetGroupSummariesForUpdate
    2020-06-23 13:03:55  Adding procedure spGetUpdateSummaryForSingleTargetGroup
    2020-06-23 13:03:55  Adding procedure spGetTotalSummaryForCategory
    2020-06-23 13:03:55  Adding procedure spGetUpdateSummariesForCategory
    2020-06-23 13:03:55  Adding procedure spGetComputerSummariesForCategory
    2020-06-23 13:03:55  Adding procedure spGetUpdateInstallationInfoForUpdate
    2020-06-23 13:03:55  Adding procedure spGetUpdateInstallationInfoForComputer 
    2020-06-23 13:03:55  Adding procedure spGetUpdateInstallationInfoForTargetGroup
    2020-06-23 13:03:55  Adding procedure spDeployRevisionToDss
    2020-06-23 13:03:55  Adding procedure spGetAutoDeploymentRuleByID
    2020-06-23 13:03:55  Adding procedure spSaveParsedExtendedProperties
    2020-06-23 13:03:55  Adding procedure spGetUpdatesAndDeployments
    2020-06-23 13:03:55  Adding procedure spSetAutoDeploymentRule
    2020-06-23 13:03:55  Adding procedure spGetAutoDeploymentRuleIDs
    2020-06-23 13:03:55  Adding procedure spCreateAutoDeploymentRule
    2020-06-23 13:03:55  Adding procedure spDeleteAutoDeploymentRuleByID
    2020-06-23 13:03:55  Adding procedure spGetUpdateListToApproveForAutoDeploymentRule
    2020-06-23 13:03:55  Adding procedure spGetComputersNotContactedSinceCount
    2020-06-23 13:03:55  Adding procedure spDeclineUpdate
    2020-06-23 13:03:55  Adding procedure spGetParentCategories
    2020-06-23 13:03:55  Adding procedure spSearchUpdates 
    2020-06-23 13:03:55  Adding procedure spGetAllUpdates 
    2020-06-23 13:03:55  Adding procedure spGetUpdateCount
    2020-06-23 13:03:55  Adding procedure spGetRevisions
    2020-06-23 13:03:55  Adding procedure spGetComputerTargetByName
    2020-06-23 13:03:55  Adding procedure spSimpleSearchComputers
    2020-06-23 13:03:55  Adding procedure spSimpleSearchUpdates 
    2020-06-23 13:03:55  Adding procedure spGetEulaFiles
    2020-06-23 13:03:55  Adding procedure spGetShortLanguage
    2020-06-23 13:03:55  Adding procedure spGetEulaAcceptances
    2020-06-23 13:03:55  Adding procedure spAcceptEula
    2020-06-23 13:03:55  Adding procedure spAcceptEulaForReplicaDSS
    2020-06-23 13:03:55  Adding procedure spRecurseInsertCategoriesIntoFlatTable
    2020-06-23 13:03:55  Adding procedure spInsertCategoriesIntoFlatTable
    2020-06-23 13:03:55  Adding procedure spRepairPrecomputedTables
    2020-06-23 13:03:55  Adding procedure spGetInstallableItems
    2020-06-23 13:03:55  Adding PROCEDURE spGetApprovedUpdateMetadata 
    2020-06-23 13:03:55  Creating Procedure spGetApprovedUpdateMetadata
    2020-06-23 13:03:55  Adding procedure spHasApprovalsChanged
    2020-06-23 13:03:55  Adding procedure spGetUpdateByID
    2020-06-23 13:03:55  Adding procedure spGetUpdatesBundledByUpdate
    2020-06-23 13:03:55  Adding procedure spGetUpdatesThatBundleUpdate
    2020-06-23 13:03:55  Adding procedure spGetUpdatesSupersededByUpdate
    2020-06-23 13:03:55  Adding procedure spGetUpdatesThatSupersedeUpdate
    2020-06-23 13:03:55  Adding procedure spGetUpdatesRequiredByUpdate
    2020-06-23 13:03:55  Adding procedure spGetUpdatesThatRequireUpdate
    2020-06-23 13:03:55  Adding procedure spGetLanguagesForUpdate
    2020-06-23 13:03:55  Adding procedure spGetContentDownloadProgress
    2020-06-23 13:03:55  Adding procedure spCancelDownload
    2020-06-23 13:03:55  Adding procedure spCancelAllDownloads
    2020-06-23 13:03:55  Adding procedure spResumeDownload
    2020-06-23 13:03:55  Adding procedure spResumeAllDownloads
    2020-06-23 13:03:55  Adding procedure spSetConfiguration 
    2020-06-23 13:03:55  Adding Procedure spSetRollupConfiguration
    2020-06-23 13:03:55  Adding procedure spGetResetStateMachineNeededFlag
    2020-06-23 13:03:55  Adding procedure spDeleteDeployment
    2020-06-23 13:03:55  Adding procedure spCreateImplicitDeployment
    2020-06-23 13:03:55  Adding procedure spUndeclineUpdate
    2020-06-23 13:03:55  Adding procedure spDeployUpdate
    2020-06-23 13:03:55  Adding procedure spGetDeploymentByID 
    2020-06-23 13:03:55  Adding procedure spGetDeploymentsForAnUpdate
    2020-06-23 13:03:55  Adding procedure spGetDeployments
    2020-06-23 13:03:55  Adding procedure spRefreshDeployments
    2020-06-23 13:03:55  Adding procedure spGetSubscription
    2020-06-23 13:03:55  Adding procedure spGetSubscriptionCategories
    2020-06-23 13:03:55  Adding procedure spGetSubscriptionNextSynchronizationTime
    2020-06-23 13:03:55  Adding procedure spSetSubscription
    2020-06-23 13:03:55  Adding procedure spSetSubscriptionLastRunTime
    2020-06-23 13:03:55  Adding procedure spSetScheduleFrequency
    2020-06-23 13:03:55  Adding procedure spSetSubscriptionDeploymentAnchor
    2020-06-23 13:03:55  Adding procedure spSetSubscriptionAnchor
    2020-06-23 13:03:55  Adding procedure spGetTargetGroupByID
    2020-06-23 13:03:56  Adding procedure spGetTargetGroupForComputer
    2020-06-23 13:03:56  Adding procedure spGetTargetGroupsForComputer
    2020-06-23 13:03:56  Adding procedure spGetChildTargetGroups
    2020-06-23 13:03:56  Adding procedure spGetParentTargetGroup
    2020-06-23 13:03:56  Adding procedure spCreateTargetGroup
    2020-06-23 13:03:56  Adding procedure spDeleteTargetGroup
    2020-06-23 13:03:56  Adding procedure spAddTargetToTargetGroup
    2020-06-23 13:03:56  Adding procedure spRemoveTargetFromTargetGroup
    2020-06-23 13:03:56  Adding procedure spGetAllComputers
    2020-06-23 13:03:56  Adding procedure spSearchComputers
    2020-06-23 13:03:56  Msg 924, Level 14, State 1, Server CL3SCCM01, Procedure spSearchComputers, Line 6
    Database 'SUSDB' is already open and can only have one user at a time.
    2020-06-23 13:03:56  Retrying failed batch. Attempt 1.
    2020-06-23 13:03:56  Waiting for exclusive access to database SUSDB from system process having SPID 28.
    2020-06-23 13:04:26  Changed database context to 'SUSDB'.
    2020-06-23 13:04:27  Adding procedure spGetComputerCount
    2020-06-23 13:04:27  Adding procedure spGetAllDownstreamServers
    2020-06-23 13:04:27  Adding procedure spGetInventoryItemsForComputer
    2020-06-23 13:04:27  Adding procedure spGetInventorySummary
    2020-06-23 13:04:27  Adding procedure spGetComputersHavingInventoryItem
    2020-06-23 13:04:27  Adding procedure spGetComputersInTargetGroup
    2020-06-23 13:04:27  Adding procedure spAddComputerToTargetGroup
    2020-06-23 13:04:27  Adding procedure spAddComputerToTargetGroupAllowMultipleGroups
    2020-06-23 13:04:27  Adding procedure spRemoveComputerFromTargetGroup
    2020-06-23 13:04:27  Adding procedure spGetDownstreamServersInTargetGroup
    2020-06-23 13:04:27  Adding procedure spCreateTargetEntry
    2020-06-23 13:04:27  Adding procedure spPreregisterComputer
    2020-06-23 13:04:27  Adding procedure spGetComputerByID
    2020-06-23 13:04:27  Adding procedure spGetDownstreamServer
    2020-06-23 13:04:27  Adding procedure spDeleteComputer
    2020-06-23 13:04:27  Adding procedure spDeleteDownstreamServer
    2020-06-23 13:04:27  Adding procedure spSearchEventHistory  
    2020-06-23 13:04:27  Adding procedure spPurgeReportingEvents 
    2020-06-23 13:04:27  Adding procedure spGetComponentsWithErrors
    2020-06-23 13:04:27  Adding procedure spGetUpdateServerStatus
    2020-06-23 13:04:27  Adding Procedure spGetDownstreamServerRollupSummary
    2020-06-23 13:04:27  Creating Procedure spGetXmlForUpdate
    2020-06-23 13:04:27  Creating Procedure spGetPreviousRevision
    2020-06-23 13:04:27  Adding Procedure spGetLatestRevisionNumberForUpdate
    2020-06-23 13:04:27  Adding Procedure spGetSdpXmlForUpdate
    2020-06-23 13:04:27  Adding PROCEDURE spGetEmailNotificationConfiguration
    2020-06-23 13:04:27  Adding PROCEDURE spSetEmailNotificationConfiguration
    2020-06-23 13:04:27  Adding procedure spGetEmailNotificationStatus
    2020-06-23 13:04:27  Adding procedure spSetEmailNotificationStatus
    2020-06-23 13:04:27  Adding PROCEDURE spScheduleEmailNotification
    2020-06-23 13:04:27  Adding PROCEDURE spGetEmailsToNotify
    2020-06-23 13:04:27  Adding PROCEDURE spGetEmailNotificationRecipients
    2020-06-23 13:04:27  Adding PROCEDURE spAddEmailNotificationRecipient
    2020-06-23 13:04:27  Adding PROCEDURE spDeclineSupersededUpdates
    2020-06-23 13:04:27  Adding PROCEDURE spDeclineExpiredUpdates
    2020-06-23 13:04:27  Adding PROCEDURE spCountObsoleteUpdatesToCleanup
    2020-06-23 13:04:27  Adding PROCEDURE spGetObsoleteUpdatesToCleanup
    2020-06-23 13:04:27  Adding PROCEDURE spDeleteUpdate
    2020-06-23 13:04:27  Adding PROCEDURE spDeleteUpdateByUpdateID
    2020-06-23 13:04:27  Adding PROCEDURE spCountUpdatesToCompress
    2020-06-23 13:04:27  Adding PROCEDURE spGetUpdatesToCompress
    2020-06-23 13:04:27  Adding PROCEDURE spCompressUpdate
    2020-06-23 13:04:27  Adding PROCEDURE spCleanupObsoleteComputers
    2020-06-23 13:04:27  Adding PROCEDURE spCleanupUnneededContentFiles
    2020-06-23 13:04:27  Adding procedure spGetFailedToDownloadUpdatesCount
    2020-06-23 13:04:27  Changed database context to 'SUSDB'.
    2020-06-23 13:04:28  Populating the database with basic configuration information
    2020-06-23 13:04:28  Creating the pre-defined target groups 
    2020-06-23 13:04:28  Populating Auto Deployment Rules
    2020-06-23 13:04:28  Populating System Subscription
    2020-06-23 13:04:28  Populating Email Notification Configuration
    2020-06-23 13:04:28  Populating Email Notification Status
    2020-06-23 13:04:28  Populating Languages
    2020-06-23 13:04:28  Populating tbLanguageInSubscription for default subscription
    2020-06-23 13:04:28  Populating Categories
    2020-06-23 13:04:28  Populating Driver classes
    2020-06-23 13:04:28  Populating handlers
    2020-06-23 13:04:28  Populating driver types
    2020-06-23 13:04:28  Populating state machine
    2020-06-23 13:04:28  Changed database context to 'SUSDB'.
    2020-06-23 13:04:28  Changed database context to 'SUSDB'.
    2020-06-23 13:04:29  Creating PROCEDURE spUpdateInventoryRulesXml
    2020-06-23 13:04:29  Creating PROCEDURE spAddDetailedInventoryRules
    2020-06-23 13:04:29  Creating PROCEDURE spGetInventoryVersion
    2020-06-23 13:04:29  Creating PROCEDURE spAddInventoryXml
    2020-06-23 13:04:29  Creating PROCEDURE spAddDetailedInventoryInformation
    2020-06-23 13:04:29  Changed database context to 'SUSDB'.
    2020-06-23 13:04:29  Creating PublicViewAccess Database role
    2020-06-23 13:04:29  Creating view PUBLIC_VIEWS.vUpdate
    2020-06-23 13:04:29  Creating view PUBLIC_VIEWS.vCategory
    2020-06-23 13:04:29  Creating view PUBLIC_VIEWS.vClassification
    2020-06-23 13:04:29  Creating view PUBLIC_VIEWS.vUpdateInCategory
    2020-06-23 13:04:29  Creating view PUBLIC_VIEWS.vLanguage
    2020-06-23 13:04:29  Creating view PUBLIC_VIEWS.vUpdateText
    2020-06-23 13:04:29  Creating view PUBLIC_VIEWS.vUpdateAdditionalInfoUrl
    2020-06-23 13:04:29  Creating view PUBLIC_VIEWS.vCategoryText
    2020-06-23 13:04:29  Creating view PUBLIC_VIEWS.vClassificationText
    2020-06-23 13:04:29  Creating view PUBLIC_VIEWS.vDownstreamServer
    2020-06-23 13:04:29  Creating view PUBLIC_VIEWS.vComputerTarget
    2020-06-23 13:04:29  Creating view PUBLIC_VIEWS.vComputerTargetGroup
    2020-06-23 13:04:29  Creating view PUBLIC_VIEWS.vComputerGroupMembership
    2020-06-23 13:04:29  Creating view PUBLIC_VIEWS.vUpdateApproval
    2020-06-23 13:04:29  Creating view PUBLIC_VIEWS.vUpdateInstallationInfoBasic
    2020-06-23 13:04:29  Creating view PUBLIC_VIEWS.vUpdateInstallationInfo
    2020-06-23 13:04:29  Creating view PUBLIC_VIEWS.vUpdateEffectiveApprovalPerComputer
    2020-06-23 13:04:29  Creating view PUBLIC_VIEWS.vSupportedInventory
    2020-06-23 13:04:29  Creating view PUBLIC_VIEWS.vComputerInventory
    2020-06-23 13:04:29  Creating TVF PUBLIC_VIEWS.fnUpdateInstallationStateMap
    2020-06-23 13:04:29  Reestablishing database connection...
    2020-06-23 13:04:29  Configuring database...
    2020-06-23 13:04:29  Writing settings...
    2020-06-23 13:04:29  Settings set
    2020-06-23 13:04:29  Creating logins...
    2020-06-23 13:04:29  Fetching account info for S-1-5-20
    2020-06-23 13:04:29  Found principal
    2020-06-23 13:04:29  Found account
    2020-06-23 13:04:29  Got binary SID
    2020-06-23 13:04:29  Fetching WsusAdministratorsSid from registry store
    2020-06-23 13:04:29  Value is (null)
    2020-06-23 13:04:29  Ensuring SUSDB is set to Multi-User Mode ...
    2020-06-23 13:04:29  System.InvalidOperationException: Security groups have not been configured
       at Microsoft.UpdateServices.Administration.ConfigureDB.ConfigureLocalLogins()
       at Microsoft.UpdateServices.Administration.ConfigureDB.Configure()
       at Microsoft.UpdateServices.Administration.ConfigureDB.Run(String instanceName, Action`1 logWriter, Boolean contentLocal)
       at Microsoft.UpdateServices.Administration.PostInstall.Run()
       at Microsoft.UpdateServices.Administration.PostInstall.Execute(String[] arguments)

    Matt Dillon

    Tuesday, June 23, 2020 6:23 PM
  • WSUS is very disposable.  Erase the VM and start over?

    In all seriousness, 2012 R2 WSUS will not install if .Net 4.8 is installed.  Remove 4.8 and it may succeed.

    If you've manually deleted folders related to IIS or WSUS, the re-install will not work.  Updates copy much needed files to the WSUS and IIS folder structures.

    I believe also, if re-installing, you'll need to uninstall WID and manually delete the database files first or the re-install fails.

    Wednesday, June 24, 2020 3:12 AM
  • The VM is the SCCM Primary Site Server and I would like to avoid rebuilding it if I could. I have uninstalled the update for .NET 4.8 and verified in the registry that .NET 4.5 is installed. I have uninstalled the WID role as well. I have not uninstalled IIS yet as I was not sure of the ramifications on SCCM, which is still functioning as expected. I have also removed WSUS role using PowerShell, deleted the SUSDB, deleted the IIS WSUS, deleted the WSUS file in MMC folder. Was on with Microsoft yesterday, but we could not fix it. He will be reviewing logs and getting back to me today hopefully.

    Matt Dillon

    Wednesday, June 24, 2020 11:36 AM
  • Hi Matt Dillon,
     
    Thanks for your response.
     
    According to the information, I did not find useful errors. I also checked the logs of my lab environment and found no useful information. I will consult a more advanced engineer on this issue. If there is any follow-up, I will contact you first. Thank you for your patience.
     
    Regards,
    Rita

    Please remember to mark as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Thursday, June 25, 2020 6:43 AM
  • We ended up restoring the server from a few days before I removed WSUS as I needed to get back in business  Problem "solved".  

    Matt Dillon

    • Marked as answer by pugmohone Thursday, June 25, 2020 12:58 PM
    Thursday, June 25, 2020 12:58 PM
  • Hi Matt Dillon,
     
    I'm glad your issue has been solved. If next time there is anything else I can help with you, please feel free to post.
     
    Regards,
    Rita

    Please remember to mark as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Friday, June 26, 2020 5:17 AM
  • Just as a followup for anyone else looking to remove and/or reinstall WSUS

    https://www.ajtek.ca/wsus/how-to-remove-wsus-completely-and-reinstall-it/


    Adam Marshall, MCSE: Security
    https://www.ajtek.ca
    Microsoft MVP - Windows and Devices for IT

    Saturday, July 4, 2020 1:35 AM