KB: You may receive the error "Setup Cannot be Completed" when installing System Center 2012 Operations Manager
Published Feb 15 2019 12:16 PM 131 Views
First published on TECHNET on May 09, 2012

Here’s a new Knowledge Base article we published this morning. This one discusses a database related issue you may run into when installing System Center 2012 Operations Manager.

=====

Symptoms

While installing System Center 2012 Operations Manager, the installation fails and you receive the error "Setup Cannot be Completed".

Cause

This may occur if the OperationsManager.mdf and OperationsManager.ldf files already exist in the directory where you chose to install the new OperationsManager database. If this occurs you will see an error similar to the following in the OpsMgrSetupWizard.log file:
[05:44:19]: Error: :Exception running sql string CREATE DATABASE [OperationsManager] ON PRIMARY(NAME=MOM_DATA,FILENAME='C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\OperationsManager.mdf',SIZE=1000MB,MAXSIZE=1000MB,FILEGROWTH=0MB) LOG ON(NAME=MOM_LOG, FILENAME='C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\OperationsManager.ldf',SIZE=500MB,MAXSIZE=500MB,FILEGROWTH=0MB) COLLATE SQL_Latin1_General_CP1_CI_AS: Threw Exception.Type: System.Data.SqlClient.SqlException, Exception Error Code: 0x80131904, Exception.Message: Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\OperationsManager.mdf' because it already exists. Change the file path or the file name, and retry the operation.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
[05:44:19]: Error: :StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject 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.EnterpriseManagement.OperationsManager.Setup.DBConfigurationHelper.DBConfiguration.RunSqlStrings(String[] sqlCommands)
[05:44:19]: Always: :Failed to create and configure the DB with exception.: Threw Exception.Type: System.Data.SqlClient.SqlException, Exception Error Code: 0x80131904, Exception.Message: Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\OperationsManager.mdf' because it already exists. Change the file path or the file name, and retry the operation.
CREATE DATABASE failed . Some file names listed could not be created. Check related errors.

NOTE The OpsMgrSetupWizard.log file is located in C:\Users\<InstallationAccount>\AppData\Local\SCOM\Logs

Resolution

To resolve this issue, you must either delete the old OperationsManager mdf and ldf files, or move them to a separate location and run the install again.

=====

For the most current version of this article please see the following:

2705760 - You may receive the error "Setup Cannot be Completed" when installing System Center 2...

J.C. Hornbeck | System Center & Security Knowledge Engineer

Get the latest System Center news on Facebook and Twitter :

App-V Team blog: http://blogs.technet.com/appv/
ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/
DPM Team blog: http://blogs.technet.com/dpm/
MED-V Team blog: http://blogs.technet.com/medv/
Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/
Operations Manager Team blog: http://blogs.technet.com/momteam/
SCVMM Team blog: http://blogs.technet.com/scvmm
Server App-V Team blog: http://blogs.technet.com/b/serverappv
Service Manager Team blog: http://blogs.technet.com/b/servicemanager
System Center Essentials Team blog: http://blogs.technet.com/b/systemcenteressentials
WSUS Support Team blog: http://blogs.technet.com/sus/

The Forefront Server Protection blog: http://blogs.technet.com/b/fss/
The Forefront Endpoint Security blog : http://blogs.technet.com/b/clientsecurity/
The Forefront Identity Manager blog : http://blogs.msdn.com/b/ms-identity-support/
The Forefront TMG blog: http://blogs.technet.com/b/isablog/
The Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/

Version history
Last update:
‎Mar 11 2019 09:16 AM
Updated by: