Service cannot be started. Microsoft.VirtualManager.DB.CarmineSqlException: Unable to connect to the VMM database. Ensure that the SQL Server is running and configured correctly

Advertisement
Hi All,
I am setting up SCVMM 2012 R2 in a production environment. Whenever I restart the SCVMM virtual machine the VMM service doesn't start automatically, I have to manually start it. I checked the VMM logs and in the event viewer i find the below error,
Service cannot be started. Microsoft.VirtualManager.DB.CarmineSqlException: Unable to connect to the VMM database. Ensure that the SQL Server is running and configured correctly. ---> System.Data.SqlClient.SqlException: Cannot open database "VirtualManagerDB"
requested by the login. The login failed. Login failed for user 'NXTRA\VMMSVC'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&
dataReady) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.Sq...
I added the 'VMMSVC' account as db_owner and sysadmin and also NT_Authority\System with same permissions still the service doesn't start on the start up.
I googled a lot and I find the threads with the error containing "General failure" but not with the above. Can someone please help me to find out why this error is occuring.
Thanks,
Ravi
Advertisement

Replay

It's often only a problem of the service dependencies. SCVMM starts to fast, SQL server on the same machine in not initialized yet. Here are working service dependencies to ensure SQL server is initializes before SCVMM starts.
You can set the service dependencies directly in regedit (as always: be careful modifying the registry ...)
Here is the content of a reg file setting the dependency.
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SCVMMService]
"DependOnService"=hex(7):53,00,51,00,4c,00,53,00,45,00,52,00,56,00,45,00,52,00,\
  41,00,47,00,45,00,4e,00,54,00,00,00,53,00,51,00,4c,00,42,00,72,00,6f,00,77,\
  00,73,00,65,00,72,00,00,00,53,00,51,00,4c,00,57,00,72,00,69,00,74,00,65,00,\
  72,00,00,00,4d,00,53,00,53,00,51,00,4c,00,46,00,44,00,4c,00,61,00,75,00,6e,\
  00,63,00,68,00,65,00,72,00,00,00,00,00

SCCM 2012 R2 SQL Database Upgrade Fails : Setup cannot upgrade the ConfigMgr database. Contact your SQL administrator.

Hi Friends, We have planned to upgrade our SCCM 2012 SP1 infrastructure to SCCM 2012 R2 so we have setup test environment to test SQL database upgrade before doing same in production. But while testing SQL database upgrade on test machine, it is gett

HT1386 iTunes is not recognizing my phone, it says the Apple moblie device service cannot be started

Whan I plug my iPhone into my laptop, ITunes will not start synching. I get a message that says "this iPhone cannot be used because the Apple Mobile Device service is not started". No idea why or when this decided to start, worked fine last nigh

A connection cannot be made; Ensure that the server is running

Hi There I have installed Analysis service on my server machine through remote login from my service account. I am able to open Analysis services from there. When I open SSMS from the same service account on my local machine, I am not able to connect

I cannot get my iPhone 5S to make a Bluetooth connection with my iMac. I get the Message that the iMac is not supported. Huh?

I cannot seem to get my iPhone 5S to make a bluetooth connection with my iMac (OSX 10.9.1). Phone claims that the iMac is not supported. Any suggestions?The only connection supported to your iMac is Personal Hotspot to use the iPhone's cell connectio

TS3212 over 100 of my songs stored in my library have an exclamation point next to them.  When I click on the song it says that the song will  not be downloaded to my phone because the original song cannot be found, and would I like to locate it? I need h

Over 100 of my songs in my itunes library have an exclamation point next to them.  When I attempt to sync them with my phone it says that the song cannot be synced because it cannot locate the original song? Do I want to locate it? Can anyone help me

Oracle 11g XE: Some services cannot be started

Hello, I installed Oracle 11g XE on Windows 7 Home Premium. In Windows Task Manager --> Services,  There are the following services:     OracleJobSchedulerXE  (Stopped)     OracleMTSRecoveryService (Stopped)     OracleSeviceXE  (Running)     OracleXE

This ipod cannot be used because the apple mobile device service is not started. what do i do? i connect my itouch and i keep getting this message, it connects to my pc but not on itunes, please help.

pretty much what the description says, please helpType "apple mobile device service" into the search bar at the top of this page by "Support" and read the resulting help articles.Read other 2 answers

File created with Trial version cannot be opened by Captivate 5.5 (Ensure that the file isn't open, the file isn't damaged....etc.)

Hi, I have a file created by Trial version of captivate. It was created in a different computer. Now, I have to make some modification in the file. However, when I tried to open it with Captivate 5.5, I got the error shown below. I am not able to use

I have a new ipad 3 and cannot activate facetime or imessage - it says "unable to connect to server"

Is there a waiting time before being able to activate Facetime or iMessage on an ipad3? I purchased my ipad today and cannot use Facetime or iMessage yet.Good Evening Meg, I´m form Mexico City and I am experiencing issues to enabe iMessage too. Do yo

I cant use itunes because its say my ipad cannot be used because the mobile service is not started what do i do?

can someone please help me i got an ipad 4th gen for xmas and i cannot use itunes as it says "this ipad cannot be used bacuse the mobile service is not started" what can i do to solve this problem?Check item 4 near the bottom of this article: ht

Microsoft AD Health Insights Service does not start Event 118

Log Name:      Application Source:        IdentityDiagnosticsResourceMonitor Date:          2/23/2015 6:15:23 PM Event ID:      510 Task Category: None Level:         Error Keywords:      Classic User:          N/A Computer:      adfs1045.kalangotx.c

Sql server will not start - Database 'model' cannot be opened. It is in the middle of a restore.

Sql server service will not start after server reboot: 2009-08-13 14:15:43.94 spid7s      SQL Trace ID 1 was started by login "sa". 2009-08-13 14:15:43.97 spid7s      Starting up database 'mssqlsystemresource'. 2009-08-13 14:15:43.97 spid7s     

Nokia 6120 Classic cannot be started due to interr...

Hi I used skype with my Nokia phone. The situation became not to receive texts that the phone memory was full because skype received files were saved in file manager (or something like that). Tried pressing keys of 3, call and *, tried to reset the p

EPMA Server service cann't started

Hi, EPMA Server service cannot started on Win Server 2008 64bit. I configued EPM 11.1.2.2 via SQL Server 2008 R2. I copied logs on windows event logs. Have anybody any suggesstion? Hyperion EPM Dimension Server Service Log Service cannot be started.

DBConsole service can't start

when I start DBConsole , its giving the following error (Window based services). ?Windows could not start the OracleDBConsolertlg on local computer. For more information, please review the system event log. If this is a non-Microsoft service, contact

Service 'iPod Service' failed to start and Error 1503

Thanks to all the people who have provided answers posts... they have helped me get to this point!... I have a slight variation on this issue - an Error 1503... My original symptom was that I couldn't get iTunes to recognise my iPod so I tried to ins

Microsoft SQL Server Express LocalDB / Windows Azure Powershell install fail - SQL writer failed to start

I'm trying to install Windows Azure PowerShell on my Windows 7 SP1 Enterprise laptop. As a prerequisite, it needs to install Microsoft SQL Server 2012 Express LocalDB, I but keep receiving an error: Service 'SQL Server VSS Writer' (SQLWriter) failed

Why SQL services is dont start in configuration manager studio 2012

I finished installing SQL server Management Studio 2012 and that of configuration management studio. When I wanted to log in did not find server name, and I tried <pc name>\SQLEXpress, still did not work. So checked configuration management studio a

[Forum FAQ] Reporting Service Point cannot be installed on a Site System Server running SQL Server 2012 SP1

Symptom: When you install Reporting Service Point role on a Site System Server running SQL Server 2012 SP1, you may encounter an issue that the Reporting Service Point role cannot be installed. The error log "srsrpMSI.log" and "srsrpsetup.l