# How execut script sql on port 1433

**URL:** <https://forum.ansible.com/t/how-execut-script-sql-on-port-1433/30531>\
**Category:** Ansible Project\
**Tags:** windows\
**Created:** [June 11, 2019, 12:16pm UTC](https://forum.ansible.com/t/how-execut-script-sql-on-port-1433/30531 "2019-06-11T12:16:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ryad9200000](https://avatars.discourse-cdn.com/v4/letter/r/f04885/32.png) [@ryad9200000](https://forum.ansible.com/u/ryad9200000)\
**Post date:** [June 11, 2019, 12:16pm UTC](https://forum.ansible.com/t/how-execut-script-sql-on-port-1433/30531/1 "2019-06-11T12:16:17Z")

</div>

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

Regards,

---

<div class="post-metadata">

**Author:** ![racke](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/racke/32/4767_2.png) [@racke](https://forum.ansible.com/u/racke)\
**Post date:** [June 11, 2019, 1:00pm UTC](https://forum.ansible.com/t/how-execut-script-sql-on-port-1433/30531/2 "2019-06-11T13:00:08Z")

</div>

> 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  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Racke

---

<div class="post-metadata">

**Author:** ![ryad9200000](https://avatars.discourse-cdn.com/v4/letter/r/f04885/32.png) [@ryad9200000](https://forum.ansible.com/u/ryad9200000)\
**Post date:** [June 11, 2019, 1:15pm UTC](https://forum.ansible.com/t/how-execut-script-sql-on-port-1433/30531/3 "2019-06-11T13:15:31Z")

</div>

Hi,

Thanks for answer 🙂

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,