Click here to Skip to main content
15,665,166 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I am working on a ssrs report where I am using custom data source i.e. am using ssrs expression (="data source=" & Parameters!ServerName.Value & ";initial catalog=master;integrated security=sspi") to use multiple connections from selected parameter to connect to that particular server. Am able to connect 2012 and above sql servers. But below 2012 version are not connecting. I tried integrated security as true and false and yet it didnt connect.Iam deploying it on ssrs 2014 environment

What I have tried:

I tried integrated security as sspi,true and false and yet it didnt connect.
Updated 6-Sep-18 2:00am

1 solution

I found this with a google search:

"SQL Server 2012 Reporting 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 data source 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.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900