Connection to a MSSQL database whose name contains "\"

[Igor_V]

I'm trying to create a database connection on an MSSQL server named SQLINTEG\SQLEDU.

The connection doesn't go through.

If there is no "\" in the server name, then everything is in order.

How correctly to configure a connection to such servers?

[anselmopeixoto]

Hi @Grapeus Grapeus​ 

Did you try escaping the backward slash with another one?

Like this: "SQLINTEG\\SQLEDU"

[Igor_V]

Yes, it doesn't work!

[Safus]

Hi @Grapeus Grapeus​ 

Did you try to escape like this within double brackets : "[SQLINTEG\\SQLEDU]" ?

[Igor_V]

[SQLINTEG\\SQLEDU] also doesn't work

[anselmopeixoto · Accepted solution]

Hi @Grapeus Grapeus​ 

I believe SQLINTEG refers to the server name while SQLEDU is the instance.

If that's the case and you're using open jTDS jdbc driver, you might succeed with the following approach:

jdbc:jtds:sqlserver://SQLEDU:1433/dbname;instance=SQLEDU

Where "instance=SQLEDU" should be informed on the "Additional parameters" attribute of the connection.

Now if you're using Microsoft JDBC driver, it should work with the following:

jdbc:sqlserver://SQLEDU\\SQLEDU;databaseName=dbname

Or perhaps with

jdbc:sqlserver://SQLEDU/SQLEDU:1433;DatabaseName=database

[Igor_V]

Hi @anselmopeixoto (Customer)

Yes!!! It work!!! jTDS jdbc driver string correctly connected.

Thank you very much!!! It was a big problem for me!