Custom ssrs expression not working when trying to connect SQL server 2008 servers

Question

0.00/5 (No votes)

See more:

, +

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.

Posted 5-Sep-18 10:45am

malikkattubadi

Updated 6-Sep-18 2:00am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

#realJSOP · Answer 1 · 2018-09-06T02:01:00

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.
"