🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

"Database connection."

User: "ratheesan"
New Altair Community Member
Updated by Jocelyn
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

Find more posts tagged with

Sort by:
1 - 1 of 11
    User: "land"
    New Altair Community Member
    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