SQL Server Connection issue

sunnyal
sunnyal New Altair Community Member
edited November 2024 in Community Q&A

I'm trying to connect to SQL server and apparently it does not work in RapdiMiner and the same works fine with other tools. I get the message TCP/IP connection to the host vxtd230a2/insta2, port 1433 has failed. I check the TCP/IP port and it is enabled as well. However, my Oracle connection works just fine.

 

Below is the URL 

jdbc:sqlserver://vxtd230a2/insta2;databaseName=DB_OPS

 

also tried

 

jdbc:sqlserver://vxtd230a2\insta2;databaseName=DB_OPS

Tagged:

Answers

  • sunnyal
    sunnyal New Altair Community Member

    This is fixed .. was using wrong port and was able to use windows AD

Categories