KBHere’s a new Knowledge Base article we published this morning that talks about an issue you might run into when trying to install System Center Virtual Machine Manager 2008. This one deals with an accounts/permissions issue and fortunately it’s an easy one to resolve:

=====

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

%ProgramData%\VMMLogs\ServerSetup.txt will 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.

=====

For the most current version of this article be sure to view it directly from the source here:

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

J.C. Hornbeck | System Center Knowledge Engineer

The App-V Team blog: http://blogs.technet.com/appv/
The WSUS Support Team blog: http://blogs.technet.com/sus/
The SCMDM Support Team blog: http://blogs.technet.com/mdm/
The ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/
The SCOM 2007 Support Team blog: http://blogs.technet.com/operationsmgr/
The SCVMM Team blog: http://blogs.technet.com/scvmm/
The MED-V Team blog: http://blogs.technet.com/medv/
The DPM Team blog: http://blogs.technet.com/dpm/
The OOB Support Team blog: http://blogs.technet.com/oob/
The Opalis Team blog: http://blogs.technet.com/opalis
The Service Manager Team blog: http: http://blogs.technet.com/b/servicemanager
The AVIcode Team blog: http: http://blogs.technet.com/b/avicode
The System Center Essentials Team blog: http: http://blogs.technet.com/b/systemcenteressentials
The Server App-V Team blog: http: http://blogs.technet.com/b/serverappv

clip_image001 clip_image002