Ansible for MS SQL Server on Windows
-
We are automating our Windows infrastructure using Ansible.
We created Ansible role and playbook which will install and configure MS SQL Express on Windows Server 2012 R2, but I was not able to develop a playbook which creates a new database on my db server (MS SQL Server 2014.)
The Ansible MS SQL Server module doesn't work for me.
My question is " how do i make connection btw my Ansible controller machines and my MS SQL Server db server which was installed on remote windows hosts?
I installed python 2.7 and Pymssql on my ansible controller machine.
-
And here I was hoping the title says "Ansible for Linux MS SQL Server".
-
@black3dynamite said in Ansible for Windows MS SQL Server:
And here I was hoping the title says "Ansible for Linux MS SQL Server".
No such luck, that would likely make it easier.
Well, not really. Who knows.
-
@scottalanmiller said in Ansible for MS SQL Server on Windows:
@black3dynamite said in Ansible for Windows MS SQL Server:
And here I was hoping the title says "Ansible for Linux MS SQL Server".
No such luck, that would likely make it easier.
Well, not really. Who knows.
Well it can be easier once PowerShell is stable enough and the modules like SQL Server modules was available.
-
I found a nice article on DigitalOcean setting up MySQL and SaltStack state files... is that worth linking? I know both are different, but I'm guessing it's the same concept. I'm familiar with Salt, but not Ansible.. though they seem very similar.
Well here it is anyways, just in case.
-
@tim_g said in Ansible for MS SQL Server on Windows:
I found a nice article on DigitalOcean setting up MySQL and SaltStack state files... is that worth linking? I know both are different, but I'm guessing it's the same concept. I'm familiar with Salt, but not Ansible.. though they seem very similar.
Well here it is anyways, just in case.
Can't hurt.
-
I think that the issue might be that Ansible's modules don't work. But maybe knowing that Salt's do will be useful.
-
@scottalanmiller said in Ansible for MS SQL Server on Windows:
I think that the issue might be that Ansible's modules don't work. But maybe knowing that Salt's do will be useful.
Yeah, I seen that Salt has MS SQL specific modules.
-
It's kind of hard to help without seeing the playbook/role you created.
