Options

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
Darme

Answers

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

    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:
    jdbc:sqlserver://192.168.1.xxx:1433;databaseName=xyz

    Regards,
    Marco
Sign In or Register to comment.