Hi there,
I'm trying to reinstall WSUS on my SCCM server (2012 R2) as a SQL db instead of WID. I inherited it this way. No matter what I try, the post-install tasks bomb out with this error:
2018-08-08 12:08:16 Postinstall started
2018-08-08 12:08:16 Detected role services: Api, Database, UI, Services
2018-08-08 12:08:16 Start: LoadSettingsFromParameters
2018-08-08 12:08:16 Content local is: True
2018-08-08 12:08:16 Content directory is: D:\Windows Server Update Service
2018-08-08 12:08:16 SQL instname is: GAMBIT
2018-08-08 12:08:16 End: LoadSettingsFromParameters
2018-08-08 12:08:16 Start: Run
2018-08-08 12:08:16 Fetching WsusAdministratorsSid from registry store
2018-08-08 12:08:16 Value is S-1-5-21-1355483703-2602408213-1168805140-1004
2018-08-08 12:08:16 Fetching WsusReportersSid from registry store
2018-08-08 12:08:16 Value is S-1-5-21-1355483703-2602408213-1168805140-1005
2018-08-08 12:09:15 Configuring content directory...
2018-08-08 12:09:15 Configuring groups...
2018-08-08 12:09:15 Starting group configuration for WSUS Administrators...
2018-08-08 12:09:15 Found group in regsitry, attempting to use it...
2018-08-08 12:09:18 Writing group to registry...
2018-08-08 12:09:18 Finished group creation
2018-08-08 12:09:18 Starting group configuration for WSUS Reporters...
2018-08-08 12:09:18 Found group in regsitry, attempting to use it...
2018-08-08 12:09:18 Writing group to registry...
2018-08-08 12:09:18 Finished group creation
2018-08-08 12:09:18 Configuring permissions...
2018-08-08 12:09:18 Fetching content directory...
2018-08-08 12:09:18 Fetching ContentDir from registry store
2018-08-08 12:09:18 Value is D:\Windows Server Update Service
2018-08-08 12:09:18 Fetching group SIDs...
2018-08-08 12:09:18 Fetching WsusAdministratorsSid from registry store
2018-08-08 12:09:18 Value is S-1-5-21-1355483703-2602408213-1168805140-1004
2018-08-08 12:09:18 Fetching WsusReportersSid from registry store
2018-08-08 12:09:18 Value is S-1-5-21-1355483703-2602408213-1168805140-1005
2018-08-08 12:09:18 Creating group principals...
2018-08-08 12:09:18 Granting directory permissions...
2018-08-08 12:09:18 Granting permissions on content directory...
2018-08-08 12:09:18 Granting registry permissions...
2018-08-08 12:09:18 Granting registry permissions...
2018-08-08 12:09:18 Granting registry permissions...
2018-08-08 12:09:18 Configuring shares...
2018-08-08 12:09:18 Configuring network shares...
2018-08-08 12:09:18 Fetching content directory...
2018-08-08 12:09:18 Fetching ContentDir from registry store
2018-08-08 12:09:18 Value is D:\Windows Server Update Service
2018-08-08 12:09:18 Fetching WSUS admin SID...
2018-08-08 12:09:18 Fetching WsusAdministratorsSid from registry store
2018-08-08 12:09:18 Value is S-1-5-21-1355483703-2602408213-1168805140-1004
2018-08-08 12:09:18 Content directory is local, creating content shares...
2018-08-08 12:09:18 Creating share "UpdateServicesPackages" with path "D:\Windows Server Update Service\UpdateServicesPackages" and description "A network share to be used by client systems for collecting all software packages (usually applications) published on this WSUS system."
2018-08-08 12:09:18 Creating share...
2018-08-08 12:09:18 Share successfully created
2018-08-08 12:09:18 Creating share "WsusContent" with path "D:\Windows Server Update Service\WsusContent" and description "A network share to be used by Local Publishing to place published content on this WSUS system."
2018-08-08 12:09:18 Creating share...
2018-08-08 12:09:18 Share successfully created
2018-08-08 12:09:19 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."
2018-08-08 12:09:19 Creating share...
2018-08-08 12:09:19 Share successfully created
2018-08-08 12:09:19 Finished creating content shares
2018-08-08 12:09:19 Stopping service WSUSService
2018-08-08 12:09:19 Stopping service W3SVC
2018-08-08 12:10:49 Configuring database...
2018-08-08 12:10:49 Configuring the database...
2018-08-08 12:10:49 Establishing DB connection...
2018-08-08 12:10:49 Checking to see if database exists...
2018-08-08 12:10:49 Database does not exist
2018-08-08 12:10:49 Loading install type query...
2018-08-08 12:10:49 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
2018-08-08 12:10:49 Install type is: Fresh
2018-08-08 12:10:49 Creating database...
2018-08-08 12:10:50 Msg 5105, Level 16, State 2, Server GAMBIT, Line 2
A file activation error occurred. The physical file name 'D\:Database\SUSDB.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation.Msg 1802, Level 16, State 1, Server GAMBIT, Line 2
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
2018-08-08 12:10:50 Re-Establishing Connection to execute Multi User Query ...
2018-08-08 12:10:50 Ensuring SUSDB is set to Multi-User Mode ...
2018-08-08 12:10:50 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)
I've uninstalled WSUS (including WID), made sure the WSUScontent folder and SUSDB/SUSDB.log are detached and gone, deleted the IIS site. Pretty much everything at these two Answers:
https://social.technet.microsoft.com/Forums/ie/en-US/c7a6f2d6-2e4d-437b-a104-03328c146d4a/wsus-post-deployment-tasks-configuration-failed?forum=winserverwsus
https://social.technet.microsoft.com/Forums/office/en-US/74c48550-52f6-4160-b8a6-67fc4e6eab79/wsus-post-install-fails-quotfatal-error-the-system-cannot-find-the-path-specifiedquot?forum=winserverwsus
This is my first time configuring WSUS/SCCM. Help?
