I have an end user who is requesting that SSRS 2012 be installed for testing. Since we don't yet support the "2012 database engine", the planned usage is SSRS 2012 will use SQL 2008 R2 db(s) as the data source. Is this supported? My testing so far appears to indicate it isn't and extensive web searches haven't provided any information that it is (or isn't). I've done the following for testing: I installed SSRS 2012 Reporting Services in "Files Only" mode via "Reporting Services - Native" on the Features page and "Install but do not configure the Report Server" on the Reporting Services Configuration page (which I recall was the only available/not grayed out option due to the earlier choice). When I open the SSRS 2012 Config Mgr on this server and enter the server name of a remote SQL 2008 R2 RS server and select "Find" a message box saying "No report servers were found" pops up. The 2008 R2 RS server is wide open to the SSRS 2012 server (firewalls off on all, same subnet, same domain, pingable, telnet to 1433 from the SSRS 2012 to SQL 2008 r2 RS is successful) If I open SSRS 2008 Config Mgr on a SQL 2008 R2 server and attempt to connect to the same target server the connection is successful. Thanks in advance

When I open the SSRS 2012 Config Mgr on this server and enter the server name of a remote SQL 2008 R2 RS server and select "Find" a message box saying "No report servers were found" pops up. Hello, You can use SSRS 2012 together with RDBMS 2008R2, as a datasource for the reports as well as to host the ReportServer databases. In SSRS Config Mgr you have to enter the server/instance name of SSRS 2012, not of the database server, of course. After you are connected, you have to config the report server database pointing to your SQL Server 2008R2.Olaf Helper Blog Xing

When I open the SSRS 2012 Config Mgr on this server and enter the server name of a remote SQL 2008 R2 RS server and select "Find" a message box saying "No report servers were found" pops up. Hello, You can use SSRS 2012 together with RDBMS 2008R2, as a datasource for the reports as well as to host the ReportServer databases. In SSRS Config Mgr you have to enter the server/instance name of SSRS 2012, not of the database server, of course. After you are connected, you have to config the report server database pointing to your SQL Server 2008R2.Olaf Helper Blog Xing

Hi dapdx, SQL Server 2012 Reproting Services can use SQL Server 2005, 2008, 2008 R2, or 2012 databases as the data source. Besides, SSRS 2012 report server catalog database can also be hosted in SQL Server 2005, 2008, 2008 R2, or 2012 instances. Since you have turned off the Firewall on the SQL Server 2008 R2 server, the issue should not be caused by the TCP port block. Taking your system security into account, I strongly recommend that you enable Windows Firewall on both servers. After that, you need to open the TCP port 1433 and port 80 for the remote connection on both servers. Moreover, before we can connect to and configure a remote report server instance, we must enable remote Windows Management Instrumentation (WMI) calls to pass through Windows Firewall. At this time, I suggest that you configure the servers referring to the following article: Configure a Report Server for Remote Administration After it is done, even if the Reporting Services Configuration Manager cannot connect to the remote report server instance, we should be able to operate the SQL Server 2008 R2 database engine through SQL Server Management Studio 2012, and use the SQL Server 2008 R2 databases as the datasource to design reports in SQL Server Data Tools (SSDT). Of course, we can also deploy the reports created in SSDT to the SSRS 2008 R2 report server. Hope this helps. Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Mike Yin TechNet Community Support