Access to Analysis Cubes is denied????
Posted on 2004-11-02
it is a very strange Problem. I dont know how to figure out the problem.
We made a website with different Reports (XP - Webcomponents, Pivottable).
Recordsource from the Pivottable
Provider=MSOLAP.2;Integrated Security=SSPI;Persist Security Info=False;Data Source=MCWWTKDKSQL;Initial Catalog=GB_Plus;Client Cache Size=25;Auto Synch Period=10000
Setting from the Analysis Server
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Program Files\Microsoft Analysis Services\Bin\msmdrep.mdb
We are working in a firm-network. So everyone can ping the server, also the collegues in GreatBritain. But they get no access to the analysis server.
They got all rights to have access, but the collegues in GB get the message
"The Pivottable list "Bonus" could not connect to the data Source "Bonus". For information...."
"0x80004005: Cannot connect to the server mcwwtkdksql. The server is either not started or to busy"
The analysis server is started and the the server isn't ot busy.
They have also access to the SQL-Server, that works fine.
It is a nightmare. Do you know what to do? Thanks in advance