I have installed CRM 2011 on an app server. We are using SQL 2012 in a clustered environment and a separate server for Reporting services. I am trying to install the SRS Data Connector on the reporting server but have had no success.
On the first UI screen it asks for the SQL server name, which I enter with the \instance name included. The next screen only allows the option MSSQLSERVER which is okay because that is the instance used by SSRS on the reporting server.
However when it does the environment checks it fails with "Unable to validate SQL Server Reporting Services Report Server installation. Please check that it is correctly installed on the local machine."
Reporting Services is installed and working properly with other applications.