How to install and configure a SQL Analysis Server using service templates in Virtual Machine Manager
This article describes how to install and configure a SQL Analysis Server using service templates in System Center 2012 Virtual Machine Manager.
Original product version: System Center 2012 Virtual Machine Manager
Original KB number: 2830465
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.
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, see the following articles:
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for