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

**URL:** <https://forum.ansible.com/t/how-to-install-sql-server-on-windows-server-2012-by-using-ansible-playbook/30831>\
**Category:** Ansible Project\
**Tags:** windows\
**Created:** [July 20, 2019, 7:10pm UTC](https://forum.ansible.com/t/how-to-install-sql-server-on-windows-server-2012-by-using-ansible-playbook/30831 "2019-07-20T19:10:38Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mohapatra\_Networking](https://avatars.discourse-cdn.com/v4/letter/m/35a633/32.png) [@Mohapatra\_Networking](https://forum.ansible.com/u/Mohapatra_Networking)\
**Post date:** [July 20, 2019, 7:10pm UTC](https://forum.ansible.com/t/how-to-install-sql-server-on-windows-server-2012-by-using-ansible-playbook/30831/1 "2019-07-20T19:10:38Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![jborean](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/jborean/32/1525_2.png) [@jborean](https://forum.ansible.com/u/jborean)\
**Post date:** [July 20, 2019, 9:32pm UTC](https://forum.ansible.com/t/how-to-install-sql-server-on-windows-server-2012-by-using-ansible-playbook/30831/2 "2019-07-20T21:32:52Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Mohapatra\_Networking](https://avatars.discourse-cdn.com/v4/letter/m/35a633/32.png) [@Mohapatra\_Networking](https://forum.ansible.com/u/Mohapatra_Networking)\
**Post date:** [July 21, 2019, 4:24am UTC](https://forum.ansible.com/t/how-to-install-sql-server-on-windows-server-2012-by-using-ansible-playbook/30831/3 "2019-07-21T04:24:47Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Mohapatra\_Networking](https://avatars.discourse-cdn.com/v4/letter/m/35a633/32.png) [@Mohapatra\_Networking](https://forum.ansible.com/u/Mohapatra_Networking)\
**Post date:** [July 25, 2019, 7:30pm UTC](https://forum.ansible.com/t/how-to-install-sql-server-on-windows-server-2012-by-using-ansible-playbook/30831/4 "2019-07-25T19:30:45Z")

</div>

Hi Jordan,

Can you please help me on this

Thanks

---

<div class="post-metadata">

**Author:** ![jborean](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/jborean/32/1525_2.png) [@jborean](https://forum.ansible.com/u/jborean)\
**Post date:** [July 25, 2019, 8:57pm UTC](https://forum.ansible.com/t/how-to-install-sql-server-on-windows-server-2012-by-using-ansible-playbook/30831/5 "2019-07-25T20:57:25Z")

</div>

I can’t do all the work for you [https://lmgtfy.com/?q=sql+server+install+ini+file](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](https://github.com/PowerShell/SqlServerDsc)

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