Data Source connection in SSRS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2008 Development » Data Source connection in SSRS

Data Source connection in SSRS

Rate Topic

Display Mode

Topic Options

Author

Message

Shadab Shah

Posted Tuesday, February 05, 2013 10:50 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, May 19, 2013 9:07 PM
Points: 162, Visits: 336

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

Bahmudales

Posted Thursday, February 07, 2013 6:03 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:51 AM
Points: 2, Visits: 14

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 »

Permissions