SSRS Tutorial: Part 2 - Shared Data Sources

Introduction

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

This article explains the following

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

Shared data sources in SQL Server

  • The shared source can be used by multiple reports that run on a reporting services report server.
  • If any change occurs in the server name, database name, login 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 the data source name, and click Edit to make the connectionString.

shared data sources

After clicking Edit, we must provide the following Connection Properties in the next 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! A shared data source was created at this point. Go to Solution explorer, where you can see the shared data source.

shared data source

Conclusion

In this article, we learned about shared data source and how to create shared data sources in SQL Server.


Similar Articles