...building hybrid clouds that can support any device from anywhere
This past January, we published two Windows Azure Pack (WAP) VM Role gallery items for database workloads, including SQL Server 2012 SP1 and Oracle Database 12c, to complement the SQL Server 2012 gallery item already available at the time. Today, these sample SQL Server gallery items get an update, including a brand new one to celebrate the release of SQL Server 2014!
You can find the updates/changes in the chart below, and more details on the requirements for each gallery item further down in this blog post.
(Updated) “Advanced” SQL Server 2012 SP1 Gallery Item
for Windows Server 2012 and Windows Server 2012 R2
This gallery item leverages an unattended SQL Server setup to provide more features like deployment of named instances, optional database creation, optional T-SQL and .SQL execution, additional user/group added to the administrators role.
New with this release:
Screenshots of this gallery item can be found in the original blog post here.
(New) “Advanced” SQL Server 2014 Gallery Item
Features are the same as the previous gallery item, this time for SQL Server 2014.
(Updated) “Sysprepped” SQL Server 2012 SP1 Gallery Item
This is an update to the original SQL Server 2012 gallery item, that uses an OS disk with a sysprepped version of SQL Server 2012 SP1.
The sysprepped gallery item has the benefit of deploying very fast, especially in a Windows Azure Pack (WAP) environment leveraging parenting disks out of the box. Should you need advanced features like database creation, T-SQL execution, etc. or anything that goes beyond SQL Server sysprep support and that you want to parameterize in the template for your tenants, you can use the “advanced” gallery items. Both types of templates can be imported at the same time in a WAP environment.
We’re also looking at providing a SQL Server 2014 version of this sample gallery item.
Note : The Oracle DB 12c Gallery Item was unchanged and is still available here, along with screenshots and requirements. This gallery item leverages an Oracle DB 12c unattended installation in Windows Server 2012 to deploy the database software and an optional database and/or schema.
“Advanced” SQL Server 2012 SP1 VMRole Gallery Item
“Advanced” SQL Server 2014 VMRole Gallery Item
“Sysprepped” SQL Server 2012 SP1 VMRole Gallery Item
For these gallery items, the Resource Extension (RESEXTPKG file) should be imported into System Center 2012 R2 Virtual Machine Manager, and the Resource Definition (RESDEFPKG file) should be imported from the Windows Azure Pack (WAP) administration portal and added to a plan. A summary of each gallery item’s specific requirements for the OS and data disks is provided below, with full details displayed on the download page for each gallery item and also in the README file in each download package.
The actual way to prepare these requirements – including tagging the OS disks and assigning the right properties to data disks - are explained in this overall document. Or you could use the Gallery Resource Import Tool (GRIT), if you like to keep things simple GRIT will discover all these requirements – except the compatible operating systems versions – and will configure them for you, as well as import the gallery resource extension and definition.
Virtual Hard Disk (OS)
Data Disk –
Sample disks configurations screenshots
OS disk running Windows Server 2012
OS disk running Windows Server 2012 R2
Note : OS disk requirements are the same for the “advanced” SQL Server 2012 SP1 and “advanced” SQL Server 2014 gallery items
(Note : OS disk screenshots are not provided since they are the same as the “advanced” SQL Server 2012 SP1 gallery item)
Data Disk – no data disk is needed for this gallery item
Thank you for reading this post and our blog, we hope you will find these samples useful!
Hi. This is useful stuff. Will you be publishing an update that works with SQL Server 2012 SP2? We're particularly interested in being able to provided a sysprep'd version containing Database and Analysis Services,
We're not planning short term updates to these samples, but you could open the existing ones with the VMRole Authoring Tool, update them for SP2 and to add support for additional SQL Server features.
With the "advanced" version, you would likely just have to replace the source media in the data disk with a SP2-level media, and use an updated Unattended.ini file (remember you can "record" one using SQL Server setup).
With the "sysprepped" version, you would use an image including SQL Sever sysprepped at the SP2 level. You may have to add some custom scripting though, as I'm not sure if the SQL Server specialization features from VMM allows to specialize Analysis Services
(maybe just the Database Engine). As an alternative, you could also just use you own sysprepped image with SQL Server included, and have the "complete image" phase run through a custom script in the VMRole.
Thank you for your post. Should the VM Template be a gen1 or gen2 VM?
Those templates are VM Roles, and they would work with Generation 1 VMs
There are more details on VMM and Generation 2 support here: