Skip to main content
1-Visitor
May 14, 2020
Solved

Issue with database connection with instance name

  • May 14, 2020
  • 5 replies
  • 2654 views

Hello everyone!

 

I try to connect to my SQL server with instance name. 

So standard (and working) connection string looks like that:

 

jdbc:jtds:sqlserver://serverAdress/DBname;useNTLMv2=true;domain=EU

 

And now I try to use something like this:

jdbc:jtds:sqlserver://serverAdress/DBname;instancename=myInstanceName;useNTLMv2=true;domain=EU

 

When I use local Database account for connection - it works. But when I try to use LDAP account for that, it doesn't work.

Maybe someone did have the same  problem? Maybe I should change somehow connection string?

 

Thank you in advance!

Best answer by slangley

Hi @lala_guliyeva.

 

No need to be specific regarding the changes.  In this case, it sounds like a configuration issue, correct?

 

Regards.

 

--Sharon

5 replies

5-Regular Member
May 15, 2020

The LDAP will help AD user login to the TWX server without password, how's that working with Database connection?

1-Visitor
May 15, 2020

thank you for your answer! But it was local problem and it's already solved.

Support
May 18, 2020

Hi @lala_guliyeva.

 

Thank you for your participation in the community. Would you mind elaborating on the solution for the benefit of other community members.

 

Regards.

 

--Sharon