Articles in this section
Category / Section

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

1 min read

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


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.


Object explorer window

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.

Property window

Figure 2: Property window




Did you find this information helpful?
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment