SSRS Tutorial: Part 2 - Shared Data Sources

Before reading this article, I highly recommend reading the previous part of the series:

This article explains the following:

  • What is shared data source?
  • How to create shared data sources?

Shared data sources

  • Shared source can be used by multiple reports that run on a reporting services report server.
  • If any change occurs in server name, database name, logon credentials,.. etc, you can update the connection information in one place.
  • Shared data sources provide an easy way to manage data source properties that often change over time.
  • Shared data sources are optional for reports and subscriptions.

Create Shared Data Source

Go to Solution Explorer and right click on Shared Data Sources, and click on Add New Data Source.

add new item

Then you will see the following wizard. Provide data source name, and click on Edit to make the connectionString.

shared data sources

After clicking on Edit, we have to provide the following Connection Properties in the following wizard.

  • Provide the Server name.
  • Select the "Use SQL Server Authentication" radio button.
  • Enter the User name and Password in the password text box.
  • Check the "Save my password" checkbox.
  • Select the "Select or enter a database name:" radio button.
  • Select the database to which you want to set the connection.

    connection properties

Click on the "Test Connection" button to ensure the connection can be established.

test results

Click Ok. Then you will see the connection as follows.

connection

Click Ok. That’s it! Shared data source created at this point. Go to Solution explorer and there you can see the shared data source.

shared data source