Hi,
You can trace the exact error which is getting throw.
For Error Description in Error Log:
Log on to SQL Server, go to installation folder of SQL Server Reporting Services. Open the latest log file and see the error description.
EG: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles
Regarding Deployment:
Do not use Shared Data Source, When you test it from SSRS, use the Report connectionstring.
And When you deply the report to MS CRM, MS CRM automatically assign the Data Source to the REPORTS [according to your Organisation].
There are plenty of approaches to deploying a report onto CRM.
1. Once the RDL file is created, use CRM Reports area (Workplace > Reports) and give the path to the RDL file.
2. You could also deploy the report on the Report Manager, retrieve it's web address and use CRM's reports area and provide the link to the report.
If you're trying to access the report from on of the client machines, make sure you have the Connector for SQL Server Reporting Services installed. Also the use of localhost in the connection string might be an issue causer. Try using the CRM server name.
Hope it helps!
Thanks, Ranjitsingh R | http://mscrm-developer.blogspot.com/ | MS CRM Consultant
