CODEWITHSUNDEEP
sql-serverexcelssasolap
Val.B
Val.B

Reputation: 103

OLAP Cube Through Excel - Transport Layer Error

I have a cube running on SSAS SQL Server 2012.

Every time I want to connect to a cube, or update data in files that contain it, I (and all the other users) get the "Transport Layer Error" message.

I click "OK" and am prompted to re enter my credentials. Usually it works after that (though sometimes it doesn't).

This becomes very annoying when I need to refresh a file that contains a dozen of cubes: I need to enter the credentials 12 times.

Sometimes it becomes impossible to connect to the cube, I get stuck in a Transport Layer Error infinite loop.

Important note: The server is on a different domain than the PC, I am connected to it through a VPN.

Is there any way to get rid of this?

Upvotes: 0

Views: 3650

Answers (1)

SqlKindaGuy
SqlKindaGuy

Reputation: 3591

You should do it like this to avoid problems again

  1. Data tab... From Other Sources... From Analysis Services...

  2. Type in a server name, username, and password... click next choose your database and click next

  3. Check "Always attempt to use this file to refresh data". And check "Save password in file". Click Yes when the prompt pops up. Click finish. That will save your username and password (in clear text) into the odc file. (Be aware of this for security purposes.)

And if that doesnt help, try to create a whole new excel workbook and readd connections to the cube.

Upvotes: 1

Related Questions