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.
