Store Credentials in a Reporting Services Data Source
Updated: September 23, 2015
Applies To: SQL Server 2016 Preview
You can configure stored credentials that a Reporting Services report server uses to access external data for a report. Stored credentials are used if the report runs unattended, for example a Reporting Services subscription that publishes a report as an e-mail. The report server retrieves and uses the credentials when report processing is scheduled or triggered. This topic walks you through configuring stored credentials for both Native mode and SharePoint mode report servers.
Applies to: Reporting Services Native mode | Reporting Services SharePoint mode
It is required that the account you use for stored credentials, is configured for one of the following security policies on the report server. It is recommended you select the policy with the minimum level of permissions you require for your environment.
Configure stored credentials for a report-specific data source (Native mode)
In Native mode Report Manager, browse to the folder that contains the report. Click the item context menu .
Click Manage and then click Data Sources.
Select A custom data source.
In the Data Source Type list, select the data processing extension that is used to process data from the data source.
For Connection String, specify 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 AdventureWorks2012 database:
data source=<servername>;initial catalog=AdventureWorks2012
For Connect Using, select Credentials stored securely in the report server.
Type a user name and password.
If the account is a Windows domain user account, specify it in this format: <domain>\<account>, and then select Use as Windows credentials when connecting to the data source.
If the user name and password are database credentials, do not select Use as Windows credentials when connecting to the data source. If the database server supports impersonation or delegation, you can select Impersonate the authenticated user after a connection has been made to the data source.