# Sql Alwayson Configuration with Ansible module

**URL:** <https://forum.ansible.com/t/sql-alwayson-configuration-with-ansible-module/31806>\
**Category:** Ansible Project\
**Created:** [December 11, 2019, 6:26pm UTC](https://forum.ansible.com/t/sql-alwayson-configuration-with-ansible-module/31806 "2019-12-11T18:26:36Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Raviteja\_Jinkala](https://avatars.discourse-cdn.com/v4/letter/r/bcef8e/32.png) [@Raviteja\_Jinkala](https://forum.ansible.com/u/Raviteja_Jinkala)\
**Post date:** [December 11, 2019, 6:26pm UTC](https://forum.ansible.com/t/sql-alwayson-configuration-with-ansible-module/31806/1 "2019-12-11T18:26:36Z")

</div>

Hi All,

Please suggest if any Ansible module available to configure SQL Alwayson Configuration and Alwayson group creation.

Thanks  
Raviteja

---

<div class="post-metadata">

**Author:** ![Dick\_Visser](https://avatars.discourse-cdn.com/v4/letter/d/d9b06d/32.png) [@Dick\_Visser](https://forum.ansible.com/u/Dick_Visser)\
**Post date:** [December 11, 2019, 6:29pm UTC](https://forum.ansible.com/t/sql-alwayson-configuration-with-ansible-module/31806/2 "2019-12-11T18:29:08Z")

</div>

A little bit of context might help getting a useful response

---

<div class="post-metadata">

**Author:** ![Raviteja\_Jinkala](https://avatars.discourse-cdn.com/v4/letter/r/bcef8e/32.png) [@Raviteja\_Jinkala](https://forum.ansible.com/u/Raviteja_Jinkala)\
**Post date:** [December 11, 2019, 6:33pm UTC](https://forum.ansible.com/t/sql-alwayson-configuration-with-ansible-module/31806/3 "2019-12-11T18:33:35Z")

</div>

Hi Dick,

I have installed SQL 2016 database server on Windows machine, now i need to configure Alwayson feature (active-active cluster) using Ansible module.

Right now I am doing with powershell but need Ansible module to configure.

---

<div class="post-metadata">

**Author:** ![Dick\_Visser](https://avatars.discourse-cdn.com/v4/letter/d/d9b06d/32.png) [@Dick\_Visser](https://forum.ansible.com/u/Dick_Visser)\
**Post date:** [December 11, 2019, 10:09pm UTC](https://forum.ansible.com/t/sql-alwayson-configuration-with-ansible-module/31806/4 "2019-12-11T22:09:52Z")

</div>

I'm not a Windows expert, but looking at the list of all the modules  
at [https://docs.ansible.com/ansible/latest/modules/list\_of\_all\_modules.html](https://docs.ansible.com/ansible/latest/modules/list_of_all_modules.html)  
there is only one mssql module.  
So what you want looks to be (too) specific, so I guess your best  
option is to use powershell (perhaps through ansible).

Dick

---

<div class="post-metadata">

**Author:** ![Igor\_Turovsky](https://avatars.discourse-cdn.com/v4/letter/i/cdc98d/32.png) [@Igor\_Turovsky](https://forum.ansible.com/u/Igor_Turovsky)\
**Post date:** [December 15, 2019, 12:59pm UTC](https://forum.ansible.com/t/sql-alwayson-configuration-with-ansible-module/31806/5 "2019-12-15T12:59:38Z")

</div>

You may want to use Ansible’s win\_dsc module to call SQL DSC resources [https://github.com/dsccommunity/SqlServerDsc](https://github.com/dsccommunity/SqlServerDsc)

чт, 12 дек. 2019 г. в 01:10, Dick Visser \<[dick.visser@geant.org](mailto:dick.visser@geant.org)\>: