.png)
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.
-
In Object Explorer, navigate to a report node. Expand the report item.
-
Expand the Data Sources folder.
-
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." -
Click A custom data source.
-
Click Credentials stored securely on the report server.
-
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.
-
Click OK.
-
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. -
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.
-
Click Connection in the Select a page area.
-
For Connect using, click Credentials stored securely on the report server.
-
Type a user name and password in the User name and Password text boxes.
-
Click OK.
