New Question

Deploy SQL2019 through userdata powershell

asked 2021-10-18 12:07:50 +0200

simone-benati gravatar image

I'm trying to automate the installation of SQL2019 by feeding openstack a powershell script via userdata. The script works perfectly on my computer and on the production environment. The problem is when I sysprep the image with the unattend.xml provided in the cloudbase init folder.

Everything runs without hiccups but when I login into the machine I find the .iso download paused and therefore the script cannot finish.

I see at the startup the cloudbase init cmd window working, but then I cannot collect any log.

My config file for both unattended and normal conf file:

Any help or suggestion would be appreciated.

edit retag flag offensive close merge delete

1 answer

Sort by » oldest newest most voted

answered 2021-10-18 13:50:09 +0200

avladu gravatar image


Can you share the contents of the logs from C:\Program Files\Cloudbase Solutions\Cloudbase-Init\log\"?

As an example, here is the heat template for the installation of MSSQL using OpenStack userdata: .

There, you can find all the utilities methods to perform the unattended installation of MSSQL Server. This script is a little bit old, but should be a good starting point.

Thank you,

edit flag offensive delete link more


<p> This is the log file. If it helps I see the VM rebooting a lot before booting and all the times the cloudbase-init prompt pop up. Sometimes the .iso is 10mb some other times 300mb . it's random. The script works on different VMs initialized.. Might be something else..

simone-benati gravatar imagesimone-benati ( 2021-10-18 16:35:38 +0200 )edit

The logs that the VM has no metadata setup, and cloudbase-init cannot run without openstack metadata. in the cloudbase-init configuration, you should remove metadata_services=... so that cloudbase-init can try all the possible ones.

avladu gravatar imageavladu ( 2021-10-18 18:33:46 +0200 )edit

Hi, I managed to test your suggestions this morning: if the string meta_serv= is removed on both conf files it loops and i cant recover any logs. Bear in mind I'm trying to feed a ps1 script through openstack "customization script" via config drive If i remove the string only from cb-init conf loops

simone-benati gravatar imagesimone-benati ( 2021-10-19 13:11:12 +0200 )edit

Additional informations: even if i try to feed openstack metadata for example: admin_pass , my sysprep utilizing unattend.xml provided in the default installation , still makes me set a password for Administrator user. And in the logs it still says that metadata are not found.

simone-benati gravatar imagesimone-benati ( 2021-10-19 14:54:05 +0200 )edit

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


Asked: 2021-10-18 12:07:50 +0200

Seen: 68 times

Last updated: Oct 18