DataSourceDefinition.CredentialRetrieval Property

  • Article

Indicates the way in which the report server retrieves data source credentials.

Namespace: Microsoft.WSSUX.ReportingServicesWebService.RSManagementService2005
Assembly: ReportService2005 (in reportingservice2005.dll)

Syntax

'Declaration
Public Property CredentialRetrieval As CredentialRetrievalEnum

public CredentialRetrievalEnum CredentialRetrieval { get; set; }

public:
property CredentialRetrievalEnum CredentialRetrieval {
    CredentialRetrievalEnum get ();
    void set (CredentialRetrievalEnum value);
}

/** @property */
public CredentialRetrievalEnum get_CredentialRetrieval ()

/** @property */
public void set_CredentialRetrieval (CredentialRetrievalEnum value)

public function get CredentialRetrieval () : CredentialRetrievalEnum

public function set CredentialRetrieval (value : CredentialRetrievalEnum)

Property Value

A CredentialRetrievalEnum value which indicates the way in which the report server retrieves data source credentials.

Remarks

You can use the CredentialRetrieval property to specify where to retrieve the credentials that are to be used by the report server when connecting to an external data source.

There are four possible settings for this property:

  • None – The connection to the data source does not require connections. This is the least secure method of connecting to an external data source and is not recommended. Note   The UnattendedExecutionAccount must be specified in the RSReportServer Configuration File file.

  • Prompt - The report server requires that credentials be supplied. If credentials are not supplied, the report is not generated and an exception is raised.

  • Integrated- The report server utilizes the credentials of the user authenticated to the report server. Any other data source credentials supplied are ignored. Note   If the EnableIntegratedSecurity system property is set to false, setting CredentialRetrieval property to Integrated will cause an exception to be thrown when the server attempts to retrieve data source credentials.

  • Store – The credentials are stored securely in the report server database.

There are a number of features of the report server that require the credential retrieval option to be either Store or None in order to successfully execute. These include schedule based features such Report Execution Snapshot generation, Report History generation, and subscriptions.

When credentials and the connection string are stored in the report server database, they are encrypted.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

DataSourceDefinition Class
DataSourceDefinition Members
Microsoft.WSSUX.ReportingServicesWebService.RSManagementService2005 Namespace

Other Resources

Report Server System Properties
Reporting Services Configuration Files