I have successfully created a SQL Image of SQL Server 2016 on Azure Marketplace using Packer.
To take this one step further, I manually installed Java, then installed CIS-CAT, remediated according and hardened the image. My goal is to use Packer to do all of this for me. I'm using winrm_username and winrm_password variables to try to authenticate to the SQL Server post installation and it fails. The steps in the process: 1. Create a SQL Server Image from the Marketplace. 2. Install Java from internal Artifactory. 3. Install CIS-CAT too from internal Artifactory. 4. Create a Test DB ( *Fails, because I am unable to login to the SQL Server via Windows Authentication by passing winrm creds*) 5. Run LGPO.exe (I copied the GPO settings that I acquired by manually capturing it in a previous VM) 6. Once the policies have been applied, run the CIS-CAT benchmarks to capture a report. (*Problem with the Connection String, can't generate it using ENV_Variables passed through the template*) 7. Copy the report to a local machine 8. Sysprep and capture the image. If anyone has worked with SQL Server Images using Packer, do give me some feedback to correct my approach. Open to any kind of suggestions as well. -- This mailing list is governed under the HashiCorp Community Guidelines - https://www.hashicorp.com/community-guidelines.html. Behavior in violation of those guidelines may result in your removal from this mailing list. GitHub Issues: https://github.com/mitchellh/packer/issues IRC: #packer-tool on Freenode --- You received this message because you are subscribed to the Google Groups "Packer" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/packer-tool/8753e529-824d-4a75-9295-1c1176a9b005%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
