Hi people,
I've run into a problem using OLAP service. I am making a MDX select querry to a database located on my company's server. I have an OLAP administrator permissions both on my desktop computer and on the server. And here is the problem, when my ASP.Net application tries to open the connection an Exception occurs:
"Cannot connect to server "my_server". The operation requested failed due to security problems (the user cannot be authenticated)". When I am debugging my application from my server there is no problem everything goes smooth and on the contrary when I try it from my desktop machine the exception occurs.
The connection string is:
sConnString = "Provider=msolap;Data Source= Temp;Initial
Catalog=temp";
I have tried though with "Provider=msolap.1" and "Provider=msolap.2"
and the results are all the same.
I am using windows 2000 and SQL Server 2000 Enterprice with sp3.
Any help will be highly appreciated. Thanks in advance.