Bumped into a System Center 2012 – Orchestrator (SCOrch) environment where it was unknown what SQL server and database was being used. Nowhere this information was found in the registry. So where to look now?
As it turned out, the solution was a simple one (even though it still eludes me why this information isn’t stored in the registry, but apparently it’s stored in the SQL database as well….).
- Start the tool Deployment Manager (System Center 2012 R2 Orchestrator Deployment Manager);
- Right click on Orchestrator Management Server > select Properties;
- Go to the second tab Orchestrator Management Server. On this tab the Database Server and Data Store Name (SQL database) are shown:
I found the solution to this relative simple question in this posting of the blog Kick That Computer.