How to install and configure a SQL Analysis Server using service templates in Virtual Machine Manager


System Center 2012 Virtual Machine Manager (VMM 2012) does not provide a way to install and configure a SQL Analysis server using service templates. The method below can be used to achieve a similar result.




The way to accomplish this is to have a SysPrep version of SQL Server in a template. In the service template, configure the SQL server and provide the media path. Then, add a post install script that runs setup for SQL Analysis Server from the media path provided. The script will look something like the following:

/ASSVCACCOUNT=<DomainName\UserName> /ASSVCPASSWORD=<StrongPassword> /ASSYSADMINACCOUNTS=<DomainName\UserName> 

More Information

For more information on how to setup SQL Analysis Services using a command line, please see the following:


Article ID: 2830465 - Last Review: Apr 2, 2013 - Revision: 1