Contents
Create, Modify, and Delete Shared Data Sources (SSRS) 1 Creating and Modifying Shared Data Sources. To create a shared data source or modify its properties, you must have Manage data sources permissions on the report server. 2 Deleting Shared Data Sources. 3 Importing Shared Data Sources. 4 Shared Data Sources in SharePoint.
If you take the shared data source offline, all reports, models, and subscriptions will not run until you re-enable the data source. For more information about controlling access to shared data sources in the report server folder hierarchy, see Secure Shared Data Source Items.
When do you need to update shared data sources?
Shared data sources provide an easy way to manage data source properties that often change over time. If a user account or password changes, or if you move the database to a different server, you can update the connection information in one place.
How to modify shared data source in web portal?
To modify a shared data source in the web portal In the web portal, navigate to the shared data source. Select the ellipsis (…) in the upper-right corner of the shared data source > Manage. Modify the data source, and then click Apply.
To create a shared data source in Report Designer On the toolbar in the Report Data pane, click New and then click Data Source. In the Name text box, type a name for the data source or accept the default. Verify that Use shared data source reference is selected and then do the following. Click Credentials.
SSRS Shared Data Source. In SSRS, Data Source (DS) is a connection settings which is used to connect with underlying Databases or Data Warehouses. Data source is a combination of Provider name, Server instance Name, Database Name and Database credentials.