Settings for Microsoft SQL Server Analysis Services Connection
Use this dialog to connect to Microsoft SQL Server Analysis Services.
Option
Description
Server
The name of the server where your data is located. To include a port number, add it directly after the name preceded by colon. To include an instance name, add it directly after the server name preceded by backslash.
Example with port number: myDatabaseServer:1234
Example with instance name: MyDatabaseServer\InstanceName
Connect
Connects you to the specified server and populates the lists of available databases and cubes. Microsoft SQL Server Analysis Services only supports Windows authentication.
Database
Select the database of interest from the drop-down list.
Cube
Select the cube of interest from the drop-down list.