How to: Specify Stored Credentials for a Data Source (Management Studio)

You can use a single Windows user account to access external data for a report. The account must have Allow log on locally permission on the report server. For instruction on how to grant this permission, see Specifying Credential and Connection Information.

To specify stored credentials for a report-specific data source

  1. In Object Explorer, navigate to a report node. Expand the report item.

  2. Expand the Data Sources folder.

  3. Right-click the data source item that you want to specify credentials for, and click Properties. The General page of the Report Data Source Properties dialog box is displayed.

    Note

    If A shared data source is selected, you have opened a report-specific data source that is configured to use a shared data source. You cannot configure credentials for a shared data source in this dialog box. For more information, see "To specify stored credentials for a shared data source."

  4. Click A custom data source.

  5. Click Credentials stored securely on the report server.

  6. Type a user name and password in the User name and Password text boxes.

    You can set additional options to specify how the stored credentials are used.

  7. Click OK.

To specify stored credentials for a shared data source

  1. In Object Explorer, navigate to a report node. Navigate to a shared data source.

    Note

    Shared data sources are not contained within report items. Only report-specific data sources are contained within report items.

  2. Right-click the shared data source item that you want to specify credentials for, and click Properties. The Data Source Properties dialog box is displayed.

  3. Click Connection in the Select a page area.

  4. For Connect using, click Credentials stored securely on the report server.

  5. Type a user name and password in the User name and Password text boxes.

  6. Click OK.

See Also

Tasks

How to: Configure a Report-Specific Data Source (Management Studio)
How to: Create, Delete, or Modify a Shared Data Source (Management Studio)

Concepts

Report Server How-to Topics
Specifying Credential and Connection Information

Help and Information

Getting SQL Server 2005 Assistance