locked
configuration database creation failed on MOSS 2007/ SQL SERVER 2005 RRS feed

  • Question

  • hi ,

    i am trying to install  MOSS 2007 on a windows server 2003 server -32 bit machine-

    am having sql server 2005 as DB.

     but am getting the error message failed to create the  config database,after running the  config wizard after installing MOSS 2007 in that machine.

     am stuck with these  for few days , unable to find out why this error is  coming!!!

    should i instal  any Service pack of  moss 2007 or sql server 2005 in that machine? previously the infra-dept-guys  have installed sql server 2008 also in that machine before i install  moss 2007. even then  the same  error  came, then i thot, it may be bacause of the presence of sql server 2008.so i uninstalled the  sql 2008 and didnt touch sql 2005. by keeping the  sql 2005 i was trying to install moss 2007 E-cal ,

    but in vain!!!

    the below is the errro log i got from ULS 


    Timestamp                    Process                                     TID      Area                             Category                                  EventID            Level                Message           Correlation
    08/21/2012 17:26:50.06          PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Topology                                  88ab    High    Creating the farm Data Source=myservername;Initial Catalog=SharePoint_Config;Integrated Security=True 
    08/21/2012 17:26:50.06          PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Topology                                  88b2    High    Validating Farm Account: mycompany\serviceaccountname      
    08/21/2012 17:26:50.06          PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Topology                                  88b5    Medium            Attempting to LogonUser using the Farm Account to verify the password, mycompany\serviceaccountname.           
    08/21/2012 17:26:50.07          PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Topology                                  88b6    Medium            LogonUser succeeded for mycompany\serviceaccountname.            
    08/21/2012 17:26:50.07          PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Topology                                  88b8    High    mycompany\serviceaccountname is a valid Farm Account.        
    08/21/2012 17:26:50.09          PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Topology                                  75bf    High    Provisioning the configuration database.          
    08/21/2012 17:26:50.12           PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Database                                  8dyf     Medium            Provisioning the database SharePoint_Config on the server myservername with the sql file ConfigurationDatabase.        
    08/21/2012 17:26:50.15           PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Database                                  7t6g     Medium            Ensuring that the SharePoint_Config database exists . . .            
    08/21/2012 17:26:50.21           PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Database                                  7t6o     High    The SharePoint_Config database does not exist.  It will now be created.           
    08/21/2012 17:26:51.92           PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Database                                  8dye     Medium            Setting the autoclose option to False on the database SharePoint_Config.      
    08/21/2012 17:26:52.16           PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Database                                  7t62     Medium            Checking the edition of the SharePoint_Config database.            
    08/21/2012 17:26:52.16           PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Database                                  7t63     High    The SharePoint_Config database is running on the Developer Edition of sql server.    
    08/21/2012 17:26:52.19           PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Database                                  7fcx     Medium            Executing sql file ConfigurationDatabase with timeout 600            
    08/21/2012 17:26:53.48          PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Database                                  7t6b     Medium            Completed provisioning the database SharePoint_Config on the server myservername with the sql file ConfigurationDatabase.    
    08/21/2012 17:26:53.48          PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Topology                                  75bg    High    Registering the SPFarm and the config db's SPServer and SPService objects.       
    08/21/2012 17:26:53.54          PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Database                                  94c7    High    Ensuring that the sql role, WSS_Content_Application_Pools, exists in the configuration database.   
    08/21/2012 17:26:53.65          PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Database                                  94c9    High    Granting the sql role, WSS_Content_Application_Pools, permission to access some stored procedures in the configuration database.         
    08/21/2012 17:26:53.81           PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Topology                                  8xqz     Medium            Updating SPPersistedObject SPFarm Name=SharePoint_Config. Version: -1 Ensure: 0, HashCode: 12036987, Id: 91573096-6c12-4eb8-823d-132c303c3397, Stack:    at Microsoft.SharePoint.Administration.SPPersistedObject.Update()     at Microsoft.SharePoint.Administration.SPFarm.Update()     at Microsoft.SharePoint.Administration.SPConfigurationDatabase.RegisterDefaultDatabaseServices(SqlConnectionStringBuilder connectionString)     at Microsoft.SharePoint.Administration.SPConfigurationDatabase.Provision(SqlConnectionStringBuilder connectionString)     at Microsoft.SharePoint.Administration.SPFarm.Create(SqlConnectionStringBuilder configurationDatabase, SqlConnectionStringBuilder administrationContentDatabase, IdentityType identityType, String farmUser, SecureString farmPassword)     at Microsoft.Sha...    
    08/21/2012 17:26:53.81*         PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Topology                                  8xqz     Medium              ...rePoint.Administration.SPFarm.Create(SqlConnectionStringBuilder configurationDatabase, SqlConnectionStringBuilder administrationContentDatabase, String farmUser, SecureString farmPassword)     at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.CreateOrConnectConfigDb()     at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Run()     at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()     at System.Threading.ThreadHelper.ThreadStart_Context(Object state)     at System.Threading.ExecutionContext.runTryCode(Object userData)     at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)     at System.Threading.ExecutionContext.RunInternal(ExecutionCont...          
    08/21/2012 17:26:53.81*         PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Topology                                  8xqz     Medium            ...ext executionContext, ContextCallback callback, Object state)     at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)     at System.Threading.ThreadHelper.ThreadStart()      
    08/21/2012 17:26:53.96          PSConfigUI.exe (0x1078)                     0x1370 Windows SharePoint Services               Topology                                  8dyo     Medium            Farm Admin check bypassed for provisioning.   
    08/21/2012 17:27:08.01           PSConfigUI.exe (0x1078)                     0x0EEC            ULS Logging                               Unified Logging Service           8wsw    High    Now terminating ULS (PSConfigUI.exe, onetnative.dll) 
    08/21/2012 17:27:49.19           psconfigui.exe (0x1424)                       0x13E8 Windows SharePoint Services               Topology                                  0          Medium            Diagnostics settings: 32768     
    08/21/2012 17:27:49.18           psconfigui.exe (0x1424)                       0x13E8 ULS Logging                             Unified Logging Service            8wsv     High    ULS Init Completed (psconfigui.exe, onetnative.dll)     
    08/21/2012 17:29:19.14           psconfigui.exe (0x1424)                       0x13E8 ULS Logging                             Unified Logging Service            8wsw    High    Now terminating ULS (psconfigui.exe, onetnative.dll)   
    08/21/2012 17:29:14.12           psconfigui.exe (0x1424)                       0x02A4            Windows SharePoint Services               Topology                                  88ab    High    Creating the farm Data Source=myservername;Initial Catalog=SharePoint_Config;Integrated Security=True 
    08/21/2012 17:29:14.12           psconfigui.exe (0x1424)                       0x02A4            Windows SharePoint Services               Topology                                  88b2    High    Validating Farm Account: mycompany\serviceaccountname      
    08/21/2012 17:29:14.12           psconfigui.exe (0x1424)                       0x02A4            Windows SharePoint Services               Topology                                  88b5    Medium            Attempting to LogonUser using the Farm Account to verify the password, mycompany\serviceaccountname.           
    08/21/2012 17:29:14.12           psconfigui.exe (0x1424)                       0x02A4            Windows SharePoint Services               Topology                                  88b6    Medium            LogonUser succeeded for mycompany\serviceaccountname.            
    08/21/2012 17:29:14.12           psconfigui.exe (0x1424)                       0x02A4            Windows SharePoint Services               Topology                                  88b8    High    mycompany\serviceaccountname is a valid Farm Account.        
    08/21/2012 17:29:14.12           psconfigui.exe (0x1424)                       0x02A4            Windows SharePoint Services               Topology                                  75bf    High    Provisioning the configuration database.          
    08/21/2012 17:29:14.12           psconfigui.exe (0x1424)                       0x02A4            Windows SharePoint Services               Database                                  8dyf     Medium            Provisioning the database SharePoint_Config on the server myservername with the sql file ConfigurationDatabase.        
    08/21/2012 17:29:14.14           psconfigui.exe (0x1424)                       0x02A4            Windows SharePoint Services               Database                                  7t6g     Medium            Ensuring that the SharePoint_Config database exists . . .            
    08/21/2012 17:29:14.17           psconfigui.exe (0x1424)                       0x02A4            Windows SharePoint Services               Database                                  7t6o     High    The SharePoint_Config database does not exist.  It will now be created.           
    08/21/2012 17:29:14.25           psconfigui.exe (0x1424)                       0x02A4            Windows SharePoint Services               Database                                  880i     High    System.Data.SqlClient.SqlException: CREATE DATABASE failed. Some file names listed could not be created. Check related errors.  Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SharePoint_Config.mdf' because it already exists. Change the file path or the file name, and retry the operation.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject...   
    08/21/2012 17:29:14.25*         psconfigui.exe (0x1424)                       0x02A4            Windows SharePoint Services               Database                                  880i     High    ... stateObj)     at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)     at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()     at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command)   
    08/21/2012 17:29:14.25           psconfigui.exe (0x1424)                       0x02A4            Windows SharePoint Services               Database                                  880j     High    SqlError: 'CREATE DATABASE failed. Some file names listed could not be created. Check related errors.'    Source: '.Net SqlClient Data Provider' Number: 1802 State: 4 Class: 16 Procedure: '' LineNumber: 1 Server: 'myservername' 
    08/21/2012 17:29:14.25           psconfigui.exe (0x1424)                       0x02A4            Windows SharePoint Services               Database                                  880j     High    SqlError: 'Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SharePoint_Config.mdf' because it already exists. Change the file path or the file name, and retry the operation.'    Source: '.Net SqlClient Data Provider' Number: 5170 State: 1 Class: 16 Procedure: '' LineNumber: 1 Server: 'myservername'          
    08/21/2012 17:29:14.26           psconfigui.exe (0x1424)                       0x02A4            Windows SharePoint Services               Database                                  5586    Critical Unknown SQL Exception 1802 occured. Additional error information from SQL Server is included below.  CREATE DATABASE failed. Some file names listed could not be created. Check related errors.  Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SharePoint_Config.mdf' because it already exists. Change the file path or the file name, and retry the operation. 
    08/21/2012 17:29:14.32           psconfigui.exe (0x1424)                       0x02A4            Windows SharePoint Services               Database                                  880k    High       at Microsoft.SharePoint.Administration.SPDatabase.EnsureSqlDatabase(SqlConnectionStringBuilder connectionString)     at Microsoft.SharePoint.Administration.SPDatabase.SetDatabaseOptions(SqlConnectionStringBuilder connectionString, Dictionary`2 options)     at Microsoft.SharePoint.Administration.SPDatabase.Provision(SqlConnectionStringBuilder connectionString, SqlFile sqlFileId, String sqlSignaturePath, Dictionary`2 options)     at Microsoft.SharePoint.Administration.SPConfigurationDatabase.Provision(SqlConnectionStringBuilder connectionString)     at Microsoft.SharePoint.Administration.SPFarm.Create(SqlConnectionStringBuilder configurationDatabase, SqlConnectionStringBuilder administrationContentDatabase, IdentityType identityType, String farmUser, SecureString farmPassword)     at Micr...       
    08/21/2012 17:29:14.32*         psconfigui.exe (0x1424)                       0x02A4            Windows SharePoint Services               Database                                  880k    High                ...osoft.SharePoint.Administration.SPFarm.Create(SqlConnectionStringBuilder configurationDatabase, SqlConnectionStringBuilder administrationContentDatabase, String farmUser, SecureString farmPassword)     at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.CreateOrConnectConfigDb()     at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Run()     at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()     at System.Threading.ThreadHelper.ThreadStart_Context(Object state)     at System.Threading.ExecutionContext.runTryCode(Object userData)     at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)     at System.Threading.ExecutionContext.RunInternal(Exec...            
    08/21/2012 17:29:14.32*         psconfigui.exe (0x1424)                       0x02A4            Windows SharePoint Services               Database                                  880k    High    ...utionContext executionContext, ContextCallback callback, Object state)     at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)     at System.Threading.ThreadHelper.ThreadStart()               
    08/21/2012 17:29:14.32           psconfigui.exe (0x1424)                       0x02A4            Windows SharePoint Services               Database                                  880l     High    ConnectionString: 'Data Source=myservername;Initial Catalog=master;Integrated Security=True;Pooling=False'    ConnectionState: Open ConnectionTimeout: 15     
    08/21/2012 17:29:14.32           psconfigui.exe (0x1424)                       0x02A4            Windows SharePoint Services               Database                                  880m    High    SqlCommand: 'create database [SharePoint_Config] COLLATE Latin1_General_CI_AS_KS_WS '     CommandType: Text CommandTimeout: 0            
    08/21/2012 17:30:00.56          PSConfig.exe (0x1570)                         0x1550 ULS Logging                             Unified Logging Service            8wsv     High    ULS Init Completed (PSConfig.exe, onetnative.dll)       
    08/21/2012 17:30:00.56          PSConfig.exe (0x1570)                         0x1550 Windows SharePoint Services               Topology                                  0          Medium            Diagnostics settings: 32768     
    08/21/2012 17:30:00.89          PSConfig.exe (0x1570)                         0x1550 ULS Logging                             Unified Logging Service            8wsw    High    Now terminating ULS (PSConfig.exe, onetnative.dll)     



    Monday, September 3, 2012 4:52 AM

All replies

  • Hi,

    please check the location in your file system where your databases are stored. The issue seems to be, that there is a file named sharepoint_config.mdf already.

    Looks like you detached an old config DB from your SQL-Server and the creation of a new one fails due to an existing file.

    The key from your ULS log is:

    System.Data.SqlClient.SqlException: CREATE DATABASE failed. Some file names listed could not be created. Check related errors.  Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SharePoint_Config.mdf' because it already exists. Change the file path or the file name, and retry the operation.    

    Cheers

    Chris


    • Edited by charlybravo Monday, September 3, 2012 10:52 AM
    Monday, September 3, 2012 10:52 AM
  • Hi Benjamin,

    If you want to use SharePoint 2007 just for development purpose, then you need not require any SQL Server installed before.  It comes with inbuilt version of SQL Server which will be configured automatically.

    But if you already have an SQL Server in your environment, then you can configure the same using the Configuration Wizard.

    Now, it looks like you have added/removed multiple version of SQL Server, which has left something uncleaned in your PC.  I would recommend you to uninstall all instances/versions of SQL Server first, then verify if it has left over any MDF files in the \Program Files\SQL Server folder.

    I would also suggest that you download the SharePoint 2007 with latest service pack (if you are a Technet subscriber, you will get this setup bundle).

    Also, for your kind information SharePoint 2007 support life cycle has ended!  The same applies to your other products - Windows 2003, SQL Server 2005.

    http://support.microsoft.com/lifecycle/?p1=11373

    http://support.microsoft.com/lifecycle/?p1=16496

    At this point of time, I would recommend you to consider SharePoint 2010.  If your organization/you are working on latest version of products, then you may even explore the upcoming SharePoint 2013.

    Hope this helps.


    Thanks & Regards,
    Kamlesh | Blog | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, September 4, 2012 2:46 AM