Locate user accounts and instances of SQL Server

SQLLover21 201 Reputation points
2020-11-30T16:17:40.247+00:00

I need to identify the SQL Server database and instance names used by the data warehouse management server. These are the following steps I have already taken:

-Log on to the data warehouse management server as a user with administrative credentials.
-On the Windows desktop, click Start, and then click Run.
-In the Run dialog box, in the Open box, type regedit, and then click OK.
-In the Registry Editor window, expand HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft**System Center\<version>\Common\Database**, to make a note of the information needed.

I am unable to locate from the highlighted (System Center\<version>\Common\Database). I am an admin on my desktop. My computer does not contain the System Center Please see screenshot attached.

Is there any other way to locate the below information?:
-DatabaseName

-DatabaseServerName

-DataMartDatabaseName

-DataMartSQLInstance

-RepositoryDatabaseName

-RepositorySQLInstance

-StagingDatabaseName

-StagingSQLInstance

-OMDataMartDatabaseName

-OMDataMartSQLInstance

-CMDataMartDatabaseName

-CMDataMartSQLInstance

43821-image.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,052 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,255 questions
{count} votes

Accepted answer
  1. Lukas Yu -MSFT 5,816 Reputation points
    2020-12-01T02:28:40.85+00:00

    Hi,

    It seems these properties are particularly organized System Center. As described in Moving Data Warehouse Databases
    They were called as System Center Service Manager Database Info. If you don't have system center, I'm not sure these info would be organized together somewhere.

    You may need to find them in SQL Server one by one.

    regards,
    Lukas


0 additional answers

Sort by: Most helpful