HI
I am working on a report which will pull all sys admin login's in each server, so I used below data source properties and created parameter names servername
="data source=" & Parameters!Servername.Value & ";initial catalog= master"
above solution working fine in SQL Server Data tools but when I deploy in report server I am getting error on connection error's like below.
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'dSource_DbOwner'. (rsErrorOpeningConnection)
Format of the initialization string does not conform to specification starting at index 0.
Please let me know all your inputs
Thanks,
Ven