OK I’m at a loss here; I’m going bonkers.
I’ve created a report in CRM 2011 (which runs executes fine), afterwards exported the .rdl file, opened that .rdl file in Visual Studio 2008 with BI extensions.
When I try to get any data from VS I get an error: “Unable to connect to data source ‘CRM’.” with the details saying: “No organization was found for the user.”.
The server is running SQL 2008 R2 with accompanying SSRS.
Anyone any idea?