Installing SQL Server Analysis Services from the Command Prompt
Note
We recommend that you review How to: Install SQL Server 2005 from the Command Prompt for detailed information about installing the Microsoft SQL Server 2005 products and technologies from the command prompt.
This topic contains information specific to installing Microsoft SQL Server 2005 Analysis Services (SSAS) from the command prompt, and does not address other installation methods or the installation of other SQL Server 2005 components.
Analysis Services Command Prompt Installation Parameters
You can install Analysis Services from the command prompt on a local or remote server, or on a failover cluster. When you install from the command prompt, you can specify setup parameters at the command prompt, or you can use the /settings switch to load setup parameters from an .ini file. You must use either setup command-line parameters or an .ini file, but you cannot use both.
When you install from the command prompt, you must use the addlocal="feature1,feature2,..." switch to specify the SQL Server 2005 features that you want to install. The following table shows the parameters that are required for installing an instance of Analysis Services.
| Value | Specifies |
|---|---|
Analysis_Server |
An instance of Analysis Services |
AnalysisDataFiles |
The data files for Analysis Services |
For example, to install an instance of Analysis Services, together with the product documentation, set the argument addlocal as shown in the following example:
setup addlocal="Analysis_Server,AnalysisDataFiles,SQL_BooksOnline"
For more information about the SQL Server 2005 features that you can specify in the addlocal argument, see the template.ini file in the root folder of the SQL Server 2005 installation media, or see How to: Install SQL Server 2005 from the Command Prompt.
Important
You can now install certain SQL Server 2005 components to a location other than the default location of %ProgramFiles%\Microsoft SQL Server\90. This option is available for SQL Server 2005 Integration Services (SSIS), SQL Server 2005 Notification Services, and Workstation Components (which are client tools, documentation, and samples). Use the installsqlshareddir switch for this option when you install from the command prompt.
Other Required Command Prompt Installation Parameters
Additional parameters, such as PIDKEY, are required for any SQL Server installation that you perform by using the setup command at the command prompt. Other parameters may also be needed for a particular installation of Analysis Services and for other SQL Server 2005 components.
For more information about installing SQL Server 2005 products and technologies from the command prompt, see How to: Install SQL Server 2005 from the Command Prompt.
Additional Analysis Services Command Prompt Installation Parameters
In addition to addlocal, the following /settings command-line parameters are specific to Analysis Services.
Note
The arguments listed below cannot be used for failover cluster installations.
| Parameter | Description |
|---|---|
INSTALLOLAPDIR="OLAP_executable_folder_path" |
Specifies the folder in which the Analysis Services executable files are installed. The default path is C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\bin. Install Analysis Services to a folder that uses only single-byte characters in the path and name. |
INSTALLOLAPDATADIR="OLAP_data_folder_path" |
Specifies the folder in which the Analysis Services cubes are built. The default location is C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\Data. |
OLAPACCOUNT="domain\logon_name" |
Specifies the MSSQLServerOLAPService service account domain and logon name. Use the argument OLAPPASSWORD to specify the password that corresponds to the logon name. If you do not specify this argument, the default will be used. The default is the local system account. |
OLAPAUTOSTART={1|0} |
Specifies whether the MSSQLServerOLAPService service is started automatically when the Microsoft Windows operating system is restarted. Specify 1 to enable the service to automatically start, or specify 0 to disable the service from automatically starting. If you do not specify this argument, the default of 1 will be used. |
OLAPPASSWORD="password" |
Specifies the MSSQLServerOLAPService service account password that corresponds to the logon name that is specified by the argument OLAPACCOUNT. If you do not specify this argument, the default of a null password will be used. |
For more information about the SQL Server 2005 setup parameters that you can specify when you install from the command prompt, see the template.ini file in the root folder of the SQL Server 2005 installation media, or see How to: Install SQL Server 2005 from the Command Prompt.
Specifying Setup Parameters By Using an .Ini File
Optionally, you can specify setup command-line parameters by loading them from an .ini file. At the setup command line, use the /settings filename.ini argument to specify the .ini file.
The template.ini file on the SQL Server 2005 installation media provides detailed instructions for creating an .ini file. Note in particular that the first noncommented line in the .ini file must contain the string [Options]. The following example illustrates the format of an .ini file:
[Options]
USERNAME=MyName
COMPANYNAME=MyCompany
PIDKEY=ABCDE12345FGHIJ67890KLMNO
INSTALLSQLDIR="C:\Program Files\Microsoft SQL Server\"
INSTALLOLAPDATADIR="C:\Program Files\Microsoft SQL Server\MSSQL\OLAP\Data"
ADDLOCAL=Server_Components,Analysis_Server,AnalysisDataFiles,...
INSTANCENAME=MyInstance
OLAPACCOUNT=MyDomain/MyAccount
OLAPPASSWORD=MyPassword
OLAPAUTOSTART=1
...
For more information about specifying SQL Server 2005 setup parameters by using an .ini file, see the template.ini file in the root folder of the SQL Server 2005 installation media, or see How to: Install SQL Server 2005 from the Command Prompt.
See Also
Concepts
Installing SQL Server Analysis Services