Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Tuesday, March 12, 2013 12:15 PM | 1 vote
Server 2012
I'm doing a basic install of WSUS on a member server to the S drive, post error below:
2013-03-11 14:10:07 Postinstall started
2013-03-11 14:10:07 Detected role services: Api, UI, WidDatabase, Services
2013-03-11 14:10:07 Start: LoadSettingsFromXml
2013-03-11 14:10:07 Start: GetConfigValue with filename=UpdateServices-Services.xml item=ContentLocal
2013-03-11 14:10:07 Value is true
2013-03-11 14:10:07 End: GetConfigValue
2013-03-11 14:10:07 Start: GetConfigValue with filename=UpdateServices-Services.xml item=ContentDirectory
2013-03-11 14:10:07 Value is S:\WSUS
2013-03-11 14:10:07 End: GetConfigValue
2013-03-11 14:10:07 Content directory is S:\WSUS
2013-03-11 14:10:07 Database roleservice is not installed
2013-03-11 14:10:07 End: LoadSettingsFromXml
Post install is starting
2013-03-11 14:10:07 Start: Run
2013-03-11 14:10:07 Configuring content directory...
2013-03-11 14:10:07 Configuring groups...
2013-03-11 14:10:08 Starting group configuration for WSUS Administrators...
2013-03-11 14:10:08 Found group in regsitry, attempting to use it...
2013-03-11 14:10:10 Writing group to registry...
2013-03-11 14:10:10 Finished group creation
2013-03-11 14:10:10 Starting group configuration for WSUS Reporters...
2013-03-11 14:10:10 Found group in regsitry, attempting to use it...
2013-03-11 14:10:10 Writing group to registry...
2013-03-11 14:10:10 Finished group creation
2013-03-11 14:10:10 Configuring permissions...
2013-03-11 14:10:10 Fetching content directory...
2013-03-11 14:10:10 Fetching ContentDir from registry store
2013-03-11 14:10:10 Value is S:\WSUS
2013-03-11 14:10:10 Fetching group SIDs...
2013-03-11 14:10:10 Fetching WsusAdministratorsSid from registry store
2013-03-11 14:10:10 Value is S-1-5-21-2610565223-164225667-3587587312-1002
2013-03-11 14:10:10 Fetching WsusReportersSid from registry store
2013-03-11 14:10:10 Value is S-1-5-21-2610565223-164225667-3587587312-1003
2013-03-11 14:10:10 Creating group principals...
2013-03-11 14:10:10 Granting directory permissions...
2013-03-11 14:10:10 Granting permissions on content directory...
2013-03-11 14:10:10 Granting registry permissions...
2013-03-11 14:10:10 Granting registry permissions...
2013-03-11 14:10:10 Granting registry permissions...
2013-03-11 14:10:10 Configuring shares...
2013-03-11 14:10:10 Configuring network shares...
2013-03-11 14:10:10 Fetching content directory...
2013-03-11 14:10:10 Fetching ContentDir from registry store
2013-03-11 14:10:10 Value is S:\WSUS
2013-03-11 14:10:10 Fetching WSUS admin SID...
2013-03-11 14:10:10 Fetching WsusAdministratorsSid from registry store
2013-03-11 14:10:10 Value is S-1-5-21-2610565223-164225667-3587587312-1002
2013-03-11 14:10:10 Content directory is local, creating content shares...
2013-03-11 14:10:11 Creating share "UpdateServicesPackages" with path "S:\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."
2013-03-11 14:10:11 Deleting existing share...
2013-03-11 14:10:11 Creating share...
2013-03-11 14:10:11 Share successfully created
2013-03-11 14:10:11 Creating share "WsusContent" with path "S:\WSUS\WsusContent" and description "A network share to be used by Local Publishing to place published content on this WSUS system."
2013-03-11 14:10:11 Deleting existing share...
2013-03-11 14:10:11 Creating share...
2013-03-11 14:10:11 Share successfully created
2013-03-11 14:10:11 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."
2013-03-11 14:10:11 Deleting existing share...
2013-03-11 14:10:11 Creating share...
2013-03-11 14:10:11 Share successfully created
2013-03-11 14:10:11 Finished creating content shares
2013-03-11 14:10:11 Configuring WID database...
2013-03-11 14:10:11 Configuring the database...
2013-03-11 14:10:11 Establishing DB connection...
2013-03-11 14:10:12 Checking to see if database exists...
2013-03-11 14:10:13 Database exists
2013-03-11 14:10:13 Switching database to single user mode...
2013-03-11 14:10:13 Loading install type query...
2013-03-11 14:10:13 DECLARE @currentScriptVersion int
DECLARE @currentDBVersion int
IF NOT EXISTS(SELECT * FROM sys.databases WHERE name='SUSDB')
BEGIN
SELECT 1
END
ELSE
BEGIN
SET @currentScriptVersion = (9200 + 16384)
SET @currentDBVersion = (SELECT SchemaVersion FROM SUSDB.dbo.tbSchemaVersion WHERE ComponentName = 'CoreDB')
IF @currentDBVersion < 926
BEGIN
SELECT 3
END
ELSE IF @currentDBVersion < @currentScriptVersion
BEGIN
SELECT 2
END
ELSE IF @currentDBVersion = @currentScriptVersion
BEGIN
SELECT 0
END
ELSE
BEGIN
SELECT 4
END
END
2013-03-11 14:10:13 System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'SUSDB.dbo.tbSchemaVersion'.
at Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteGetSingleResult()
at Microsoft.UpdateServices.Administration.ConfigureDB.GetInstallType()
at Microsoft.UpdateServices.Administration.ConfigureDB.ConnectToDB()
at Microsoft.UpdateServices.Administration.ConfigureDB.Configure()
at Microsoft.UpdateServices.Administration.PostInstall.Run()
at Microsoft.UpdateServices.Administration.PostInstall.Execute(String[] arguments)
ClientConnectionId:76f6ee2d-1ffb-4e49-98ea-0fc57758f6b7
Fatal Error: Invalid object name 'SUSDB.dbo.tbSchemaVersion'.
Can someone point me in the right direction, thanks!
All replies (5)
Wednesday, March 13, 2013 5:28 AM ✅Answered
Others have solved this by opening the IIS Manager and deleting the old WSUS web site, then running the Complete WSUS Installation again.
Ian Broadbent
Friday, July 5, 2013 11:02 PM
I'm doing the same, but installing on a member server VM. My error is a little different. I'm also not seeing a WSUS Administration site listed in IIS....I have successfully installed WSUS on another physical 2012 server that is a DC. Using a basic default install to the Windows Internal Database.
Any help would be appreciated.
Thanks in advance.
2013-07-05 17:43:13 Postinstall started
2013-07-05 17:43:13 Detected role services: Api, UI, WidDatabase, Services
2013-07-05 17:43:13 Start: LoadSettingsFromXml
2013-07-05 17:43:13 Start: GetConfigValue with filename=UpdateServices-Services.xml item=ContentLocal
2013-07-05 17:43:13 Value is false
2013-07-05 17:43:13 End: GetConfigValue
2013-07-05 17:43:13 Hosting content on MU
2013-07-05 17:43:13 Database roleservice is not installed
2013-07-05 17:43:13 End: LoadSettingsFromXml
Post install is starting
2013-07-05 17:43:13 Start: Run
2013-07-05 17:43:13 Configuring content directory...
2013-07-05 17:43:13 Configuring groups...
2013-07-05 17:43:13 Starting group configuration for WSUS Administrators...
2013-07-05 17:43:13 Found group in regsitry, attempting to use it...
2013-07-05 17:43:15 Writing group to registry...
2013-07-05 17:43:15 Finished group creation
2013-07-05 17:43:15 Starting group configuration for WSUS Reporters...
2013-07-05 17:43:15 Found group in regsitry, attempting to use it...
2013-07-05 17:43:15 Writing group to registry...
2013-07-05 17:43:15 Finished group creation
2013-07-05 17:43:15 Configuring permissions...
2013-07-05 17:43:15 Fetching content directory...
2013-07-05 17:43:15 Fetching ContentDir from registry store
2013-07-05 17:43:15 Value is C:\Program Files\Update Services
2013-07-05 17:43:15 Fetching group SIDs...
2013-07-05 17:43:15 Fetching WsusAdministratorsSid from registry store
2013-07-05 17:43:15 Value is S-1-5-21-2214278713-3004084040-2508672901-1001
2013-07-05 17:43:15 Fetching WsusReportersSid from registry store
2013-07-05 17:43:15 Value is S-1-5-21-2214278713-3004084040-2508672901-1002
2013-07-05 17:43:15 Creating group principals...
2013-07-05 17:43:15 Granting directory permissions...
2013-07-05 17:43:15 Granting permissions on content directory...
2013-07-05 17:43:15 Granting registry permissions...
2013-07-05 17:43:15 Granting registry permissions...
2013-07-05 17:43:15 Granting registry permissions...
2013-07-05 17:43:15 Configuring shares...
2013-07-05 17:43:15 Configuring network shares...
2013-07-05 17:43:15 Fetching content directory...
2013-07-05 17:43:15 Fetching ContentDir from registry store
2013-07-05 17:43:15 Value is C:\Program Files\Update Services
2013-07-05 17:43:15 Fetching WSUS admin SID...
2013-07-05 17:43:15 Fetching WsusAdministratorsSid from registry store
2013-07-05 17:43:15 Value is S-1-5-21-2214278713-3004084040-2508672901-1001
2013-07-05 17:43:15 Content directory is local, creating content shares...
2013-07-05 17:43:15 Creating share "UpdateServicesPackages" with path "C:\Program Files\Update Services\UpdateServicesPackages" and description "A network share to be used by client systems for collecting all software packages (usually applications) published on this WSUS system."
2013-07-05 17:43:15 Deleting existing share...
2013-07-05 17:43:15 Creating share...
2013-07-05 17:43:15 Share successfully created
2013-07-05 17:43:15 Creating share "WsusContent" with path "C:\Program Files\Update Services\WsusContent" and description "A network share to be used by Local Publishing to place published content on this WSUS system."
2013-07-05 17:43:15 Deleting existing share...
2013-07-05 17:43:15 Creating share...
2013-07-05 17:43:15 Share successfully created
2013-07-05 17:43:15 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."
2013-07-05 17:43:15 Deleting existing share...
2013-07-05 17:43:15 Creating share...
2013-07-05 17:43:15 Share successfully created
2013-07-05 17:43:15 Finished creating content shares
2013-07-05 17:43:15 Configuring WID database...
2013-07-05 17:43:15 Configuring the database...
2013-07-05 17:43:15 Establishing DB connection...
2013-07-05 17:43:15 Checking to see if database exists...
2013-07-05 17:43:15 Database exists
2013-07-05 17:43:15 Switching database to single user mode...
2013-07-05 17:43:16 Loading install type query...
2013-07-05 17:43:16 DECLARE @currentScriptVersion int
DECLARE @currentDBVersion int
IF NOT EXISTS(SELECT * FROM sys.databases WHERE name='SUSDB')
BEGIN
SELECT 1
END
ELSE
BEGIN
SET @currentScriptVersion = (9200 + 16384)
SET @currentDBVersion = (SELECT SchemaVersion FROM SUSDB.dbo.tbSchemaVersion WHERE ComponentName = 'CoreDB')
IF @currentDBVersion < 926
BEGIN
SELECT 3
END
ELSE IF @currentDBVersion < @currentScriptVersion
BEGIN
SELECT 2
END
ELSE IF @currentDBVersion = @currentScriptVersion
BEGIN
SELECT 0
END
ELSE
BEGIN
SELECT 4
END
END
2013-07-05 17:43:16 Install type is: Reinstall
2013-07-05 17:43:16 Creating logins...
2013-07-05 17:43:16 Fetching account info for S-1-5-20
2013-07-05 17:43:16 Found principal
2013-07-05 17:43:16 Found account
2013-07-05 17:43:16 Got binary SID
2013-07-05 17:43:16 Fetching WsusAdministratorsSid from registry store
2013-07-05 17:43:16 Value is S-1-5-21-2214278713-3004084040-2508672901-1001
2013-07-05 17:43:16 Fetching account info for S-1-5-21-2214278713-3004084040-2508672901-1001
2013-07-05 17:43:16 Found principal
2013-07-05 17:43:16 Found account
2013-07-05 17:43:16 Got binary SID
2013-07-05 17:43:16 Setting content location...
2013-07-05 17:43:16 Fetching ContentDir from registry store
2013-07-05 17:43:16 Value is C:\Program Files\Update Services
2013-07-05 17:43:16 Swtching DB to multi-user mode......
2013-07-05 17:43:16 System.Data.SqlClient.SqlException (0x80131904): Schema verification failed for database 'SUSDB'.
ALTER DATABASE statement failed.
Failed to restart the current database. The current database is switched to master.
at Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteCommandNoResult()
at Microsoft.UpdateServices.Administration.ConfigureDB.SetMultiUser(Boolean noFail)
ClientConnectionId:58469161-af94-4a47-a773-5fde151a8679
2013-07-05 17:43:16 System.Data.SqlClient.SqlException (0x80131904): Schema verification failed for database 'SUSDB'.
ALTER DATABASE statement failed.
Failed to restart the current database. The current database is switched to master.
at Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteCommandNoResult()
at Microsoft.UpdateServices.Administration.ConfigureDB.SetMultiUser(Boolean noFail)
at Microsoft.UpdateServices.Administration.ConfigureDB.Configure()
at Microsoft.UpdateServices.Administration.PostInstall.Run()
at Microsoft.UpdateServices.Administration.PostInstall.Execute(String[] arguments)
ClientConnectionId:58469161-af94-4a47-a773-5fde151a8679
Fatal Error: Schema verification failed for database 'SUSDB'.
ALTER DATABASE statement failed.
Failed to restart the current database. The current database is switched to master.
Monday, July 8, 2013 1:42 AM
Server 2012
I'm doing a basic install of WSUS on a member server to the S drive
Let's start here... What is this "S" drive???
Second question.... is this issue at all related to the previous post(s) as noted in this thread?
Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
SolarWinds Head Geek
Microsoft MVP - Software Packaging, Deployment & Servicing (2005-2013)
My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
http://www.solarwinds.com/gotmicrosoft
The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.
Thursday, August 22, 2013 6:21 AM
I´m getting System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'SUSDB.dbo.tbSchemaVersion' when I´m trying to setup WSUS with WID, not SQL database. Previously, I had WSUS with SQL DB, but that didn´t work.
Sunday, August 25, 2013 2:00 AM
I´m getting System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'SUSDB.dbo.tbSchemaVersion' when I´m trying to setup WSUS with WID, not SQL database. Previously, I had WSUS with SQL DB, but that didn´t work.
Please provide more detail about what happened to your "previous" installation. What do you mean by "that didn't work"?
Did you fully and properly uninstall WSUS as described in the How to Uninstall WSUS post?
If so, then please post the content of the WSUSCa_######_####.log file where the first six # represent the install date. The logfile should be in %appdata%\local\temp of the userprofile used to run the installation.
Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
SolarWinds Head Geek
Microsoft MVP - Software Packaging, Deployment & Servicing (2005-2013)
My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
http://www.solarwinds.com/gotmicrosoft
The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.