How to install SQL server on Windows server 2012, by using ansible playbook.

Archives Ansible Project
1

Hi,

I want to install sql server on windows server 2012. Sql server application is on my share repository, I want to install that sql application on customize way, like it have to install on “D” drive insteed of “C” drive.

Thanks

2

Look up documentation online for the SQL server installer and just follow that. I believe you configure an ini file that is passed as an argument to the SQL installer. One thing to note about installing SQL server, you either need to connect with CredSSP auth or use the become method in Ansible to get it working.

Thanks

Jordan

3

Hi Jordan,

Thanks for the quick response, I have n’t created the ini file. Can you please share the sample installation guide, it will help me.

Thanks

4

Hi Jordan,

Can you please help me on this

Thanks

5

I can’t do all the work for you https://lmgtfy.com/?q=sql+server+install+ini+file

A simple google search around ‘how to install SQL server with Ansible’ also gives you a few examples and roles that you can try out. There’s also the SqlServerDsc [1] resource that you can use with win_dsc to install it for you.

[1] - https://github.com/PowerShell/SqlServerDsc

Ahttps://lmgtfy.com/?q=sql+server+install+ini+filehttps://lmgtfy.com/?q=sql+server+install+ini+file