Installing SQL Server Analysis Services from the Command Prompt
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]
This topic contains information specific to installing Microsoft SQL Server Analysis Services at the command prompt. It does not address other the installation methods for Analysis Services or other SQL Server components.
Note
We recommend that you review How to: Install SQL Server 2008 from the Command Prompt for detailed information about how to install Microsoft SQL Server products and technologies at the command prompt.
Analysis Services Command Prompt Installation Parameters
To install or upgrade Analysis Services at the command prompt, specify "AS" as one of the values for the FEATURES command-line option. For example, to install Analysis Services, you would specify /FEATURES=AS on the command line.
The following table shows the parameters available for installing an instance of Analysis Services.
| Parameter | Default Value | Description |
|---|---|---|
ASBACKUPDIR |
C:\Program Files\Microsoft SQL Server\<Instance ID>\OLAP\Backup For example, the Instance ID might look something like this: MSAS10.MSSQLSERVER. |
Specifies the folder in which the Analysis Services backup files are stored. |
ASCOLLATION |
Latin1_General_CI_AS |
Specifies the collation setting for Analysis Services. |
ASCONFIGDIR |
C:\Program Files\Microsoft SQL Server\<Instance ID>\OLAP\Config |
Specifies the folder in which the Analysis Services configuration files are installed. |
ASDATADIR |
C:\Program Files\Microsoft SQL Server\<Instance ID>\OLAP\Data |
Specifies the folder in which the Analysis Services cubes are built. |
ASLANGUAGE |
1033 |
Specifies the locale identifier (LCID). The value 1033 represents US-English. |
ASLOGDIR |
C:\Program Files\Microsoft SQL Server\<Instance ID>\OLAP\Log |
Specifies the folder in which the Analysis Services log files are stored. |
ASPROVIDERMSOLAP |
1 |
Specifies whether the MSOLAP provider can run in process. |
ASSVCACCOUNT |
local system account |
Specifies the MSSQLServerOLAPService service account domain and logon name. Use the argument ASSVCPASSWORD to specify the password that corresponds to the logon name. If you do not specify this argument, the default will be used. |
ASSVCPASSWORD |
blank |
Specifies the MSSQLServerOLAPService service account password that corresponds to the logon name that is specified by the argument ASSVCACCOUNT. Specifying a blank password will cause an error. To use a blank password do not specify this parameter. |
ASSVCSTARTUPTYPE |
Automatic |
Specifies whether the MSSQLServerOLAPService service is started automatically when the Microsoft Windows operating system is restarted. The options are Automatic, Disabled, or Manual. |
ASSYSADMINACCOUNTS |
blank |
Specifies the MSSQLServerOLAPService administrator account password. |
ASTEMPDIR |
C:\Program Files\Microsoft SQL Server\<Instance ID>\OLAP\Temp |
Specifies the folder in which the Analysis Services temporary files are stored. |
ERRORREPORTING |
0 |
Specifies whether error reporting is enabled or disabled. To enable error reporting, specify 1. Otherwise, specify 0. |
SQMREPORTING |
0 |
Specifies whether Software Quality Monitoring (SQM) is enabled. To enable SQM reporting, specify 1. Otherwise, specify 0. |
Analysis Services Installation Examples
Test and modify the following installation scripts to meet the needs of your organization.
To install a new default instance of Analysis Services and Management Tools.
Insert the installation media into the disk drive and open the folder at <CD or DVD drive>:\SQLDev\Servers\, or navigate to the network build folder \\..\SQLDev\Servers\.
Run the following command at the command prompt:
setup.exe /ACTION=install /FEATURES=AS,Tools /INSTANCENAME=MSSQLSERVER /ASSVCACCOUNT =<DomainName\UserName> /ASSVCPASSWORD =<StrongPassword>Important
Do not use a blank password. Use a strong password.
To upgrade an existing instance of SQL Server 2000 Analysis Services or SQL Server 2005 Analysis Services
Insert the installation media into the disk drive and open the folder at <CD or DVD drive>:\SQLDev\Servers\, or navigate to the network build folder \\..\SQLDev\Servers\..
Run the following command at the command prompt:
setup.exe /ACTION=upgrade /FEATURES=AS /INSTANCENAME=<InstanceName>
To repair a broken SQL Server 2008 Analysis Services installation
Insert the installation media into the disk drive and open the folder at <CD or DVD drive>:\SQLDev\Servers\, or navigate to the network build folder \\..\SQLDev\Servers\..
Run the following command at the command prompt:
setup.exe /ACTION=repair /FEATURES=AS /INSTANCENAME=<InstanceName> /ASSVCACCOUNT =<DomainName\UserName> /ASSVCPASSWORD=<StrongPassword>
To uninstall an instance of Analysis Services
Insert the installation media into the disk drive and open the folder at <CD or DVD drive>:\SQLDev\Servers\, or navigate to the network build folder \\..\SQLDev\Servers\..
Run the following command at the command prompt:
setup.exe /ACTION=uninstall /FEATURES=AS /INSTANCENAME=<InstanceName>
See Also
Other Resources
How to: Install SQL Server 2008 from the Command Prompt