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
jdbc:jtds:sqlserver://hostname/dbname;domain=$domain;user=$username;password=$password