Database Reference
In-Depth Information
In general, current user account option is not a recommended choice. This option is useful only as a
temporary option while you are developing cubes in Visual Studio.
Inherit Option
One option that looks attractively simple is the Inherit option (Figure
9-13
). One might consider this to be the
“automatically choose for me” option since that is what it does. It automatically selects the service account for
some operations and the current user's credentials for others. This option may work in Visual Studio, but this
typically will not work once the cube deploys to the SSAS server. Therefore, the Inherit option should not be used
except within Visual Studio during development.
Specific Windows Account Option
The first option, “Use a specific Windows user name and password,” is the best choice (Figure
9-13
). This option
allows you to use a specific Windows account by entering the name and password in the provided textboxes.
The account should have the computer name or the domain name prefaced before the individual account
name. Some examples are My_Domain\My_Windows_Account and My_Computer_Name\My_Windows_
Account.
■
The permissions required are dependent upon various configuration and connections for individual
cubes, and there are many possible combinations. if you are unsure about how to set up proper security, we recom-
mend using your SQL Server and an SSAS administrator account for the exercises in this topic. Learning how to use
four Bi servers is complex enough without adding permission issues to the mix!
Important
Once you provide an account and its password to the wizard, click Next to proceed to the final dialog
window where you can change the name of the data source, as shown in Figure
9-15
.
