ImpersonationMode Enumeration
SQL Server 2008 R2
Defines the access mode to the data source that the service uses when it processes its objects, synchronizes the server, and for the Data Mining statement OPENQUERY (DMX).
Assembly: Microsoft.AnalysisServices (in Microsoft.AnalysisServices.dll)
| Member name | Description | |
|---|---|---|
| Default | Uses the inherited value from the ImpersonationMode on the DataSourceImpersonationInfo object in the database. NoteThe default ImpersonationMode is ImpersonateCurrentUser for DM OPENQUERY (DMX) and out of line data sources, and the default for processing and server synchronizing is ImpersonateServiceAccount. | |
| ImpersonateServiceAccount | The credentials of the service account are used. NoteOnly Server Administrators can designate a data source impersonation mode as ImpersonateServiceAccount | |
| ImpersonateAnonymous | Currently not supported. | |
| ImpersonateCurrentUser | The current user is impersonated. NoteThis is valid for OPENQUERY (DMX) statements only | |
| ImpersonateAccount | This option is used when the service uses the account and (optionally) a password associated with the data source. NoteThe absence of a password indicates that the service account will request a Kerberos ticket for the data source service and the domain will check to see if service account can delegate credentials to the data source. |

Note