New Question
0

Windows OpenStack image with SQL Server 2014 Standard pre-installed

asked 2015-11-11 07:00:37 +0200

hjsmarais gravatar image

Hi

I've had success building my own OpenStack images for Windows using cloudbase-init and some automation. The next step is to build an image that has SQL Server pre-installed. Given that this is supposed to be a generic installation, I'd like to install SQL Server with all the features enabled and with default settings.

My questions are as follows. For some parts of SQL Server, the Analytics component for instance, require that a new user be created during installation. What happens to that user once I install cloudbase-init and prep the installation to become an image? Or is there perhaps a better way of creating an image with SQL Server pre-installed that just running through the normal image creation process, and simply installing SQL Server before installing cloudbase-init and prepping the image?

edit retag flag offensive close merge delete

1 answer

Sort by » oldest newest most voted
0

answered 2015-11-11 19:56:33 +0200

avladu gravatar image

Hello,

In this case, you can use a Heat template. In order to do that, the workflow is: create the Windows image with the cloudbase-init, sysprep it, upload it to Glance, then use Heat to deploy your MSSQL workload.

You can find here a Heat template for MSSQL server:

https://github.com/openstack/heat-templates/tree/master/hot/Windows/MSSQLServer

Thanks.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower

Stats

Asked: 2015-11-11 07:00:37 +0200

Seen: 1,189 times

Last updated: Nov 11 '15