# MS SQL database connection

**URL:** <https://forum.inductiveautomation.com/t/ms-sql-database-connection/11200>\
**Category:** Ignition\
**Created:** [February 11, 2016, 7:11pm UTC](https://forum.inductiveautomation.com/t/ms-sql-database-connection/11200 "2016-02-11T19:11:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Clkman](https://avatars.discourse-cdn.com/v4/letter/c/45deac/32.png) [@Clkman](https://forum.inductiveautomation.com/u/Clkman)\
**Post date:** [February 11, 2016, 7:11pm UTC](https://forum.inductiveautomation.com/t/ms-sql-database-connection/11200/1 "2016-02-11T19:11:36Z")

</div>

Hi  
Our IT dept are in the process of moving our local MSSQL db from localhost to a clustered server but we’re having difficulty connecting to the new db.

They’ve issued the location as “[sql.CompanyName.com](http://sql.CompanyName.com),1435” and my question is how do we translate this into the normal connection path?  
Thanks. ☹

---

<div class="post-metadata">

**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\
**Post date:** [February 11, 2016, 10:05pm UTC](https://forum.inductiveautomation.com/t/ms-sql-database-connection/11200/2 "2016-02-11T22:05:06Z")

</div>

I would think it would look something like this

jdbc:sqlserver://sql.CompanyName.com\MSSQLSERVER:1435

assuming that the database instance is set to mssqlserver and that the [sql.companyname.com](http://sql.companyname.com) is a legit host name on you rnetwork.

I would try and ping [sql.companyname.com](http://sql.companyname.com) and see if you see good pings or if it even give you a ip address

---

<div class="post-metadata">

**Author:** ![Clkman](https://avatars.discourse-cdn.com/v4/letter/c/45deac/32.png) [@Clkman](https://forum.inductiveautomation.com/u/Clkman)\
**Post date:** [February 13, 2016, 10:08am UTC](https://forum.inductiveautomation.com/t/ms-sql-database-connection/11200/3 "2016-02-13T10:08:39Z")

</div>

Thanks for the reply diat150.  
I tried your suggestions and I could ping [sql.companyname.com](http://sql.companyname.com) OK but still couldn’t connect. It turns out our IT dept hadn’t configured the db correctly.

Once they’d corrected the issues, it finally connected OK.