Could not retrieve a valid database or server scenario for this install

A costumer of mine had an OpsMgr breakdown, due to misconfiguration of run as accounts. We got the first management server up and running again, but I couldn’t get the second to run. I then removed the Operations Manager installation completely and restarted. I logged back on, opened the setup as administrator to install the management role again, but I got the following error:

 

clip_image002

 

Could not retrieve a valid database or server scenario for this install – What?

 

Even though I was logged on as administrator, the most logical explanation would be insufficient privileges. So, I created an .udl file to test connectivity to the SQL server and the OpsMgr databases using different credentials – connectivity succeeded for both OperationsManager and DW. I tried to telnet port 1433, which also succeeded. Ok, so it wasn’t a security or connectivity issue.

 

I found http://technet.microsoft.com/en-us/library/hh416216.aspx and http://technet.microsoft.com/en-us/library/hh284673.aspx and decided to try with a command line installation to install the management server role:

 

The text marked with red must be changed according to your environment

 

setup.exe /install components:OMServer /ManagementGroupName:MyMG /SqlServerInstance:MySQLSrv

/SqlInstancePort:1433 /DatabaseName:OperationsManager /DWSqlServerInstance: MySQLSrv /DWSqlInstancePort:1433 /DWDatabaseName:OperationsManagerDW

/ActionAccountUser:HQ\scom_action_service /ActionAccountPassword:pa$$sw0rd

/DASAccountUser:HQ\scom_sdk_service /DASAccountPassword:pa$$sw0rd

/DataReaderUser:HQ\scom_dwread_service /DataReaderPassword:pa$$sw0rd

/DataWriterUser:HQ\scom_dwwrite_service /DataWriterPassword:pa$$sw0rd

/EnableErrorReporting:Never /SendCEIPReports:0 /UseMicrosoftUpdate:0

 

This opens the GUI, but same error:

clip_image002[1]

 

Tried with parameter /silent to see what happened on the fly:

 

setup.exe /silent /install components:OMServer /ManagementGroupName:MyMG /SqlServerInstance:MySQLSrv

/SqlInstancePort:1433 /DatabaseName:OperationsManager /DWSqlServerInstance: MySQLSrv /DWSqlInstancePort:1433 /DWDatabaseName:OperationsManagerDW

/ActionAccountUser:HQ\scom_action_service /ActionAccountPassword:pa$$sw0rd

/DASAccountUser:HQ\scom_sdk_service /DASAccountPassword:pa$$sw0rd

/DataReaderUser:HQ\scom_dwread_service /DataReaderPassword:pa$$sw0rd

/DataWriterUser:HQ\scom_dwwrite_service /DataWriterPassword:pa$$sw0rd

/EnableErrorReporting:Never /SendCEIPReports:0 /UseMicrosoftUpdate:0

clip_image004

· Found a database with the name OperationsManager in this instance

· Could not retrieve a valid database or server scenario for this install

· This is disaster recovery scenario but mandatory commandline switch to recover has not been passed. This is a fatal error

 

Yes, I know a database named OperationsManager exists, this is kind of needed to install the second management server. Failed to retrieve a valid database? Earlier I confirmed that it is not a connectivity/security issue. Disaster recovery? I’m doing any recovery, just trying to install a component!

 

Shooting in blind, I tried putting the /recover parameter on:

setup.exe /silent /install /recover components:OMServer /ManagementGroupName:MyMG /SqlServerInstance:MySQLSrv

/SqlInstancePort:1433 /DatabaseName:OperationsManager /DWSqlServerInstance: MySQLSrv /DWSqlInstancePort:1433 /DWDatabaseName:OperationsManagerDW

/ActionAccountUser:HQ\scom_action_service /ActionAccountPassword:pa$$sw0rd

/DASAccountUser:HQ\scom_sdk_service /DASAccountPassword:pa$$sw0rd

/DataReaderUser:HQ\scom_dwread_service /DataReaderPassword:pa$$sw0rd

/DataWriterUser:HQ\scom_dwwrite_service /DataWriterPassword:pa$$sw0rd

/EnableErrorReporting:Never /SendCEIPReports:0 /UseMicrosoftUpdate:0

Installation started and no sudden errors!

clip_image006

 

I started Task Manager, and I could see msiexec.exe and Operations Manager 2012 Setup started. Seconds later I could also see the HealthService in Task Manager. I went to Services and noted the three services had appeared, as well as the System Center 2012 folder in ProgramFiles. Good!

 

Minutes later, at last:

clip_image008

 

I went to my first management server and the new management server was already there, fully monitored.

Conclusion:

I can’t say why I couldn’t install the management server the normal way, as I’ve done this many times before, and I for sure can’t explain why the /recover parameter is needed – neither can Microsoft. So, if you ever run in to this issue, install the management server using the command line with the /silent and /recover parameter

By | 2012-10-23T12:07:02+00:00 October 23rd, 2012|Operations Manager (SCOM)|5 Comments

About the Author:

Michael Skov
Yet another guy loving the System Center products. My primary focus is on Operations Manager, which i have worked with for some years now - still loving it.Certifications:Microsoft Certified Solution Expert Private Cloud (MCSE)Microsoft Certified Solutions Associate Windows Server 2008 (MCSA)Microsoft Certified Technology Specialist Windows Server 2008 R2, Server Virtualization

5 Comments

  1. John Bradshaw November 5, 2012 at 22:58 - Reply

    Thought this would save me, but after re-trying the script and re-checking over and over I get Error “Invalid Commmand line…”
    (MS1 and MS2 deployed fine, but the 3rd and 4th are having the above problem. Using the same accounts as I did with MS1 and MS2).

    Any ideas?
    Thx,
    John Bradshaw

  2. Michael Skov November 6, 2012 at 10:24 - Reply

    Hi John

    Even though you have checked and re-checked, it seems the command line is incorrect. You can try to publish here, and i will look at it.

    Regards
    Michael

  3. Kelly Slavens August 15, 2013 at 17:17 - Reply

    Another solution to the problem is to go under Administration/Device Management/Management Servers/. You will see a listing there for the failed management server. Delete it and the install will complete successfully after.

  4. Jan Kristensen December 16, 2013 at 11:26 - Reply

    I have had the issue at a customer, and the error in the commandline if you just copy from the site is a missing / at the components

    After adding that, it installed just fine..

    Regards
    Jan

  5. J Pritchard April 10, 2016 at 2:31 - Reply

    Many thanks for posting about this error. It happened seemingly randomly to me. I had used the /silent switch to uninstall, and then tested re-installing and encountered this error.

    Thank you also Kelly, I haven’t tried your suggestion about the Device Management > Delete Failed Management Server, but it’s helpful to know

Leave A Comment