locked
WSUS Post Deployment Configuration Fails on Windows Server 2012 RRS feed

  • Question

  • I ran into a problem a few weeks ago at my office.  We were trying to install windows  server update services on windows server 2012 standard. A requirement to use software updates with Configuration Manager is the need to install WSUS.  I Installed WSUS via Server Manager with no problem, however when I tried to run the Post Deployment Configuration the task failed.  in post installation notification following error is there :-  

    Log file is located at C:\Users\administrator.ANUPROJECTS\AppData\Local\Temp\tmpA85C.tmp
    Post install is starting
    Fatal Error: Database creation failed

    When I open this file the below mentioned error is there :-

    2014-12-17 16:05:39  Postinstall started
    2014-12-17 16:05:39  Detected role services: Api, UI, WidDatabase, Services
    2014-12-17 16:05:39  Start: LoadSettingsFromParameters
    2014-12-17 16:05:39  Content local is: True
    2014-12-17 16:05:39  Content directory is: E:\WSUS
    2014-12-17 16:05:39  SQL instname is: 
    2014-12-17 16:05:39  End: LoadSettingsFromParameters
    2014-12-17 16:05:39  Start: Run
    2014-12-17 16:05:39  Configuring content directory...
    2014-12-17 16:05:39  Configuring groups...
    2014-12-17 16:05:39  Starting group configuration for WSUS Administrators...
    2014-12-17 16:05:39  Found group in regsitry, attempting to use it...
    2014-12-17 16:05:39  Searching for existing group...
    2014-12-17 16:05:39  Existing group was found
    2014-12-17 16:05:39  Writing group to registry...
    2014-12-17 16:05:39  Finished group creation
    2014-12-17 16:05:39  Starting group configuration for WSUS Reporters...
    2014-12-17 16:05:39  Found group in regsitry, attempting to use it...
    2014-12-17 16:05:39  Searching for existing group...
    2014-12-17 16:05:39  Existing group was found
    2014-12-17 16:05:39  Writing group to registry...
    2014-12-17 16:05:39  Finished group creation
    2014-12-17 16:05:39  Configuring permissions...
    2014-12-17 16:05:39  Fetching content directory...
    2014-12-17 16:05:39  Fetching ContentDir from registry store
    2014-12-17 16:05:39  Value is E:\WSUS
    2014-12-17 16:05:39  Fetching group SIDs...
    2014-12-17 16:05:39  Fetching WsusAdministratorsSid from registry store
    2014-12-17 16:05:39  Value is S-1-5-21-1548033848-35055123-3464044250-1629
    2014-12-17 16:05:39  Fetching WsusReportersSid from registry store
    2014-12-17 16:05:39  Value is S-1-5-21-1548033848-35055123-3464044250-1630
    2014-12-17 16:05:39  Creating group principals...
    2014-12-17 16:05:39  Granting directory permissions...
    2014-12-17 16:05:39  Granting permissions on content directory...
    2014-12-17 16:05:39  Granting registry permissions...
    2014-12-17 16:05:39  Granting registry permissions...
    2014-12-17 16:05:40  Granting registry permissions...
    2014-12-17 16:05:40  Configuring shares...
    2014-12-17 16:05:40  Configuring network shares...
    2014-12-17 16:05:40  Fetching content directory...
    2014-12-17 16:05:40  Fetching ContentDir from registry store
    2014-12-17 16:05:40  Value is E:\WSUS
    2014-12-17 16:05:40  Fetching WSUS admin SID...
    2014-12-17 16:05:40  Fetching WsusAdministratorsSid from registry store
    2014-12-17 16:05:40  Value is S-1-5-21-1548033848-35055123-3464044250-1629
    2014-12-17 16:05:40  Content directory is local, creating content shares...
    2014-12-17 16:05:40  Creating share "UpdateServicesPackages" with path "E:\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."
    2014-12-17 16:05:40  Deleting existing share...
    2014-12-17 16:05:40  Creating share...
    2014-12-17 16:05:40  Share successfully created
    2014-12-17 16:05:40  Creating share "WsusContent" with path "E:\WSUS\WsusContent" and description "A network share to be used by Local Publishing to place published content on this WSUS system."
    2014-12-17 16:05:40  Deleting existing share...
    2014-12-17 16:05:40  Creating share...
    2014-12-17 16:05:40  Share successfully created
    2014-12-17 16:05: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."
    2014-12-17 16:05:40  Deleting existing share...
    2014-12-17 16:05:40  Creating share...
    2014-12-17 16:05:40  Share successfully created
    2014-12-17 16:05:40  Finished creating content shares
    2014-12-17 16:05:40  Configuring WID database...
    2014-12-17 16:05:40  Configuring the database...
    2014-12-17 16:05:40  Establishing DB connection...
    2014-12-17 16:05:40  Checking to see if database exists...
    2014-12-17 16:05:40  Database does not exist
    2014-12-17 16:05:40  Loading install type query...
    2014-12-17 16:05:40  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

    2014-12-17 16:05:40  Install type is: Fresh
    2014-12-17 16:05:40  Creating database...
    2014-12-17 16:05:41  Msg 5170, Level 16, State 1, Server \\.\pipe\Microsoft##WID\tsql\query,  Line 2
    Cannot create file 'C:\Windows\WID\Data\SUSDB.mdf' because it already exists. Change the file path or the file name, and retry the operation.Msg 1802, Level 16, State 4, Server \\.\pipe\Microsoft##WID\tsql\query,  Line 2
    CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
    2014-12-17 16:05:41  Microsoft.UpdateServices.Administration.CommandException: Database creation failed
       at Microsoft.UpdateServices.Administration.ConfigureDB.CreateDatabase()
       at Microsoft.UpdateServices.Administration.ConfigureDB.Configure()
       at Microsoft.UpdateServices.Administration.PostInstall.Run()
       at Microsoft.UpdateServices.Administration.PostInstall.Execute(String[] arguments)

    ===========================================================================================

    Please help me on this situation.

    Thanks on advance.

    Wednesday, December 17, 2014 10:39 AM

Answers

  • 2014-12-17 16:05:41  Msg 5170, Level 16, State 1, Server \\.\pipe\Microsoft##WID\tsql\query,  Line 2
    Cannot create file 'C:\Windows\WID\Data\SUSDB.mdf' because it already exists

    Looks like somebody forgot to remove the database from the last time WSUS was installed.


    Lawrence Garvin, M.S., MCSA, MCITP:EA, MCDBA
    SolarWinds Head Geek
    Microsoft MVP - Software Packaging, Deployment & Servicing (2005-2014)
    My MVP Profile: http://mvp.microsoft.com/en-us/mvp/Lawrence%20R%20Garvin-32101
    http://www.solarwinds.com/gotmicrosoft
    The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.


    • Edited by Lawrence Garvin Thursday, December 18, 2014 11:34 PM Fixed <blockquote> in HTML
    • Marked as answer by Steven_Lee0510 Monday, December 29, 2014 7:48 AM
    Wednesday, December 17, 2014 4:03 PM

All replies

  • 2014-12-17 16:05:41  Msg 5170, Level 16, State 1, Server \\.\pipe\Microsoft##WID\tsql\query,  Line 2
    Cannot create file 'C:\Windows\WID\Data\SUSDB.mdf' because it already exists

    Looks like somebody forgot to remove the database from the last time WSUS was installed.


    Lawrence Garvin, M.S., MCSA, MCITP:EA, MCDBA
    SolarWinds Head Geek
    Microsoft MVP - Software Packaging, Deployment & Servicing (2005-2014)
    My MVP Profile: http://mvp.microsoft.com/en-us/mvp/Lawrence%20R%20Garvin-32101
    http://www.solarwinds.com/gotmicrosoft
    The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.


    • Edited by Lawrence Garvin Thursday, December 18, 2014 11:34 PM Fixed <blockquote> in HTML
    • Marked as answer by Steven_Lee0510 Monday, December 29, 2014 7:48 AM
    Wednesday, December 17, 2014 4:03 PM
  • I ran into this issue a few weeks ago with 2012R2. What worked for me, was to demote the server from a domain controller. Then ran the post deployment configuration with no issues. After that, I promoted it back to a domain controller and no further issues.
    Thursday, December 18, 2014 9:25 PM