DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2830465 - Last Review: April 2, 2013 - Revision: 2.0

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 (http://go.microsoft.com/fwlink/?LinkId=151500) for other considerations.

Applies to
  • Microsoft System Center 2012 Virtual Machine Manager
Keywords: 
KB2830465
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support