SQL Analysis Service

  • I am having issue connecting to the SQL Analysis service. The below error message appears:

    Cannot Connect to the repository

    Analysis Server: [server name]

    Error:

    [Microsoft]ODBC Driver Manager] Data Source name not found and no default driver specified

  • You Could try the below steps to find out where the issue is.

    Rename a text file to .udl and then use the OLEDB for OLAP provider to connect to that DB.

    Also are u able to connect to the cube from SSMS ?

    In the SSAS properties check the value for DataDir and verify that the cube is present at this location.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply