Microsoft vient de publier un nouvel article dans la base de connaissances concernant System Center Virtual Machine Manager (SCVMM) 2008 R2.
L’installation du produit échoue et renvoie l’erreur suivante :
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
Le fichier ServerSetup.txt (%ProgramData%\VMMLogs\) affiche les messages suivants :
[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
Ce problème survient si :
· Le compte qui exécute l’installation n’a pas les droits sysadmin sur SQL Server
· Un compte de service est spécifié pour l’instance SQL qui a les droits sysadmin
Pour en apprendre plus : KB2562909 - System Center Virtual Machine Manager 2008 R2 setup fails with Error 2605
