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)