I'm working with Analysis Services and I have run into a compatibility issue. Here is my situation. I have 3 machines:
- Server2005: This machine has SQL Server, Analysis Services and Visual Studio, all in 2005 versions.
- Client2008: This machine has Visual Studio 2008.
- Client2005: This machine has Visual Studio 2005
What I'd like to do:
- Develop cubes working on Client2008 and deploying on Server2005.
The problem:
- I can read data and deploy cubes. However, when I try to "process" a cube I get an error message: Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'xxxxx', Name of 'xxxxx'. Impersonation information is set to "Use service account". I don't know why I can use the connection to read data, I can deploy the cube (a new AnalysisServices db is created in Server2005) but I can't process data.
Tests that have worked:
- I can deploy and process cubes locally on Client2008 with SQL Server 2008.
- I can deploy and process cubes locally on Server2005.
- I can deploy and process cubes on Server2005 from Client2005.
- Here comes the strangest of all: I develop a cube using Client2005. I copy the visual project to Client2008 and update the project to use it with VS2008 and… it works! However if I develop exactly the same cube with VS2008 from the beginning I get the previous error. I have compared the .ds files generated with VS2005 and VS2008 and have not found any significant differences.
I'm clueless. Any help is appreciated, thank you!
Best Answer
The impersonation settings have changed slightly. The best solution is to ensure that your SQL Server database gives the Analysis Services service account read permissions.
You may also need to change the data source connection impersonation information: