SQL Server Connection issue

sunnyalsunnyal Member Posts: 44 Contributor II
edited June 2019 in Help

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

Answers

  • sunnyalsunnyal Member Posts: 44 Contributor II

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

    Thomas_Ott
Sign In or Register to comment.