RapidMiner Not Connecting To SQL Server Database Connection I recently installed RapidMiner and tried connecting the application to my MS SQL database connection via the Manage Database Connections feature. I have followed video tutorials on integrating SQL Server but i keep getting errors on connecting to localhost, and port 1433.

I have checked to see if SQL Server browser was running. It is. My TCP/IP connection is enabled, and also my default port is 1433. So what can be the problem?

I use mixed authentication with SQL Management Studio, i added the same in the Manage DB Connection form. But i keep getting an error: 


  "The TCP/IP connection to the localhost, port 1433 has failed. Error:
  Conection refused. connect"


I tried using Microsoft SQL Server (JTDS) as DB system (I downloaded JTDS from Sourceforge),  but i keep getting a 


  "Network error IOException: Connection refused:connect"


Please, I'd really appreciate help because it's left me frustrated as i need this application to work for some project i am undertaking. 

Thanks
Check if TCP-IP is enabled with SQL Server Configuration Manager. Run SQL Server Configuration Manager for different versions of SQL.

Then Edit TCP-IP and go to IPAll and set TCP-IP port to 1433 and Dynamic port to 0, then restart SQL Server service.