System Center Virtual Machine Manager 2008 R2 setup fails with Error 2605

Article ID: 2562909 - View products that this article applies to.
Expand all | Collapse all

Symptoms

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

Cause

This may occur if the following conditions both apply:

  • Setup is being run as an account that does not have sysadmin rights on the SQL Server.
  • A service account is specified for the SQL instance that does have sysadmin rights on the SQL Server.

The SQL commands will initially be executed in the context of the user account running setup, not the service account.  After installation, the service account will be used for normal operations.

Resolution

To allow setup to complete successfully in this scenario, hold down the SHIFT key and right-click on setup.exe on the Virtual Machine Manager 2008 R2 installation media.  Choose Run as different user and then enter the credentials for the service account with sysadmin rights on the VMM server.

Notes:

  • Alternatively, you can log off the server and log back on as the service account user.
  • Before running setup, you will need to uninstall SCVMM from Control Panel\Programs and Features first before re-running setup.
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2562909 - Last Review: May 8, 2012 - Revision: 6.0
APPLIES TO
  • Microsoft System Center Virtual Machine Manager 2008
  • Microsoft System Center Virtual Machine Manager 2008 R2 Workgroup Edition
Keywords: 
KB2562909

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com