# MSSQL Execute SQL (SQLCmd) fails when using dotted server name

**URL:** <https://www.finalbuilder.com/forums/t/mssql-execute-sql-sqlcmd-fails-when-using-dotted-server-name/6481>\
**Category:** Bugs\
**Created:** [April 30, 2019, 12:23pm UTC](https://www.finalbuilder.com/forums/t/mssql-execute-sql-sqlcmd-fails-when-using-dotted-server-name/6481 "2019-04-30T12:23:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![heath1](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/h/ccd318/32.png) [@heath1](https://www.finalbuilder.com/forums/u/heath1)\
**Post date:** [April 30, 2019, 12:23pm UTC](https://www.finalbuilder.com/forums/t/mssql-execute-sql-sqlcmd-fails-when-using-dotted-server-name/6481/1 "2019-04-30T12:23:56Z")

</div>

Hi,

We have moved some of our SQL tables to Azure SQL, but the SQLCmd is failing when the server contains dotted notation, e.g. “[MyOrg.database.windows.net](http://MyOrg.database.windows.net)”.

“Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Cannot open server ‘MyOrg’ requested by the login.”

I’m running FinalBuilder 8.0.0.2538.

Regards,  
Heath

---

<div class="post-metadata">

**Author:** ![heath1](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/h/ccd318/32.png) [@heath1](https://www.finalbuilder.com/forums/u/heath1)\
**Post date:** [April 30, 2019, 1:28pm UTC](https://www.finalbuilder.com/forums/t/mssql-execute-sql-sqlcmd-fails-when-using-dotted-server-name/6481/2 "2019-04-30T13:28:06Z")

</div>

False alarm, now working!

Needed to add the FinalBuilder machine IP to Azure allowed access list.

Thanks,  
Heath
