Add and Verify a Data Connection (Report Builder and SSRS)
Applies To: SQL Server 2016
In Report Builder, you can add a shared data source from the report server or create an embedded data source for your report. In Report Designer, you can create a shared data source or an embedded data source and deploy it to a report server.
To add a shared data source to your report, browse to a report server and select a shared data source. The shared data source in your report points to the shared data source definition on the report server.
To create an embedded data source, you must have connection information to the external source of data and you must know which permissions you need to access the data. This information usually comes from the owner of the data source. You can test the connection to verify that the credentials that are specified are sufficient.
For more information, see Data Connections, Data Sources, and Connection Strings in Report Builder and Specify Credentials in Report Builder.
On the toolbar in the Report Data pane, click New, and then click Data Source. The Data Source Properties dialog box opens.
In the Name text box, type a name for the data source.
This name is saved in the local report definition. This name is not the name of the shared data source on the report server.
Select Use a shared connection or report model. The list of recently used shared data sources and report models appears. To select one from a report server, click Browse and browse to the folder on the report server where shared data sources are available.
Select the shared data source and then click Open.
The data source appears in the Report Data pane.
On the toolbar in the Report Data pane, double-click the data source. The Data Source Properties dialog box opens.
Click Test Connection.
If the connection is successful, the following message appears: "Connection created successfully". Click OK.
If the connection is not successful, the following message appears: "Unable to connect to the data source."
Click Details, and use the information to correct the issue.
For more information, see Specify Credentials in Report Builder.
Report Datasets (SSRS)
Report Embedded Datasets and Shared Datasets (Report Builder and SSRS)
Finding, Viewing, and Managing Reports (Report Builder and SSRS )
Data Connections, Data Sources, and Connection Strings in Report Builder