How execut script sql on port 1433

Archives Ansible Project
1

Hy,

I have Ansible on my debian 8.11 and i have on script my_script.sql

I have install tool mssql-cli and i can with this tool execut my_script.sql on my database MSSQL.

I have on server Windows database MSSQL.

I want that Ansible communicate with database only on the port 1433, i try to use ansible_port=1433 and ansible_ssh_port=1433 but not works.

So i want that Ansible use only port 1433 so protocol sql

Someone have some idea please ??

Thanks very much community ansible !! :wink:

Regards,

2

Hy,

I have Ansible on my debian 8.11 and i have on script my_script.sql

I have install tool mssql-cli and i can with this tool execut my_script.sql on my database MSSQL.

I have on server Windows database MSSQL.

I want that Ansible communicate with database *only on the port 1433*, i try to use ansible_port=1433 and
ansible_ssh_port=1433 but not works.

*So i want that Ansible use only port 1433 so protocol sql*

It is unclear to me why you want to use Ansible at all for simple communicating with the database.
There are tons of tools and support for many programming languages to do this standalone.

Regards
          Racke

3

Hi,

Thanks for answer :slight_smile:

Because Ansible can deploy application ? and Who say application say database ? Say update database ? Saye script sql ?

I donc’t understand why there not a lot of module for database mssql i’m very nervous !!!

Sorry,

Regards,