You are currently offline, waiting for your internet to reconnect

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:

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Article ID: 2830465 - Last Review: 04/02/2013 17:04:00 - Revision: 2.0

Microsoft System Center 2012 Virtual Machine Manager

  • KB2830465