Deploying and Configuring Analysis Services
Analysis Services uses a managed service account when installed by default although it can also configured to use a domain or local user accounts. As with any network account especially in a Windows environment to always run these accounts such as Analysis Services by using an account assigned the fewest possible privileges.
We should avoid using the LocalService and NetworkService accounts in high security environments because Analysis Services connection strings and passwords can be decrypted and are accessible to the Analysis Services logon account.
Analysis Services comes in 2 Modes:
Multidimensional and data mining mode is the default Analysis Services mode which supports online analytical processing (OLAP) databases and data mining models
Tabular mode, supports new tabular modelling features such as enabling Analysis Services to host solutions built in the tabular model designer and necessary when you want tabular model data access over a network. Deploy and configure Analysis Services.
- Deploy and configure Reporting Services.
- Deploy and configure SharePoint integration.
- Manage full-text indexing.
- Configure SQL Server Integration Services security.
MORE INFO FROM MICROSOFT: INSTALLING ANALYSIS SERVICES .
Setup.exe /q /IAcceptSQLServerLicenseTerms /Action=install /Features=AS /ASSERVERMODE=MULTIDIMENSIONAL /INSTANCENAME=ASMulti /ASSVCACCOUNT=NetworkService /ASSYSADMINACCOUNTS=<myDomain\chosenUserAccount>
To install Analysis Services from the command line we using the /FEATURES=AS option.
The /ASSERVERMODE can be set to MULTIDIMENSIONAL, TABULAR, or POWERPIVOT.
The below is an example of an install which I used on my Windows Server 2008 test machine.
d:\Setup.exe /qs /IAcceptSQLServerLicenseTerms /Action=install /Features=AS /ASSERVERMODE=TABULAR /INSTANCENAME=ASTabular /ASSVCACCOUNT=NetworkService /ASSYSADMINACCOUNTS=<myDomain\chosenUserAccount>
Note: Mode is specific to an instance, if we require more than one mode then it will be necessary to install more than one Analysis Services instance
MORE INFO: ANALYSIS SERVICES ACCOUNTS