Alternative Ways of Getting a Data Connection (Report Builder 3.0)
A data connection contains the information to connect to an external data source such as a SQL Server database. Usually, you get the connection information and the type of credentials to use from the data source owner.
To specify a data connection, you can use a shared data source from the report server or create an embedded data source that is used only in a specific report.
In most tutorials you use embedded data sources, but if you have access to shared data sources, then you can use them instead.
Getting a Data Connection From a Shared Data Source
If the report server has available shared data source that you have permissions to use, you can use them instead of an embedded data source. The following procedures tell how to locate the shared data sources and provide any credentials needed to use them.
To use a shared data source, you must browse to a report server and select one. Usually, you get the report server URL from the report server administrator.
To specify a data connection from a list of shared data sources
From the Insert ribbon, choose Table or Matrix, and then Table Wizard or Matrix Wizard.
On the Choose a dataset page, select the Create a dataset radio button at the bottom of the page, and click Next. The Choose a connection to a data source page opens.
Note
You may need to verify that you have access to a database by checking through SQL Server Management Studio. Be sure that the server name is filled in and click Connect.
From the list of data sources, select a data source that you have permission to access.
To verify that you can connect to the data source, click Test Connection. The message "Connection created successfully" appears. Click OK.
Click Next.
If necessary, enter your credentials. To save the credentials locally, select Save password with connection. If you do not select this option, you will be prompted for credentials every time that you run the report
Click OK.
To specify a data connection by browsing to a shared data source on a report server
From the Insert ribbon, choose Table and then Table Wizard or Matrix and then Matrix Wizard.
On the Choose a dataset page, select Create a dataset, and click Next. The Choose a connection to a data source page opens.
Click Browse. The Select Data Source dialog box opens.
From the Look in drop-down list, select Recent Sites and Servers. In the data source pane, click the URL for your server, and then click Open.
The list of data sources or models appears.
Alternatively, in Name, type the URL to the report server. Click Open.
Report Builder connects to the report server and loads the data sources that are available at the root folder.
Navigate to a folder that contains a data source that you have permissions to connect to, select the data source, and then click Open.
You are back on the Choose a connection to a data source page.
To verify that you can connect to the data source, click Test Connection.
The message "Connection created successfully" appears. Click OK.
Click Next.
If you are prompted for a user name and password, enter your credentials. To save the credentials locally, select Save password with connection.
Click OK.
See Also