Export (0) Print
Expand All
Expand Minimize

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.

  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.

  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:

    Shared data source icon
  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.

Community Additions

ADD
Show:
© 2014 Microsoft