Sunday, March 11, 2012

Connection from other domain failes

Hi,
i like to use my Excel pivot from other domain, but I always get the error message "Cannot find repository". I tried a ping on IP of analysis server, no problem. The connection string includes the IP adress as well. Anybody knows the clue ?
Thx
dajmI have to re-post my question, hopefully anybody got same problem.

Here my problem again:

A client from other (trusted) domain can ping to my analysis server, but cannot use the excel pivot table using the cube of same analysis server. It is saying "Cannot find repository".
Pivottable is working fine from same domain as analysis server.

Any clue ?

dajm|||Where is repository of your Analysis Server located? In access file msmdrep in Binn directory of AS (default) or in SQL Server msdb database (after migration)? mojza|||Thx. for reply.

repository path is standard path of SQL server.

Anyway, I made this workaround:

I have chosen authentication over http protocol and it works fine now.
Any disadvantages I can expect from this solution ?

dajm

No comments:

Post a Comment