WSUS 2019 Database creation failed

asked 2022-06-09T15:54:35.923+00:00
David González 1 Reputation point

Hello,

After installing WSUS role on a new Windows Server 2019 VM, I get the following post-install failure:

Log file is located at C:\Users\xxxxxxxxxxxxxx\AppData\Local\Temp\WSUS_PostInstall_20220609T153837.log
Post install is starting
Fatal Error: Database creation failed

We are trying to install database on a SQL server. This is not a re-installation, it is a new server.

The content of the postinstall log:

2022-06-09 17:38:37 Postinstall started
2022-06-09 17:38:37 Detected role services: Api, Database, UI, Services
2022-06-09 17:38:37 Start: LoadSettingsFromParameters
2022-06-09 17:38:37 Content local is: True
2022-06-09 17:38:37 Content directory is: W:\WSUS
2022-06-09 17:38:37 SQL instname is: xxxxxxxxxxxxxx
2022-06-09 17:38:37 End: LoadSettingsFromParameters
2022-06-09 17:38:37 Start: Run
2022-06-09 17:38:37 Fetching WsusAdministratorsSid from registry store
2022-06-09 17:38:37 Value is S-1-5-21-1965466525-962015248-1270644709-1000
2022-06-09 17:38:37 Fetching WsusReportersSid from registry store
2022-06-09 17:38:37 Value is S-1-5-21-1965466525-962015248-1270644709-1001
2022-06-09 17:39:37 Configuring content directory...
2022-06-09 17:39:37 Configuring groups...
2022-06-09 17:39:37 Starting group configuration for WSUS Administrators...
2022-06-09 17:39:37 Found group in regsitry, attempting to use it...
2022-06-09 17:39:39 Writing group to registry...
2022-06-09 17:39:39 Finished group creation
2022-06-09 17:39:39 Starting group configuration for WSUS Reporters...
2022-06-09 17:39:39 Found group in regsitry, attempting to use it...
2022-06-09 17:39:39 Writing group to registry...
2022-06-09 17:39:39 Finished group creation
2022-06-09 17:39:39 Configuring permissions...
2022-06-09 17:39:39 Fetching content directory...
2022-06-09 17:39:39 Fetching ContentDir from registry store
2022-06-09 17:39:39 Value is W:\WSUS
2022-06-09 17:39:39 Fetching group SIDs...
2022-06-09 17:39:39 Fetching WsusAdministratorsSid from registry store
2022-06-09 17:39:39 Value is S-1-5-21-1965466525-962015248-1270644709-1000
2022-06-09 17:39:39 Fetching WsusReportersSid from registry store
2022-06-09 17:39:39 Value is S-1-5-21-1965466525-962015248-1270644709-1001
2022-06-09 17:39:39 Creating group principals...
2022-06-09 17:39:39 Granting directory permissions...
2022-06-09 17:39:39 Granting permissions on content directory...
2022-06-09 17:39:39 Granting registry permissions...
2022-06-09 17:39:39 Granting registry permissions...
2022-06-09 17:39:39 Granting registry permissions...
2022-06-09 17:39:39 Configuring shares...
2022-06-09 17:39:39 Configuring network shares...
2022-06-09 17:39:39 Fetching content directory...
2022-06-09 17:39:39 Fetching ContentDir from registry store
2022-06-09 17:39:39 Value is W:\WSUS
2022-06-09 17:39:39 Fetching WSUS admin SID...
2022-06-09 17:39:39 Fetching WsusAdministratorsSid from registry store
2022-06-09 17:39:39 Value is S-1-5-21-1965466525-962015248-1270644709-1000
2022-06-09 17:39:39 Content directory is local, creating content shares...
2022-06-09 17:39:39 Creating share "UpdateServicesPackages" with path "W:\WSUS\UpdateServicesPackages" and description "A network share to be used by client systems for collecting all software packages (usually applications) published on this WSUS system."
2022-06-09 17:39:39 Deleting existing share...
2022-06-09 17:39:39 Creating share...
2022-06-09 17:39:39 Share successfully created
2022-06-09 17:39:39 Creating share "WsusContent" with path "W:\WSUS\WsusContent" and description "A network share to be used by Local Publishing to place published content on this WSUS system."
2022-06-09 17:39:39 Deleting existing share...
2022-06-09 17:39:39 Creating share...
2022-06-09 17:39:40 Share successfully created
2022-06-09 17:39:40 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."
2022-06-09 17:39:40 Deleting existing share...
2022-06-09 17:39:40 Creating share...
2022-06-09 17:39:40 Share successfully created
2022-06-09 17:39:40 Finished creating content shares
2022-06-09 17:39:40 Stopping service WSUSService
2022-06-09 17:39:40 Stopping service W3SVC
2022-06-09 17:39:40 Configuring database...
2022-06-09 17:39:40 Configuring the database...
2022-06-09 17:39:40 Establishing DB connection...
2022-06-09 17:39:40 Checking to see if database exists...
2022-06-09 17:39:40 Database does not exist
2022-06-09 17:39:40 Loading install type query...
2022-06-09 17:39:40 DECLARE @currentDBVersion int
DECLARE @scriptMajorVersion int = (17763)
DECLARE @scriptMinorVersion int = (107)
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

2022-06-09 17:39:40 Install type is: Fresh
2022-06-09 17:39:40 Creating database...
2022-06-09 17:39:40 Disposing Connection
2022-06-09 17:39:40 Clearing Connection Pools
2022-06-09 17:39:41 Changed database context to 'SUSDB'.
2022-06-09 17:39:41 Changed database context to 'SUSDB'.
2022-06-09 17:39:41 Creating Procedures spDropForeignKeyConstraint
2022-06-09 17:39:41 Adding function spDropTableColumnIfExists
2022-06-09 17:39:41 Adding function spAddTableColumnIfNotExists
2022-06-09 17:39:41 Adding function spDropPrimaryKeyConstraint
2022-06-09 17:39:41 Creating table dbo.tbPrerequisiteDependency
2022-06-09 17:39:41 Creating table dbo.tbBundleDependency
2022-06-09 17:39:41 Creating table tbUpdateStatusPerComputer
2022-06-09 17:39:41 Creating table tbUpdateSummaryForAllComputers
2022-06-09 17:39:41 Creating table tbComputerSummaryForMicrosoftUpdates
2022-06-09 17:39:41 Creating table dbo.tbRequestedTargetGroup
2022-06-09 17:39:41 Creating table dbo.tbRequestedTargetGroupsForTarget
2022-06-09 17:39:41 Creating table tbDeletedComputer
2022-06-09 17:39:41 Creating table dbo.tbComputerTargetDetail
2022-06-09 17:39:41 Creating table dbo.tbComputerTarget
2022-06-09 17:39:41 Creating table dbo.tbClientWithRecentNameChange
2022-06-09 17:39:41 Creating table dbo.tbDownstreamServerTarget
2022-06-09 17:39:41 Creating table dbo.tbDownstreamServerSummaryRollup
2022-06-09 17:39:41 Creating table dbo.tbDownstreamServerClientSummaryRollup
2022-06-09 17:39:41 Creating table dbo.tbDownstreamServerClientActivityRollup
2022-06-09 17:39:41 Creating table dbo.tbTarget
2022-06-09 17:39:41 Creating table dbo.tbTargetType
2022-06-09 17:39:41 Creating table dbo.tbDeployment
2022-06-09 17:39:41 tbDeployment does not exist, creating it now
2022-06-09 17:39:41 Creating table dbo.tbDeadDeployment
2022-06-09 17:39:42 Creating table dbo.tbRevisionLanguage
2022-06-09 17:39:42 Creating table dbo.tbProperty
2022-06-09 17:39:42 Creating table dbo.tbRevisionExtendedProperty
2022-06-09 17:39:42 Creating table dbo.tbKBArticleForRevision
2022-06-09 17:39:42 Creating table dbo.tbMoreInfoURLForRevision
2022-06-09 17:39:42 Creating table dbo.tbSecurityBulletinForRevision
2022-06-09 17:39:42 Creating table dbo.tbLocalizedPropertyForRevision
2022-06-09 17:39:42 Creating table dbo.tbFileForRevision
2022-06-09 17:39:42 Creating table dbo.tbFileHash
2022-06-09 17:39:42 Creating table dbo.tbRevisionSupersedesUpdate
2022-06-09 17:39:42 Creating table dbo.tbInstalledUpdateSufficientForPrerequisite
2022-06-09 17:39:42 Creating table dbo.tbBundleAtLeastOne
2022-06-09 17:39:42 Creating table dbo.tbBundleAll
2022-06-09 17:39:42 Creating table dbo.tbPrerequisite
2022-06-09 17:39:42 Creating table dbo.tbDriver
2022-06-09 17:39:42 Creating table dbo.tbCompatiblePrinterProvider
2022-06-09 17:39:42 Creating table dbo.tbDriverClass
2022-06-09 17:39:42 Creating table dbo.tbTargetGroup
2022-06-09 17:39:42 Creating table dbo.tbFlattenedTargetGroup
2022-06-09 17:39:42 Creating table dbo.tbTargetGroupType
2022-06-09 17:39:42 Creating table dbo.tbExpandedTargetInTargetGroup
2022-06-09 17:39:42 Creating table dbo.tbTargetInTargetGroup
2022-06-09 17:39:42 Creating table dbo.tbEulaProperty
2022-06-09 17:39:42 Creating table dbo.tbEulaAcceptance
2022-06-09 17:39:42 Creating table dbo.tbLocalizedProperty
2022-06-09 17:39:42 Creating table dbo.tbFile
2022-06-09 17:39:42 Creating table dbo.tbXml
2022-06-09 17:39:42 Creating table dbo.tbGroupAuthorization
2022-06-09 17:39:42 Creating table dbo.tbAuthorization
2022-06-09 17:39:42 Creating table dbo.tbFileOnServer
2022-06-09 17:39:42 Creating table dbo.tbFileDownloadProgress
2022-06-09 17:39:42 Creating table dbo.tbSingletonData
2022-06-09 17:39:42 Creating table dbo.tbReference
2022-06-09 17:39:42 Creating table dbo.tbFrontEndServersHealth
2022-06-09 17:39:42 Creating table dbo.tbConfigurationC
2022-06-09 17:39:42 Creating table dbo.tbConfigurationB
2022-06-09 17:39:42 Creating table dbo.tbConfigurationA
2022-06-09 17:39:42 Creating table dbo.tbConfiguration
2022-06-09 17:39:42 Creating table dbo.tbImplicitCategory
2022-06-09 17:39:42 Creating table dbo.tbCategoryInSubscription
2022-06-09 17:39:42 Creating table dbo.tbLanguageInSubscription
2022-06-09 17:39:42 Creating table dbo.tbSchedule
2022-06-09 17:39:42 Creating table dbo.tbEmailNotificationRecipient
2022-06-09 17:39:42 Creating table dbo.tbRevisionInCategory
2022-06-09 17:39:42 Creating table dbo.tbCategory
2022-06-09 17:39:42 Creating table dbo.tbRevision
2022-06-09 17:39:43 Creating table dbo.tbRevisionExtendedLanguageMask
2022-06-09 17:39:43 Creating table dbo.tbUpdate
2022-06-09 17:39:43 Creating table dbo.tbUpdateType
2022-06-09 17:39:43 Creating table dbo.tbUpdateFlag
2022-06-09 17:39:43 Creating table dbo.tbHandler
2022-06-09 17:39:43 Creating table dbo.tbLanguage
2022-06-09 17:39:43 Creating table dbo.tbCategoryType
2022-06-09 17:39:43 Creating table dbo.tbStateMachine
2022-06-09 17:39:43 Creating table dbo.tbStateMachineState
2022-06-09 17:39:43 Creating table dbo.tbStateMachineEvent
2022-06-09 17:39:43 Creating table dbo.tbStateMachineTransition
2022-06-09 17:39:43 Creating table dbo.tbStateMachineEventTransitionLog
2022-06-09 17:39:43 Adding View vwStateMachineEventTransitionLog
2022-06-09 17:39:43 Creating table dbo.tbNotificationEvent
2022-06-09 17:39:43 Creating table dbo.tbChangeTracking
2022-06-09 17:39:43 Creating table dbo.tbFlattenedRevisionInCategory
2022-06-09 17:39:43 Creating table dbo.tbServerSyncResult
2022-06-09 17:39:43 Creating table dbo.tbAutoDeploymentRule
2022-06-09 17:39:43 Creating table dbo.tbUpdateClassificationInAutoDeploymentRule
2022-06-09 17:39:43 Creating table dbo.tbCategoryInAutoDeploymentRule
2022-06-09 17:39:43 Creating table dbo.tbTargetGroupInAutoDeploymentRule
2022-06-09 17:39:43 Creating table dbo.tbSchemaVersion
2022-06-09 17:39:43 Creating table dbo.tbSchemaVersionHistory
2022-06-09 17:39:43 Creating table dbo.tbServerHealth
2022-06-09 17:39:43 Creating table dbo.tbProgramKeys
2022-06-09 17:39:43 Creating table tbComputersThatNeedDetailedRollup
2022-06-09 17:39:43 Creating table dbo.tbDriverTargetingGroup
2022-06-09 17:39:43 Creating table dbo.tbDriverTargetingGroupPrerequisite
2022-06-09 17:39:43 Creating table dbo.tbTargetedDriverHwid
2022-06-09 17:39:43 Creating table dbo.tbDriverFeatureScore
2022-06-09 17:39:43 Creating table dbo.tbDistributionComputerHardwareId
2022-06-09 17:39:43 Creating table dbo.tbTargetComputerHardwareId
2022-06-09 17:39:43 Creating type GuidListType
2022-06-09 17:39:43 Adding indexed view ivwApiUpdateRevision
2022-06-09 17:39:43 Creating Procedure spAddConstraint
2022-06-09 17:39:43 executing stored PROCEDURE spAddConstraint
2022-06-09 17:39:44 Adding FUNCTION fn_GetGrade
2022-06-09 17:39:44 Adding FUNCTION fnGetOnlineSummaryFlags
2022-06-09 17:39:44 Adding PROCEDURE spUpdateChangeTrackingNumber
2022-06-09 17:39:44 Creating PROCEDURE spUpdateChangeTrackingNumber
2022-06-09 17:39:44 Adding Trigger trOnUpdatingConfiguration
2022-06-09 17:39:44 Adding Trigger trOnInsertingUpdateStatus
2022-06-09 17:39:44 Adding Trigger trOnDeletingUpdateStatus
2022-06-09 17:39:44 Adding Trigger trOnUpdatingUpdateStatus
2022-06-09 17:39:44 Adding FUNCTION fn_GetBestRevisionForEvaluateDeployment
2022-06-09 17:39:44 Adding PROCEDURE spMoveEvaluateDeploymentsAsNeeded
2022-06-09 17:39:44 Adding PROCEDURE spDeleteUneededPrerequisiteDeployments
2022-06-09 17:39:44 Adding PROCEDURE spDeleteUneededBundleDeployments
2022-06-09 17:39:44 Adding PROCEDURE spProcessPrerequisitesForRevision
2022-06-09 17:39:44 Adding PROCEDURE spRefreshDriverTargetingDeployments
2022-06-09 17:39:44 Adding TRIGGER trOnUpdatingRevision
2022-06-09 17:39:44 Adding TRIGGER trOnUpdatingDeployment
2022-06-09 17:39:44 Adding TRIGGER trOnAddingDeployment
2022-06-09 17:39:44 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.
2022-06-09 17:39:44 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.
2022-06-09 17:39:44 Adding PROCEDURE spGetUpdateThrottlingSettings
2022-06-09 17:39:44 Creating PROCEDURE spGetUpdateThrottlingSettings
2022-06-09 17:39:44 Adding Trigger trOnDeletingDeployment
2022-06-09 17:39:44 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.
2022-06-09 17:39:44 Adding trigger trAdjustIsLeaf_reduce
2022-06-09 17:39:44 Adding trigger trAdjustPrerequisite
2022-06-09 17:39:44 Adding triggers trExpandRevisionInCategory
2022-06-09 17:39:44 Adding triggers trExpandFlattenedRevisionInCategory
2022-06-09 17:39:44 Adding triggers trExpandRevisionLanguage
2022-06-09 17:39:44 Adding triggers trAdjustIsLeaf_increase
2022-06-09 17:39:44 Adding trigger trOnAddingUpdatingGroupAuthorization
2022-06-09 17:39:44 Adding trigger trOnDeletingGroupAuthorization
2022-06-09 17:39:44 Adding trigger trOnAddingUpdatingAuthorization
2022-06-09 17:39:44 Adding trigger trOnDeletingAuthorization
2022-06-09 17:39:44 Adding trigger trOnAddingLanguage
2022-06-09 17:39:44 Adding trigger trOnChangingLanguage
2022-06-09 17:39:44 Adding trigger trOnDeletingLanguage
2022-06-09 17:39:44 Adding trigger trOnAddingDriver
2022-06-09 17:39:44 Adding trigger trOnDeletingDriver
2022-06-09 17:39:44 Adding trigger tr_insert_ExpandedTargetInTargetGroup
2022-06-09 17:39:44 Adding trigger tr_delete_ExpandedTargetInTargetGroup
2022-06-09 17:39:44 Adding FUNCTION fn_later_date
2022-06-09 17:39:44 Adding PROCEDURE spSaveXmlFragment
2022-06-09 17:39:44 Creating Procedure spSaveXmlFragment
2022-06-09 17:39:44 Adding PROCEDURE spGetChildCategories
2022-06-09 17:39:44 Creating Procedure spGetChildCategories
2022-06-09 17:39:44 Adding PROCEDURE spGetUssDeployments
2022-06-09 17:39:45 Creating Procedure spGetUssDeployments
2022-06-09 17:39:45 Adding PROCEDURE spUpdateSubTimestamp
2022-06-09 17:39:45 Creating Procedure spUpdateSubTimestamp
2022-06-09 17:39:45 Adding PROCEDURE spPopulateLanguageInSubscription
2022-06-09 17:39:45 Creating Procedure spPopulateLanguageInSubscription
2022-06-09 17:39:45 Adding PROCEDURE spAddNewLanguage
2022-06-09 17:39:45 Creating Procedure spAddNewLanguage
2022-06-09 17:39:45 Adding PROCEDURE spCheckRevisionExists
2022-06-09 17:39:45 Creating Procedure spCheckRevisionExists
2022-06-09 17:39:45 Adding PROCEDURE spCheckUpdateExists
2022-06-09 17:39:45 Creating Procedure spCheckUpdateExists
2022-06-09 17:39:45 Adding PROCEDURE spGetFilter
2022-06-09 17:39:45 Creating procedure spUpdateOnlineSummaryTablesForUpdateVisible
2022-06-09 17:39:45 Creating procedure spUpdateOnlineSummaryTablesForUpdateNotVisible
2022-06-09 17:39:45 Creating Procedure spImportUpdate
2022-06-09 17:39:45 Msg 137, Level 15, State 2, Server xxxxxxxxxxxxxx, Procedure spImportUpdate, Line 365
Must declare the scalar variable "@RevisionID".Msg 319, Level 15, State 1, Server xxxxxxxxxxxxxx, Procedure spImportUpdate, Line 367
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.Msg 137, Level 15, State 2, Server xxxxxxxxxxxxxxx, Procedure spImportUpdate, Line 379
Must declare the scalar variable "@RevisionID".Msg 319, Level 15, State 1, Server xxxxxxxxxxxxxx, Procedure spImportUpdate, Line 381
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.Msg 137, Level 15, State 2, Server xxxxxxxxxxxxx, Procedure spImportUpdate, Line 392
Must declare the scalar variable "@RevisionID".Msg 319, Level 15, State 1, Server xxxxxxxxxxxxxx, Procedure spImportUpdate, Line 394
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.Msg 137, Level 15, State 2, Server xxxxxxxxxxx, Procedure spImportUpdate, Line 572
Must declare the scalar variable "@iDoc".Msg 319, Level 15, State 1, Server xxxxxxxxxxxxxx, Procedure spImportUpdate, Line 573
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
2022-06-09 17:39:45 Re-Establishing Connection to execute Multi User Query ...
2022-06-09 17:39:45 Ensuring SUSDB is set to Multi-User Mode ...
2022-06-09 17:39:45 Disposing Connection
2022-06-09 17:39:45 Clearing Connection Pools
2022-06-09 17:39:45 Microsoft.UpdateServices.Administration.CommandException: Database creation failed
at Microsoft.UpdateServices.Administration.ConfigureDB.CreateDatabase()
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)

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
8,147 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. answered 2022-06-10T09:13:57.953+00:00
    Rita Hu -MSFT 9,391 Reputation points

    Hello David,

    Thanks for your posting on Q&A.

    You have tried to install the SUSDB in the SQL Server database. Am I right? In fact, we could run the command to finish the post install. Here are the steps you could refer to finish the post install obu command line.

    Open the CMD as an administrator and navigate to the wsusutil.exe tool and run the below command to finish the post install task.

     wsusutil.exe postinstall SQL_INSTANCE_NAME=SQLSRV CONTENT_DIR=C:\WSUS  
    

    Reference picture:
    210717-1.png

    Please try to run the above command and check whether the issue stays or not. Please keep us in touch if there are any updates or questions of the case.

    Best regards,
    Rita


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. answered 2022-06-14T08:20:30.29+00:00
    Rita Hu -MSFT 9,391 Reputation points

    Hello David,

    Thanks for your reply.

    May I know it is the first time to install WSUS role on the New Server? Or You have failed to install the WSUS role on the Server before. And you tried to uninstall the WSUS role and reinstall it in the Server. And then the issue occurred.

    In fact, there are several steps suggested to remove the WSUS role completely if you want to remove the WSUS role and reinstall it. Please follow the below steps to remove the WSUS role:
    To remove WSUS completely, you 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.

    If you use a WID database, it is recommended to delete the following path folders:
    C:\Windows\WID

    4. In the IIS Information Services (IIS) Manager, manually remove the WSUS Administration site. Then restart the server. Then please try to install the WSUS role again.

    In the past, a lot of bros fail to reinstall the WSUS role if they don't remove the WSUS as the above suggested link. So it is recommended to follow the above steps to remove WSUS role and then we could try to reinstall it.

    Hope the above will be helpful.

    Best regards,
    Rita


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    No comments