Alternative ways to get a data connection (Report Builder)
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.
Get a data connection from a shared data source
If the report server has available shared data sources that you have permission 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 browse to a report server and select one. Usually, you get the report server URL from the report server administrator.
Specify a data connection from a list of shared data sources
In the New Table or Matrix or the New Chart Wizard, on the Choose a dataset page, select Create a dataset, and then choose Next. The Choose a connection to a data source page opens.
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, select Test Connection. The message "Connection created successfully" appears. Select OK.
Select Next.
If necessary, enter your credentials. To save the credentials locally, select Save password with connection. If you don't select this option, you will be prompted for credentials every time that you run the report
Select OK.
Specify a data connection by browsing to a shared data source on a report server
In the New Table or Matrix or the New Chart Wizard, on the Choose a dataset page, select Create a dataset, and then choose Next. The Choose a connection to a data source page opens.
Select 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, select the URL for your server, and then choose Open.
The list of data sources or models appears.
Alternatively, in Name, type the URL to the report server. Select 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 sufficient permissions to connect to, select the data source, and then select Open.
You are back on the Choose a connection to a data source page.
To verify that you can connect to the data source, select Test Connection.
The message "Connection created successfully" appears. Select OK.
Select Next.
If you are prompted for a user name and password, enter your credentials. To save the credentials locally, select Save password with connection.
Select OK.