Share via

Add and Verify a Data Connection or Data Source (Report Builder and SSRS)

  • Article

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.

Note

You can create and modify report definitions (.rdl) 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. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.

To create a reference to a shared data source

  1. On the toolbar in the Report Data pane, click New, and then click Data Source. The Data Source Properties dialog box opens.

  2. In the Name text box, type a name for the data source.

    Note

    This name is saved in the local report definition. This name is not the name of the shared data source on the report server.

  3. 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.

  4. Select the shared data source and then click Open.

  5. Click OK.

The data source appears in the Report Data pane.

To create an embedded data source

  1. On the toolbar in the Report Data pane, click New, and then click Data Source. The Data Source Properties dialog box opens.

  2. In the Name text box, type a name for the data source or accept the default.

  3. Verify that Use a connection embedded in my report is selected.

    1. From the Select connection type drop-down list, select a data source type; for example, Microsoft SQL Server or OLE DB.

    2. Specify a connection string by using one of the following alternatives:

    • Type the connection string directly in the Connection string text box. For a list of example connection strings, see Data Connections, Data Sources, and Connection Strings in Report Builder.

    • Click the expression (fx) button to create an expression that evaluates to a connection string. In the Expression dialog box, type the expression in the Expression pane. Click OK.

    • Click Build to open the Connection Properties dialog box for the data source type that you chose in step 2.

      Fill in the fields in the Connection Properties dialog box as appropriate for the data source type. Connection properties include the type of data source, the name of the data source, and the credentials to use. After you specify values in this dialog box, click Test Connection to verify that the data source is available and that the credentials you specified are correct.

  4. Click Credentials.

    Specify the credentials to use for this data source. The owner of the data source chooses the type of credentials that are supported. In some cases, the owner of the data source maintains a shared data source on a report server and configures the data source with credentials that you can use. Contact the data source owner for this information. For more information, see Specify Credentials in Report Builder.

  5. Click OK.

The data source appears in the Report Data pane.

To verify a data connection

  1. On the toolbar in the Report Data pane, double-click the data source. The Data Source Properties dialog box opens.

  2. Click Test Connection.

  3. If the connection is successful, the following message appears: "Connection created successfully". Click OK.

  4. If the connection is not successful, the following message appears: "Unable to connect to the data source."

  5. Click Details, and use the information to correct the issue.

    For more information, see Specify Credentials in Report Builder.

  6. Click OK.

See Also

Concepts

Add Data to a Report (Report Builder and 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