Cannot create connection to datasource
Hello,
I have a problem with my reports. I have a shared datasource with the connection string that acces a Analysis Server with some cubes.
Fisrt scenario:
I deploy my reports to my local report server and I set the connection string to acces my local Analysis Server.
Result:
I can acces and use the reports from my computer and any other computer in the network.
Second scenario:
I deploy my reports to my local report server and I set the connection string to access a server on the network with Analysis Server.
Result:
I can access and use the reports from my computer. But when I use any other computer on the network I can't use the reports. I can access them but they don't find the database ant therefor they don't present any data.
Error message as folows: "An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'dsAnalys'. (rsErrorOpeningConnection) Get Online Help
Database 'Analys' does not exist. "
My connection string is as follows: "Provider=MSOLAP.2;Client Cache Size=25;Auto Synch Period=10000;Initial Catalog=Analys;Location=[servername]"
I also have the "Credentials stored securely in the report server" checked where I provide a user and password.
Why can't the reports use the connection string when I'm accessing them from an other computer but mine. Anyone that has experianced the same thing or that can help me anyway?
//Matte
|
