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
This is fixed .. was using wrong port and was able to use windows AD