Database connection issue

Darme
Darme New Altair Community Member
edited November 5 in Community Q&A
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
Tagged:

Answers

  • Marco_Boeck
    Marco_Boeck New Altair Community Member
    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

Categories