Microsoft System Center Virtual Machine Manager 2008 R2 (SCVMM 2008 R2) setup may fail with the following error message during the Virtual Machine Manager Server portion of setup:
Unable to connect to the VMM database because of a general database failure. Ensure that the SQL Server is running and configured correctly, then try the operation again.
ID: 2605. Details: SQL error code: 15247
ServerSetup.log (%ProgramData%\vmmlogs\serversetup.log) will also have entries similar to the following:
[6/3/2011 4:00:18 PM] Data : bcpPath = "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\bcp.exe"
[6/3/2011 4:00:18 PM] * Exception : => Unable to connect to the VMM database because of a general database failure.Ensure that the SQL Server is running and configured correctly, then try the operation again.Microsoft.VirtualManager.Setup.Exceptions.BackEndErrorException: Unable to connect to the VMM database because of a general database failure.
Ensure that the SQL Server is running and configured correctly, then try the operation again. ---> Microsoft.VirtualManager.DB.CarmineSqlException: Unable to connect to the VMM database because of a general database failure.
Ensure that the SQL Server is running and configured correctly, then try the operation again. ---> System.Data.SqlClient.SqlException: User does not have permission to perform this action.
at System.Data.SqlClient.SqlConnection.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 stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.VirtualManager.DB.SqlRetryCommand.InternalExecuteReader()
--- End of inner exception stack trace ---
at Microsoft.VirtualManager.DB.SqlRetryCommand.InternalExecuteReader()
at Microsoft.VirtualManager.DB.SqlRetryCommand.ExecuteReader(Int32[] expectedDSColumns)
at Microsoft.VirtualManager.Setup.Helpers.SetupDatabaseHelper.RemoveSqlLogin(String connectinString, String loginName)
at Microsoft.VirtualManager.Setup.Configuration.DBConfigurator.GrantCarmineDBAccess()
at Microsoft.VirtualManager.Setup.Wizard.Configurator.GrantCarmineDBAccess()
at Microsoft.VirtualManager.Setup.Wizard.BackEnd.ConfigureServer()
at Microsoft.VirtualManager.Setup.Wizard.VMInstaller.Configure()
*** Carmine error was: DatabaseFailure (2605); SQLServer; 15247
--- SqlException details -----------------
System.Data.SqlClient.SqlException: User does not have permission to perform this action.
at System.Data.SqlClient.SqlConnection.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 stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.VirtualManager.DB.SqlRetryCommand.InternalExecuteReader()
Error = 15247
Index 0
Source: .Net SqlClient Data Provider
Number: 15247
State: 1
Class: 16
Server: servername\instance
Message: User does not have permission to perform this action.
Procedure: sp_helplogins
Line: 72