I am working on a ssrs report where I am using a custom data source i.e. I 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.
I am able to connect to SQL Server 2012 and above. But below 2012 versions are not connecting.
I tried integrated security as true and false and yet it didn't connect.
Asked
Active
Viewed 61 times
0
pfx
- 20,323
- 43
- 37
- 57
Malik Kattubadi
- 11
- 1
-
which version of report builder or vs you are using? – Programmermid Sep 05 '18 at 19:46
-
2014 report builder – Malik Kattubadi Sep 05 '18 at 20:41
-
Have you tried to remotely connect to the server using other tools (like SSMS)? – Wolfgang Kais Sep 05 '18 at 23:33
-
For example, you have a report created using ssrs 2014 that is attempting to connect to a 2008 ssrs database? – Ross Bush Sep 06 '18 at 03:13
-
Yes. I am trying to connect 2008 servers from ssrs 2014 report server and I am using dynamic ssrs Express to connect to database – Malik Kattubadi Sep 06 '18 at 22:06