Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data Source connection in SSRS Expand / Collapse
Author
Message
Posted Tuesday, February 5, 2013 10:50 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 5:08 AM
Points: 263, Visits: 651
Hi all,

I am a newbie to SSRS, I am trying hands on , on my first SSRS project. I am trying to Specify the DataSource connection of the another server which is not local to me. I search on internet, on how to specify another server in the connection string of Data Source but to no help.

Could any body please help me on how to write the connection string for the data source in order to connect to the server which is not local to me.
Post #1416246
Posted Thursday, February 7, 2013 6:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 5:06 AM
Points: 4, Visits: 38
Hi,

Did you tried this?

Data Source=SERVERADDRESS;Initial Catalog=DBNAME

Where you need to replace SERVERADDRESS with the address of the server and DBNAME with the database name.
Post #1417023
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse