Home > SSRS > Managing Shared Data source – SSRS

Managing Shared Data source – SSRS

A shared data source specifies connection properties for a data source.

A shared data source can be used share the connection string with large number of reports, models, or data-driven subscriptions

This is a best practice consider creating a shared data source to eliminate the overhead of having to maintain the same connection information in multiple places and with multiple name.

Creating a shared Data source in BIDS

Step 1: Create a new report project and give project name and store location.


Step 2: create a new shared data source. On solution explorer, right-click on the share data sources node and create a new data source.


Step 3: Enter Data Source name, choose data source type and connection string (you can build connection string by clicking edit button on right side of connection string text box) in this dialogue box. Click Edit button.


Step 4: Create connection string in this dialogue box. Enter server name, server authentication information and database name.


Step 5: choose the credential for data source in the credentials tab of Shared Data source properties.


Deploying shared Data source into Report Server

Step 6: Go to Report project property page. Right click on Report project solution in solution explorer and click on property menu item.


Step 7: Enter report deployment property details for TargetServerURL, TargetDataSourceFolder, OverwriteDataSources.

Note 1: TargetServerURL should have proper server name instead localhost.

For instance: Http:///reportserver

Note 2: we have to remove property values for TargerDataSetFolder, TargetReportFolder, TargetReportPartFolder.


Step 8: To deploy a data source. Right click on the data source name and select deploy menu item.


Shared Data helps to keep data source deployment process separate from report. So, We can manage database connection more securely and easy manageable.

Categories: SSRS Tags: ,
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: