Good morning,
First of all, I wanted to thank all the people who contribute to this forum since you make our lives more comfortable. Thank you.
We have a site with a primary SCECM server (we'll call it Server1, Windows Server 2019) and we want to install SUP on two other servers in different locations (Server2 and Server 3, Windows Server 2016).
Server1 - MP/SUP/DP
The first question would be can I install WSUS and SUP role on Server2 and Server3 only or do I need to install the primary SUP on SERVER1? If possible we would like to install it only on Server2 and Server3
The thing is that I have WSUS installed on Server1 and when I do the post-installation tasks on Server2 and Server3 it gives me the following error:
2023-07-08 09:58:30 Postinstall started
2023-07-08 09:58:30 Detected role services: Api, Database, UI, Services
2023-07-08 09:58:30 Start: LoadSettingsFromXml
2023-07-08 09:58:30 Start: GetConfigValue with filename=UpdateServices-Services.xml item=ContentLocal
2023-07-08 09:58:30 Value is true
2023-07-08 09:58:30 End: GetConfigValue
2023-07-08 09:58:30 Start: GetConfigValue with filename=UpdateServices-Services.xml item=ContentDirectory
2023-07-08 09:58:30 Value is D:\CarpetaCompartida
2023-07-08 09:58:30 End: GetConfigValue
2023-07-08 09:58:30 Content directory is D:\CarpetaCompartida
2023-07-08 09:58:30 Start: GetConfigValue with filename=UpdateServices-DB.xml item=InstanceName
2023-07-08 09:58:30 Value is SERVIDOR3.DOMINIO.COM
2023-07-08 09:58:30 End: GetConfigValue
2023-07-08 09:58:30 SQL instance name is SERVIDOR3.DOMINIO.COM
2023-07-08 09:58:30 End: LoadSettingsFromXml
Post install is starting
2023-07-08 09:58:31 Start: Run
2023-07-08 09:58:31 Fetching WsusAdministratorsSid from registry store
2023-07-08 09:58:31 Value is S-1-5-21-1128806669-3064964496-1928835673-1000
2023-07-08 09:58:31 Fetching WsusReportersSid from registry store
2023-07-08 09:58:31 Value is S-1-5-21-1128806669-3064964496-1928835673-1001
2023-07-08 09:58:42 Configuring content directory...
2023-07-08 09:58:42 Configuring groups...
2023-07-08 09:58:42 Starting group configuration for WSUS Administrators...
2023-07-08 09:58:42 Found group in regsitry, attempting to use it...
2023-07-08 09:58:44 Writing group to registry...
2023-07-08 09:58:44 Finished group creation
2023-07-08 09:58:44 Starting group configuration for WSUS Reporters...
2023-07-08 09:58:44 Found group in regsitry, attempting to use it...
2023-07-08 09:58:44 Writing group to registry...
2023-07-08 09:58:44 Finished group creation
2023-07-08 09:58:44 Configuring permissions...
2023-07-08 09:58:44 Fetching content directory...
2023-07-08 09:58:44 Fetching ContentDir from registry store
2023-07-08 09:58:44 Value is D:\CarpetaCompartida
2023-07-08 09:58:44 Fetching group SIDs...
2023-07-08 09:58:44 Fetching WsusAdministratorsSid from registry store
2023-07-08 09:58:44 Value is S-1-5-21-1128806669-3064964496-1928835673-1000
2023-07-08 09:58:44 Fetching WsusReportersSid from registry store
2023-07-08 09:58:44 Value is S-1-5-21-1128806669-3064964496-1928835673-1001
2023-07-08 09:58:44 Creating group principals...
2023-07-08 09:58:44 Granting directory permissions...
2023-07-08 09:58:45 Granting permissions on content directory...
2023-07-08 09:58:45 Granting registry permissions...
2023-07-08 09:58:45 Granting registry permissions...
2023-07-08 09:58:45 Granting registry permissions...
2023-07-08 09:58:45 Configuring shares...
2023-07-08 09:58:45 Configuring network shares...
2023-07-08 09:58:45 Fetching content directory...
2023-07-08 09:58:45 Fetching ContentDir from registry store
2023-07-08 09:58:45 Value is D:\CarpetaCompartida
2023-07-08 09:58:45 Fetching WSUS admin SID...
2023-07-08 09:58:45 Fetching WsusAdministratorsSid from registry store
2023-07-08 09:58:45 Value is S-1-5-21-1128806669-3064964496-1928835673-1000
2023-07-08 09:58:45 Content directory is local, creating content shares...
2023-07-08 09:58:45 Creating share "UpdateServicesPackages" with path "D:\CarpetaCompartida\UpdateServicesPackages" and description "A network share to be used by client systems for collecting all software packages (usually applications) published on this WSUS system."
2023-07-08 09:58:45 Deleting existing share...
2023-07-08 09:58:45 Creating share...
2023-07-08 09:58:45 Share successfully created
2023-07-08 09:58:45 Creating share "WsusContent" with path "D:\CarpetaCompartida\WsusContent" and description "A network share to be used by Local Publishing to place published content on this WSUS system."
2023-07-08 09:58:45 Deleting existing share...
2023-07-08 09:58:45 Creating share...
2023-07-08 09:58:45 Share successfully created
2023-07-08 09:58:45 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."
2023-07-08 09:58:45 Creating share...
2023-07-08 09:58:45 Share successfully created
2023-07-08 09:58:45 Finished creating content shares
2023-07-08 09:58:45 Stopping service WSUSService
2023-07-08 09:58:45 Stopping service W3SVC
2023-07-08 09:58:46 Configuring database...
2023-07-08 09:58:46 Configuring the database...
2023-07-08 09:58:46 Establishing DB connection...
2023-07-08 09:58:46 Checking to see if database exists...
2023-07-08 09:58:46 Database exists
2023-07-08 09:58:46 Switching database to single user mode...
2023-07-08 09:58:49 Loading install type query...
2023-07-08 09:58:49 DECLARE @currentDBVersion int
DECLARE @scriptMajorVersion int = (14393)
DECLARE @scriptMinorVersion int = (0)
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
2023-07-08 09:58:49 Install type is: UnsupportedFuture
2023-07-08 09:58:49 DB is a higher version than the config scripts
2023-07-08 09:58:49 Swtching DB to multi-user mode......
2023-07-08 09:58:49 Finished setting multi-user mode
2023-07-08 09:58:49 Disposing Connection
2023-07-08 09:58:49 Clearing Connection Pools
2023-07-08 09:58:49 Microsoft.UpdateServices.Administration.CommandException: The schema version of the database is from a newer version of WSUS
than currently installed. You must either patch your WSUS server to at least
that version or drop the database.
at Microsoft.UpdateServices.Administration.ConfigureDB.CheckForUnsupportedVersion(DBInstallType installType, Boolean dbExists)
at Microsoft.UpdateServices.Administration.ConfigureDB.ConnectToDB()
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)
Fatal Error: The schema version of the database is from a newer version of WSUS
than currently installed. You must either patch your WSUS server to at least
that version or drop the database.
Thank you so much,
All the best
First of all, I wanted to thank all the people who contribute to this forum since you make our lives more comfortable. Thank you.
We have a site with a primary SCECM server (we'll call it Server1, Windows Server 2019) and we want to install SUP on two other servers in different locations (Server2 and Server 3, Windows Server 2016).
Server1 - MP/SUP/DP
The first question would be can I install WSUS and SUP role on Server2 and Server3 only or do I need to install the primary SUP on SERVER1? If possible we would like to install it only on Server2 and Server3
The thing is that I have WSUS installed on Server1 and when I do the post-installation tasks on Server2 and Server3 it gives me the following error:
2023-07-08 09:58:30 Postinstall started
2023-07-08 09:58:30 Detected role services: Api, Database, UI, Services
2023-07-08 09:58:30 Start: LoadSettingsFromXml
2023-07-08 09:58:30 Start: GetConfigValue with filename=UpdateServices-Services.xml item=ContentLocal
2023-07-08 09:58:30 Value is true
2023-07-08 09:58:30 End: GetConfigValue
2023-07-08 09:58:30 Start: GetConfigValue with filename=UpdateServices-Services.xml item=ContentDirectory
2023-07-08 09:58:30 Value is D:\CarpetaCompartida
2023-07-08 09:58:30 End: GetConfigValue
2023-07-08 09:58:30 Content directory is D:\CarpetaCompartida
2023-07-08 09:58:30 Start: GetConfigValue with filename=UpdateServices-DB.xml item=InstanceName
2023-07-08 09:58:30 Value is SERVIDOR3.DOMINIO.COM
2023-07-08 09:58:30 End: GetConfigValue
2023-07-08 09:58:30 SQL instance name is SERVIDOR3.DOMINIO.COM
2023-07-08 09:58:30 End: LoadSettingsFromXml
Post install is starting
2023-07-08 09:58:31 Start: Run
2023-07-08 09:58:31 Fetching WsusAdministratorsSid from registry store
2023-07-08 09:58:31 Value is S-1-5-21-1128806669-3064964496-1928835673-1000
2023-07-08 09:58:31 Fetching WsusReportersSid from registry store
2023-07-08 09:58:31 Value is S-1-5-21-1128806669-3064964496-1928835673-1001
2023-07-08 09:58:42 Configuring content directory...
2023-07-08 09:58:42 Configuring groups...
2023-07-08 09:58:42 Starting group configuration for WSUS Administrators...
2023-07-08 09:58:42 Found group in regsitry, attempting to use it...
2023-07-08 09:58:44 Writing group to registry...
2023-07-08 09:58:44 Finished group creation
2023-07-08 09:58:44 Starting group configuration for WSUS Reporters...
2023-07-08 09:58:44 Found group in regsitry, attempting to use it...
2023-07-08 09:58:44 Writing group to registry...
2023-07-08 09:58:44 Finished group creation
2023-07-08 09:58:44 Configuring permissions...
2023-07-08 09:58:44 Fetching content directory...
2023-07-08 09:58:44 Fetching ContentDir from registry store
2023-07-08 09:58:44 Value is D:\CarpetaCompartida
2023-07-08 09:58:44 Fetching group SIDs...
2023-07-08 09:58:44 Fetching WsusAdministratorsSid from registry store
2023-07-08 09:58:44 Value is S-1-5-21-1128806669-3064964496-1928835673-1000
2023-07-08 09:58:44 Fetching WsusReportersSid from registry store
2023-07-08 09:58:44 Value is S-1-5-21-1128806669-3064964496-1928835673-1001
2023-07-08 09:58:44 Creating group principals...
2023-07-08 09:58:44 Granting directory permissions...
2023-07-08 09:58:45 Granting permissions on content directory...
2023-07-08 09:58:45 Granting registry permissions...
2023-07-08 09:58:45 Granting registry permissions...
2023-07-08 09:58:45 Granting registry permissions...
2023-07-08 09:58:45 Configuring shares...
2023-07-08 09:58:45 Configuring network shares...
2023-07-08 09:58:45 Fetching content directory...
2023-07-08 09:58:45 Fetching ContentDir from registry store
2023-07-08 09:58:45 Value is D:\CarpetaCompartida
2023-07-08 09:58:45 Fetching WSUS admin SID...
2023-07-08 09:58:45 Fetching WsusAdministratorsSid from registry store
2023-07-08 09:58:45 Value is S-1-5-21-1128806669-3064964496-1928835673-1000
2023-07-08 09:58:45 Content directory is local, creating content shares...
2023-07-08 09:58:45 Creating share "UpdateServicesPackages" with path "D:\CarpetaCompartida\UpdateServicesPackages" and description "A network share to be used by client systems for collecting all software packages (usually applications) published on this WSUS system."
2023-07-08 09:58:45 Deleting existing share...
2023-07-08 09:58:45 Creating share...
2023-07-08 09:58:45 Share successfully created
2023-07-08 09:58:45 Creating share "WsusContent" with path "D:\CarpetaCompartida\WsusContent" and description "A network share to be used by Local Publishing to place published content on this WSUS system."
2023-07-08 09:58:45 Deleting existing share...
2023-07-08 09:58:45 Creating share...
2023-07-08 09:58:45 Share successfully created
2023-07-08 09:58:45 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."
2023-07-08 09:58:45 Creating share...
2023-07-08 09:58:45 Share successfully created
2023-07-08 09:58:45 Finished creating content shares
2023-07-08 09:58:45 Stopping service WSUSService
2023-07-08 09:58:45 Stopping service W3SVC
2023-07-08 09:58:46 Configuring database...
2023-07-08 09:58:46 Configuring the database...
2023-07-08 09:58:46 Establishing DB connection...
2023-07-08 09:58:46 Checking to see if database exists...
2023-07-08 09:58:46 Database exists
2023-07-08 09:58:46 Switching database to single user mode...
2023-07-08 09:58:49 Loading install type query...
2023-07-08 09:58:49 DECLARE @currentDBVersion int
DECLARE @scriptMajorVersion int = (14393)
DECLARE @scriptMinorVersion int = (0)
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
2023-07-08 09:58:49 Install type is: UnsupportedFuture
2023-07-08 09:58:49 DB is a higher version than the config scripts
2023-07-08 09:58:49 Swtching DB to multi-user mode......
2023-07-08 09:58:49 Finished setting multi-user mode
2023-07-08 09:58:49 Disposing Connection
2023-07-08 09:58:49 Clearing Connection Pools
2023-07-08 09:58:49 Microsoft.UpdateServices.Administration.CommandException: The schema version of the database is from a newer version of WSUS
than currently installed. You must either patch your WSUS server to at least
that version or drop the database.
at Microsoft.UpdateServices.Administration.ConfigureDB.CheckForUnsupportedVersion(DBInstallType installType, Boolean dbExists)
at Microsoft.UpdateServices.Administration.ConfigureDB.ConnectToDB()
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)
Fatal Error: The schema version of the database is from a newer version of WSUS
than currently installed. You must either patch your WSUS server to at least
that version or drop the database.
Thank you so much,
All the best
Last edited:
