Tuesday, September 16, 2014

SCOrch: What SQL Server & Database Is Being Used?

Issue
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?

Solution
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….).

  1. Start the tool Deployment Manager (System Center 2012 R2 Orchestrator Deployment Manager);
  2. Right click on Orchestrator Management Server > select Properties;
    image
  3. Go to the second tab Orchestrator Management Server. On this tab the Database Server and Data Store Name (SQL database) are shown:
    image

Credits
I found the solution to this relative simple question in
this posting of the blog Kick That Computer.

No comments: