I had a very odd and unusual problem, actually I say that most problems that involve reporting services are almost always odd and not unusual.
I was working on CRM which had already been setup (not by be) and the users were having problems with reports.
The problem was none of the built in reports were working, you also couldn’t upload any reports.
When you tried to run a report I got a
Microsoft CRM Error Report saying
Cannot run OOB report, unless SRS Data connector is installed
it is possible to use CRM with out SRS data connector working, you won’t have any reports. The odd thing here was all the reports were in CRM, they just weren’t working.
I installed the SRS data connector but I was still getting the error message.
Initially I thought the problems were because the installation was done on a named instance.
The installation of the SRS connector seemed to work without any problems. So I tried running the repairs and configs on the CRM server, still no joy.
I finally disabled the organisation, edited the organisation and then pressed next. I got a message about the SQL server setup.
I ran the SQL Server configuration tool and found the FULL TEXT Search, SQL Server Replication and Client Tools connectivity had not been enabled.
I added the in and reinstalled the SRS Connector. I now got a different error message in reports
Error occurred while getting the data source contents
which finally took me to this blog page
One thing I also noticed is that when I went to the reports manager
there were no reports for any organisations, which explained why I couldn’t run any of the default reports but the question was how do I load them.
The blog post above says you can use the tool
PublishReports
which is a command line tool to load the default reports, you need to just pass it the name of your organisation
publishreports organisationName
after running this the reports were loaded into CRM and I could finally run reports.
it took me ages but I finally resolved all the problems
Hosk's Dynamic Blog 