Sql Alwayson Configuration with Ansible module

Archives Ansible Project
1

Hi All,

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

Thanks
Raviteja

2

A little bit of context might help getting a useful response

3

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.

4

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
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

5

You may want to use Ansible’s win_dsc module to call SQL DSC resources https://github.com/dsccommunity/SqlServerDsc

чт, 12 дек. 2019 г. в 01:10, Dick Visser <dick.visser@geant.org>: