Database Reference
In-Depth Information
Figure 9-14.
Locating the service account information
Double-clicking an entry brings up a Properties dialog window (Figure
9-14
). The LogOn tab within this
window allows you configure which account to use when starting the service.
If this service account is used for the impersonation information, it must have access to the data warehouse
and the SSAS objects. If this account has permissions, then using it for impersonation works. If not, you need to
give permissions to the account, select a different account, or use a different option.
Using the service account is not your best option because the permissions given to the account may be
above and beyond what is actually needed. It is best to use this option for times where only simple security
delineations are needed, such as on a development server.
Current User Account Option
The “Use the credentials of the current user” option (Figure
9-13
) allows the connection to access the SQL Server
and SSAS with the SID of the person using Visual Studio. Later, when a cube deploys from Visual Studio to the
actual SSAS server, whatever account used to automate cube processing will become the current user. This is
confusing and prone to configuration errors.
