Data Source connection in SSRS

• Shadab Shah

  SSCarpal Tunnel

  Points: 4759

  More actions

  February 5, 2013 at 10:50 pm

  #273899

  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.

• Bahmudales

  SSC Enthusiast

  Points: 129

  More actions

  February 7, 2013 at 6:03 am

  #1585389

  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.