Database connection issue

DarmeDarme Member Posts: 10 Contributor II
edited November 2018 in Help
Dear all,

First of all I am happy to say that I voted for RapidMiner in KDNuggets Annual Poll

I have a problem in connecting to Microsoft SQL server 2008 from Rapid Miner 5.3.8
I added a New Driver to RapidMiner with the following parameters

Name : Sql Server
URL prefix: jdbc:sqlserver://
Port: 1433
Schema separator: /
Jar file: sqljdbc4.jar
Next I used this driver to create a new connection with setting the following parameters

Database system: sql server
Host: localhost:1433;databaseName=CSEdb
User: rapidanalytics
Password: rapidanalytics
URL: jdbc:sqlserver:// localhost:1433;databaseName=CSEdb

But connection establishment was not successful.  The following error occurs
“The TCP/IP connection to the locahost, port 1433 has failed. Error connection Refused”
Could you please help me on this

Thanks in advance


  • Options
    Marco_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,996 RM Engineering

    did you restard RapidMiner after adding the new JDBC driver? I just tested it myself and after a RapidMiner restart it works just fine with the following url being shown in the Database Connections Manager:

Sign In or Register to comment.