How to: Specify Stored Credentials for a Data Source (Report Manager)

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 Report Manager, navigate to the Contents page. Navigate to the report for which you want to configure a report-specific data source, and click the report item.

2. Click the Properties tab. The General properties page opens.

3. Click the Data Sources tab.

4. Select A custom data source.

5. In the Connection Type list, specify the data processing extension that is used to process data from the data source.

6. 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 AdventureWorks database:

   data source=<servername>;initial catalog=AdventureWorks
   

7. For Connect Using, select from Credentials stored securely in the report server. Type a user name and password. Do not select Use as Windows credentials when connecting to the data source.

8. Click Apply.

To specify stored credentials for a shared data source

1. In Report Manager, navigate to the Contents page. Navigate to the shared data source item. The following icon indicates a shared data source item:

   

2. Click the item to open it. The General properties page opens.

3. In the Connection Type list, specify the data processing extension that is used to process data from the data source.

4. For Connection String, specify the connection string that the report server uses to connect to the data source. Microsoft recommends that you do not specify credentials in the connection string.

   The following example illustrates a connection string used to connect to the local SQL Server AdventureWorks database:

   data source=<localservername>; initial catalog=AdventureWorks
   

5. For Connect using select from Credentials stored securely in the report server. Type a user name and password. Do not select Use as Windows credentials when connecting to the data source.

6. Click Apply.

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

Other Resources

Data Sources Properties Page (Report Manager)
New Data Source Page (Report Manager)

Help and Information

Getting SQL Server 2005 Assistance