Use the Impersonation Information dialog box to provide information about the security credentials used by the Analysis Services object. You can display the Impersonation Information dialog box by:
-
Clicking the ellipsis (...) of the Data Source Impersonation Info property in the Database Properties dialog box of SQL Server Management Studio.
-
Clicking the ellipsis (...) of the Impersonation Info property in the Assembly Properties dialog box of SQL Server Management Studio.
Options
-
Use a specific user name and password
-
Select this option to have the Analysis Services object use the security credentials of a specified Windows user account. The specified credentials will be used for processing, ROLAP queries, out-of-line bindings, local cubes, mining models, remote partitions, linked objects, and synchronization from target to source. For DMX OPENQUERY statements however, this option is ignored and the credentials of the current user will be used rather than the specified user account.
-
User name
-
Type the domain and name of the user account to be used by the selected Analysis Services object. The domain and name of the user account uses the following format:
<Domain name>
\
<User account name>
.gif) Note: |
|---|
|
This option is enabled only if Use a specific name and password is selected.
|
-
Password
-
Type the domain and name of the user account to be used by the selected Analysis Services object.
-
Use the service account
-
Select this option to have the Analysis Services object use the security credentials associated with the Analysis Services service that manages the object. The service account credentials will be used for processing, ROLAP queries, remote partitions, linked objects, and synchronization from target to source. For DMX OPENQUERY statements, local cubes, and mining models, the credentials of the current user will be used. This option is not supported for out-of-line bindings.
-
Use the credentials of the current user
-
Select this option to have the Analysis Services object use the security credentials of the current user for out-of-line bindings, DMX OPENQUERY, local cubes, and mining models. This option is not supported for processing, ROLAP queries, remote partitions, linked objects, and synchronization from target to source.
-
Default
-
Select this option to use the credentials of the default user account for Analysis Services. This option uses the default setting for the database for processing objects, synchronizing servers, and executing the OpenQuery data mining statements. For more information about specifying the default settings at the database level, see Database Properties (Analysis Services - Multidimensional Data).
By default the DataSourceImpersonationInfo database property is set to Use the service account. Regardless of the DataSourceImpersonationInfo property value, the credentials of the current user will be used for out-of-line bindings, ROLAP queries, local cubes, and data mining models.
See Also