# JDBC SQL Server Connection URL

**URL:** <https://forum.inductiveautomation.com/t/jdbc-sql-server-connection-url/103782>\
**Category:** Ignition\
**Created:** [March 17, 2025, 2:50pm UTC](https://forum.inductiveautomation.com/t/jdbc-sql-server-connection-url/103782 "2025-03-17T14:50:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![em.cc.rose](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@em.cc.rose](https://forum.inductiveautomation.com/u/em.cc.rose)\
**Post date:** [March 17, 2025, 2:50pm UTC](https://forum.inductiveautomation.com/t/jdbc-sql-server-connection-url/103782/1 "2025-03-17T14:50:59Z")

</div>

I am trying to setup a new database connection within Ignition. I have a successfully configured a connection to my production database, but I am struggling with setting up our test database. The JDBC driver is for MS SQL Server. My issue is that our test database is on a server that contains a \ in the name. The format for the connection URL is supposed to be: jdbc:sqlserver://host\instanceName[:port]. My server name is similar to "serverName\sv," and I can't seem to escape the \ character. I can't change our server name. How can I escape this character?

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [March 17, 2025, 3:02pm UTC](https://forum.inductiveautomation.com/t/jdbc-sql-server-connection-url/103782/2 "2025-03-17T15:02:47Z")

</div>

As far as I know, you don't have to escape the backslash. In fact, when you set the JDBC driver to MSSQL the syntax prompt is  
`jdbc:sqlserver://host\instanceName[:port]`

One I set up previously is configured  
`jdbc:sqlserver://10.xx.xx.xx\SQLEXPRESS:1433`  
and it worked.

What's the error message?

---

<div class="post-metadata">

**Author:** ![Benjamin\_Furlani](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/benjamin_furlani/32/66084_2.png) [@Benjamin\_Furlani](https://forum.inductiveautomation.com/u/Benjamin_Furlani)\
**Post date:** [March 17, 2025, 3:48pm UTC](https://forum.inductiveautomation.com/t/jdbc-sql-server-connection-url/103782/3 "2025-03-17T15:48:12Z")

</div>

> [@em.cc.rose](#):
>
> My server name is similar to "serverName\sv,"

Do you mean the SQL Server + Instance name or are you saying the actual machine name has a \ in it? (this isn't possible with windows machine names)

---

<div class="post-metadata">

**Author:** ![em.cc.rose](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@em.cc.rose](https://forum.inductiveautomation.com/u/em.cc.rose)\
**Post date:** [March 17, 2025, 5:52pm UTC](https://forum.inductiveautomation.com/t/jdbc-sql-server-connection-url/103782/4 "2025-03-17T17:52:44Z")

</div>

I changed the port from the default, our prod database only had one instance on the server which I didn't realize. It ended up being TLS version issue at the end. My network admin changed a java.security setting and I am good to go. Thanks for the response

---

<div class="post-metadata">

**Author:** ![em.cc.rose](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@em.cc.rose](https://forum.inductiveautomation.com/u/em.cc.rose)\
**Post date:** [March 17, 2025, 5:54pm UTC](https://forum.inductiveautomation.com/t/jdbc-sql-server-connection-url/103782/5 "2025-03-17T17:54:37Z")

</div>

I misunderstood server\instance convention. It ended up being a TLS version issue which I was able to resolve. Thanks