The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

"Database connection."

ratheesanratheesan Member Posts: 68 Maven
edited June 2019 in Help
Hi,

I am trying to connect RapidMiner with SQL server using sql server Authentication.But am not able to connect with database and always getting a message " Database error occurred: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect ".I have already enabled the driver in RM.This is my process.

<operator name="Root" class="Process" expanded="yes">
    <operator name="DatabaseExampleSource" class="DatabaseExampleSource">
        <parameter key="database_system" value="Microsoft SQL Server (Microsoft)"/>
        <parameter key="database_url" value="jdbc:sqlserver://computer-647;databaseName=DataMart"/>
        <parameter key="username" value="sa"/>
        <parameter key="password" value="VNfe8QITNRw19hgf6f6UpA=="/>
        <parameter key="query" value="select * from F_TFQ"/>
    </operator>
</operator>

Thanks
Ratheesan
Tagged:

Answers

  • landland RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 2,531 Unicorn
    Hi,
    did you try to use the connection wizard? Does the test say ok? Does the data base drive show up in the Tools / Show Database driver overview?

    Greetings,
      Sebastian
Sign In or Register to comment.