Como e representacao comercial em ingles
When creating a data source object in an Analysis Services model, one of the settings that you must configure is an impersonation option. This option determines whether Analysis Services assumes the identity of a specific Windows user account when performing local operations related to the connection, such as loading an OLE DB data provider or resolving user profile information in environments that support roaming profiles.
For connections that use Windows authentication, the impersonation option also determines the user identity under which queries execute on the external data source. This topic explains how to set impersonation options in the Impersonation Information dialog box when configuring a data source object. Choose an option described in Impersonation options como e representacao comercial em ingles this topic.
Data Source Properties dialog box, through the Impersonation Info property. Assembly Properties dialog box, through the Impersonation Info property. All options are available in the dialog box, but not all options are appropriate for every scenario. Use the following information to determine the best option for your scenario. Select this option to have the Como e representacao comercial em ingles Services Analysis Services object use the security credentials of a Windows user account specified in this format: Choose this option to use a dedicated, least-privilege Windows user identity that you have created specifically for data access purposes.
For example, if you routinely create a general purpose account for retrieving data used in reports, you can specify that account here. Como e representacao comercial em ingles multidimensional databases, 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.
Select this option to have the Analysis Services Analysis Services object use the security credentials associated with the Analysis Services Analysis Services service that manages the object.
This is the default option. In previous releases, this was the only option you could como e representacao comercial em ingles. You might prefer this option to monitor data access at the service level rather than individual user accounts.
If you choose the service account for a connection that uses Windows authentication, remember to create a database login for this account and grant read permissions, as it will be used to retrieve data during processing. For more information about the service account, see Configure Windows Service Accounts and Permissions.
When como e representacao comercial em ingles database authentication, you should choose the Use the service account impersonation option if the service is running under the dedicated virtual account for Analysis Services.
This account will have permissions to access local files. If the service runs as NetworkService, a better alternative is to use a least privilege Windows user account that has Allow log on locally permissions.
Depending on the account you provide, you might also need to grant file access permissions on the Analysis Services program folder. For multidimensional databases, the service account credentials will be used for processing, ROLAP queries, remote partitions, linked objects, and synchronization from target to source. The service account option is not supported for out-of-line bindings. Errors can occur when processing a data mining model from a cube if the service account does not have administrator permissions on the Analysis Services instance.
For more information, see Mining Structure: With the exception of local cubes and processing using out-of-line bindings, this option is not supported for multidimensional databases.
The dialog box uses Default for the impersonation options set at the database level and Inherit for impersonation options set at the data source level. At the data source level, Inherit specifies that Analysis Services Analysis Services should use the impersonation option of the parent object. In a multidimensional model, the parent object is the Analysis Services Analysis Services database.
Choosing the Inherit option lets you centrally manage the impersonation settings for this and other data sources that are part of the same database. For this option to be como e representacao comercial em ingles, choose a specific Windows user name and password at the database level. Otherwise, the combination of Inherit on the data source and Default on the database are equivalent to using service account option.
To specify a Windows user name and password at the database level, do the following: Right-click each data source and view its properties to ensure that each one is using the Inherit option.
For more information about default settings at the database level, see Set Multidimensional Database Properties Analysis Services. For multidimensional databases, Default means use the service account, and current user for data mining operations.