🎉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

Using SQLServer driver

User: "gemify"
gemify
New Altair Community Member
Updated by Jocelyn
Does anyone have experience setting up a SQLServer JDBC driver in RM 5.1?

Here's what I've already done:
-installed SQLServer JDBC drivers
-installed new driver in RM (Tools->Manage Database Drivers)
-setup a DB connection (Tools->Manage Database Connections)

I'm running SQLServer Express. My connection details looks like this:
Database system : SQLServer (my driver that I'd previously installed)
Host: localhost/sqlexpress
Port: 1433
Database schema:
User: <username>
Password: <password>
URL shows up on the UI as : jdbc:sqlserver://localhost/sqlexpress:1433

When I hit the 'Test' button, I get the following (partial) message:
The TCP/IP connection to the host localhost/sqlexpress, port 1433 has failed. Error: "null. Verify t...

The rest of the message is not visible in the UI. SQLServer browser service is up. TCP is enabled.

Any help is appreciated! Thanks!

Find more posts tagged with

AI Studio
Sort by:
1 - 7 of 71
    User: "keith"
    keith
    New Altair Community Member
    I have JDBC to SQL Server working successfully in RM 5.1.  Looking at what you're doing, the three things I notice as different are (1) I have a backslash instead of a forward slash in the host-instance and (2) I happen to be using integrated security to use Windows credentials to connect, and (3) I didn't specify a port number.  My connection URL looks like:

    jdbc:sqlserver://MYSERVER\MYINSTANCE;integratedSecurity=true

    Based on that, and assuming that you aren't using integrated security, I'd suggest trying one of the following two URL's:

    jdbc:sqlserver://localhost\sqlexpress
    jdbc:sqlserver://localhost\sqlexpress:1433

    Hope that helps.

    Keith
    User: "gemify"
    gemify
    New Altair Community Member
    OP
    That worked beautifully! Thanks a bunch for your help!

    I removed the port and corrected the host to use a backward slash '\' (localhost\sqlexpress). Now the connection works with both integrated as well as sqlserver authentication.
    User: "TSFT"
    TSFT
    New Altair Community Member
    Hello, I am facing the same problem you resolve , I can not connect to SQL Server express 2010, the connection dialog fiedls were filled with localhost/SQLEXPRESS with port or without, I have integrated security, I tried to add the string integratedsecurity=true in the field database schema and even so the connection fail, any idea. thanks

    I have tried again to test the connection, now I have a network error ioexception message.
    According to database drivers there is a sql server driver already installed, i am working with 5.3 version of rapidminer, and windows 7, sql server is authenticated qith windows. Any idea.
    User: "keith"
    keith
    New Altair Community Member
    Try using a backslash instead of a forward slash.  That is, use

    localhost\SQLEXPRESS

    instead of

    localhost/SQLEXPRESS
    User: "TSFT"
    TSFT
    New Altair Community Member
    I get a better answer, it seems my system lack a dll that comes with JTDS driver (ntlmauth.dll), a file I can not get at sourceforge.net, the one I need is for windows 7 x64, but I can not access sourceforge.net ,I have tried from Saturday and the site seems to be down and I do not know why. 
    User: "RWingerter"
    RWingerter
    New Altair Community Member
    The Sourcefourge download (jtds-1.3.0-dist.zip) comes with a 64 bit version and a 32 bit version of ntmlauth.dll, each in its own subdirectory. Note that the 64 bit DDL in \jtds-1.3.0-dist.zip\x64\SSO must be copied to the C:\Windows\System32[!] directory and the 32 bit DDL in \jtds-1.3.0-dist.zip\x86\SSO must be copied to C:\Windows\SysWOW64[!]. (The names of the Windows system subdirectories are rather confusing, cf. http://en.wikipedia.org/wiki/WoW64). ;

    Hope this helps

    Roland

    User: "TSFT"
    TSFT
    New Altair Community Member
    Thank you people,

    I have accessed sourceforeg at last, and I have ntmlauth.dll just in windows/system32 and import database table function WORKED GOOD; the connection stringi have used:

    host: localhost  port:1433
    database: AdventureWorks2008R2;instance=SQLEXPRESS

    Regards.




Quick Links