I was installing Microsoft Dynamics CRM 2011 RTM version and was using SQL 2012 as the database server. The issue was when I was installing the SRS Data Connector, it use to give me error as " The SQL server reporting service server not found"
Though the reporting was installed correctly and I was able to browse in browser.
After doing lot of troubleshooting and research I found that SQL 2012 reporting will NOT work with the Microsoft Dynamics CRM 2011. SO you need to download the latest CRM 2011 setup files and do the following to install the SR Data connector.
- You have to run the package and this asks you where to extract the files, and you just choose the location and extract it.
- Then cancel the installation, go to the folder, locate the SRS data connector folder and run from there the installation of SRS data connector