Add and Verify a Data Connection (Report Builder and SSRS)
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
You can create and modify paginated report definition (.rdl) files in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items.
To create a connection to a shared data source 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.
To verify a data connection
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.