How to: Configure a Report-Specific Data Source (Management Studio)
To configure a report-specific data source
In Object Explorer, expand a report server node.
Expand the Home folder, and navigate to the folder containing the report you want to configure a data source for. Expand the report item.
Expand the Data Sources folder.
Right-click the data source item that you want to configure, and click Properties. The General page of the Report Data Source Properties dialog box is displayed.
If A shared data source is selected, you have opened a report that uses a shared data source for the data source connection. You cannot configure the connection string or credentials for the shared data source from this dialog box. Navigate to the shared data source in Object Explorer to configure the credentials. For more information about configuring credentials, see How to: Create, Delete, or Modify a Shared Data Source (Management Studio).
Select A custom data source. Several options are displayed.
Select the data source type from the list.
Type the connection string that the report server uses to connect to the data source. The following example illustrates a connection string used to connect to the SQL Server AdventureWorks database:
data source=<localservername>;initial catalog=AdventureWorks
For Connect using, specify how credentials are obtained when the report runs as follows:
- If you want to prompt the user for a logon name and password, click The credentials supplied by the user running the report.
- If you intend to use the data source with reports that support subscriptions or other scheduled operations (such as automated report history generation), click Credentials stored securely in the report server.
- If you want the report server to pass the credentials of the user accessing the report to the server hosting the external data source, click Windows Integrated Security. In this case, the user is not prompted to type a user name or password.
- If none of the above apply, click Credentials are not required. To use this setting, the report server must be configured to use an unattended processing account. For more information, see Configuring an Account for Unattended Report Processing.