Export (0) Print
Expand All
Expand Minimize

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

SQL Server 2005

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.

  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.

    ms156278.note(en-US,SQL.90).gifNote:
    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.

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

    ms156278.note(en-US,SQL.90).gifNote:
    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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft