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?
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?
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)
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
1 Like
I misunderstood server\instance convention. It ended up being a TLS version issue which I was able to resolve. Thanks
2 Likes