none
WSUS Post-deployment Configuration Failed RRS feed

  • 問題

  • I'm doing a basic install of WSUS  , post error below:

    2016-05-13 10:08:30  Postinstall started
    2016-05-13 10:08:30  Detected role services: Api, Database, UI, Services
    2016-05-13 10:08:30  Start: LoadSettingsFromXml
    2016-05-13 10:08:30  Start: GetConfigValue with filename=UpdateServices-Services.xml item=ContentLocal
    2016-05-13 10:08:30  Value is true
    2016-05-13 10:08:30  End: GetConfigValue
    2016-05-13 10:08:30  Start: GetConfigValue with filename=UpdateServices-Services.xml item=ContentDirectory
    2016-05-13 10:08:30  Value is E:\WSUSDATA
    2016-05-13 10:08:30  End: GetConfigValue
    2016-05-13 10:08:30  Content directory is E:\WSUSDATA
    2016-05-13 10:08:30  Start: GetConfigValue with filename=UpdateServices-DB.xml item=InstanceName
    2016-05-13 10:08:30  Value is 192.168.0.217
    2016-05-13 10:08:30  End: GetConfigValue
    2016-05-13 10:08:30  SQL instance name is 192.168.0.217
    2016-05-13 10:08:30  End: LoadSettingsFromXml
    2016-05-13 10:08:30  Start: Run
    2016-05-13 10:08:30  Fetching WsusAdministratorsSid from registry store
    2016-05-13 10:08:30  Value is S-1-5-21-76479820-651512832-675094541-1002
    2016-05-13 10:08:30  Fetching WsusReportersSid from registry store
    2016-05-13 10:08:30  Value is S-1-5-21-76479820-651512832-675094541-1003
    2016-05-13 10:09:30  Configuring content directory...
    2016-05-13 10:09:30  Configuring groups...
    2016-05-13 10:09:30  Starting group configuration for WSUS Administrators...
    2016-05-13 10:09:30  Found group in regsitry, attempting to use it...
    2016-05-13 10:09:34  Writing group to registry...
    2016-05-13 10:09:34  Finished group creation
    2016-05-13 10:09:34  Starting group configuration for WSUS Reporters...
    2016-05-13 10:09:34  Found group in regsitry, attempting to use it...
    2016-05-13 10:09:34  Writing group to registry...
    2016-05-13 10:09:34  Finished group creation
    2016-05-13 10:09:34  Configuring permissions...
    2016-05-13 10:09:34  Fetching content directory...
    2016-05-13 10:09:34  Fetching ContentDir from registry store
    2016-05-13 10:09:34  Value is E:\WSUSDATA
    2016-05-13 10:09:34  Fetching group SIDs...
    2016-05-13 10:09:34  Fetching WsusAdministratorsSid from registry store
    2016-05-13 10:09:34  Value is S-1-5-21-76479820-651512832-675094541-1002
    2016-05-13 10:09:34  Fetching WsusReportersSid from registry store
    2016-05-13 10:09:34  Value is S-1-5-21-76479820-651512832-675094541-1003
    2016-05-13 10:09:34  Creating group principals...
    2016-05-13 10:09:34  Granting directory permissions...
    2016-05-13 10:09:37  Granting permissions on content directory...
    2016-05-13 10:09:37  Granting registry permissions...
    2016-05-13 10:09:37  Granting registry permissions...
    2016-05-13 10:09:37  Granting registry permissions...
    2016-05-13 10:09:37  Configuring shares...
    2016-05-13 10:09:37  Configuring network shares...
    2016-05-13 10:09:37  Fetching content directory...
    2016-05-13 10:09:37  Fetching ContentDir from registry store
    2016-05-13 10:09:37  Value is E:\WSUSDATA
    2016-05-13 10:09:37  Fetching WSUS admin SID...
    2016-05-13 10:09:37  Fetching WsusAdministratorsSid from registry store
    2016-05-13 10:09:37  Value is S-1-5-21-76479820-651512832-675094541-1002
    2016-05-13 10:09:37  Content directory is local, creating content shares...
    2016-05-13 10:09:39  Creating share "UpdateServicesPackages" with path "E:\WSUSDATA\UpdateServicesPackages" and description "A network share to be used by client systems for collecting all software packages (usually applications) published on this WSUS system."
    2016-05-13 10:09:39  Deleting existing share...
    2016-05-13 10:09:39  Creating share...
    2016-05-13 10:09:39  Share successfully created
    2016-05-13 10:09:39  Creating share "WsusContent" with path "E:\WSUSDATA\WsusContent" and description "A network share to be used by Local Publishing to place published content on this WSUS system."
    2016-05-13 10:09:39  Deleting existing share...
    2016-05-13 10:09:40  Creating share...
    2016-05-13 10:09:40  Share successfully created
    2016-05-13 10:09: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."
    2016-05-13 10:09:40  Deleting existing share...
    2016-05-13 10:09:40  Creating share...
    2016-05-13 10:09:41  Share successfully created
    2016-05-13 10:09:41  Finished creating content shares
    2016-05-13 10:09:41  Stopping service WSUSService
    2016-05-13 10:09:41  Stopping service W3SVC
    2016-05-13 10:09:41  Configuring database...
    2016-05-13 10:09:45  Configuring the database...
    2016-05-13 10:09:45  Establishing DB connection...
    2016-05-13 10:09:46  Checking to see if database exists...
    2016-05-13 10:09:46  Database exists
    2016-05-13 10:09:46  Switching database to single user mode...
    2016-05-13 10:09:46  Loading install type query...
    2016-05-13 10:09:47  DECLARE @currentDBVersion       int
    DECLARE @scriptMajorVersion     int = (9600)
    DECLARE @scriptMinorVersion     int = (18324)
    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

    2016-05-13 10:09:47  System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'SUSDB.dbo.tbSchemaVersion'.
       於 Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
       於 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteGetSingleResult()
       於 Microsoft.UpdateServices.Administration.ConfigureDB.GetInstallType()
       於 Microsoft.UpdateServices.Administration.ConfigureDB.ConnectToDB()
       於 Microsoft.UpdateServices.Administration.ConfigureDB.Configure()
       於 Microsoft.UpdateServices.Administration.PostInstall.Run()
       於 Microsoft.UpdateServices.Administration.PostInstall.Execute(String[] arguments)
    ClientConnectionId:659d6828-6ce8-4ac3-98db-cd6df8f2ca27
    Error Number:208,State:1,Class:16

    -----------------------------------------------------------------------------------------

    MSSQL 2012 and SUSDB in multiuser mode 

    Can someone point me in the right direction, thanks!

    2016年5月13日 上午 02:27