Sql Alwayson Configuration with Ansible module

51 views
Skip to first unread message

Raviteja Jinkala

unread,
Dec 11, 2019, 1:26:36 PM12/11/19
to Ansible Project
Hi All,

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

Thanks
Raviteja

Dick Visser

unread,
Dec 11, 2019, 1:29:35 PM12/11/19
to ansible...@googlegroups.com
A little bit of context might help getting a useful response 

--
You received this message because you are subscribed to the Google Groups "Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/a0e93df8-0b89-40c9-969e-43e315bb72d7%40googlegroups.com.
--
Sent from a mobile device - please excuse the brevity, spelling and punctuation.

Raviteja Jinkala

unread,
Dec 11, 2019, 1:33:35 PM12/11/19
to Ansible Project
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.

Dick Visser

unread,
Dec 11, 2019, 5:10:20 PM12/11/19
to ansible...@googlegroups.com
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
> --
> You received this message because you are subscribed to the Google Groups "Ansible Project" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/479caf86-20ba-41f3-a3f4-588464c18cce%40googlegroups.com.



--
Dick Visser
Trust & Identity Service Operations Manager
GÉANT

Игорь Туровский

unread,
Dec 15, 2019, 8:00:01 AM12/15/19
to ansible...@googlegroups.com
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....@geant.org>:
Reply all
Reply to author
Forward
0 new messages