How to get server and database names from the SQL Server Analysis Services?

This KB illustrates that how to get server and database names from SSAS.

Solution

The procedure to get the Server Name and Database Name from the SQL Server Analysis Services is as follows:

Step 1

Open the SQL Server Management Studio with the server type as the Analysis Services.

Step 2

In the Object Explorer window, right click the database to get the server and database names, and click Properties.

Figure 1: Object Explorer window

Step 3

In the property window, you can get the Database name from the Name field and Server name from the Server field. This is illustrated in the following screenshot.

Figure 2: Property window