Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

"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 a "The TCP/IP connection to the localhost, port 1433 has failed. Error: Conection refused. connect" error.

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

Find more posts tagged with

AI Studio

Server

Databases

SQL

Accepted answers

All comments

Mustafa_AVDAN

ı got the same error:\ Help please...

Ekran Görüntüsü (17).png

Mustafa_AVDAN

hey, ı solved this error now and ı wanted to share it , thanks to https://www.infocaptor.com/dashboard/jdbc-with-sqlserver-connection-refused-connect...

if you would get the same error , ı guess you will solve this error when visited the link...

sgenzer

hello @Mustafa_AVDAN - welcome to the community. Looks like a port / network issue. You may want to double check all of your settings and make sure there are no ports being blocked, etc...

Scott

[EDIT: sorry @Mustafa_AVDAN - your followup post was caught in the spam filter for some weird reason. Apologies. Glad you found the solution!]