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.
Then you will see the following wizard. Provide data source name, and click on Edit to make the connectionString.
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.
Click on the "Test Connection" button to ensure the connection can be established.
Click Ok. Then you will see the connection as follows.
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.