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

Article ID: 2830465 - View products that this article applies to.
Expand all | Collapse all

Symptoms

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.

Cause

Resolution

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:

Setup.exe /q /IAcceptSQLServerLicenseTerms /ACTION=install /FEATURES=AS /ASSERVERMODE=TABULAR /INSTANCENAME=ASTabular /INDICATEPROGRESS
/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.

Properties

Article ID: 2830465 - Last Review: April 2, 2013 - Revision: 2.0
Applies to
  • Microsoft System Center 2012 Virtual Machine Manager
Keywords: 
KB2830465

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com