Unable to connect to local SQL db

macinr

Hi, I downloaded Rapid Miner and I am really curious if it can help with my task of data analysis. However, I cannot connect to my local MS SQL Express database. I've set up the url which looks like this:

jdbc:sqlserver://localhost:1433;databaseName={DbName};integratedSecurity=true;

and when I don't provide the name of DB connection works well, but I have no possibility to access the data, since I am then not connected to a specific database. However, once I specify the name of DB I receive following error message:

Cannot open database "DbName" requested by the login. The login failed. ClientConnectionId:1ead8148-9161-45d6-996b-abab22121

Anyone has any suggestions what steps to take to resolve the problem?
Thanks
Marcin 

Marco_Boeck

Hi,

Connecting via Windows Authentication to MSSQL requires a special .dll file. See https://docs-beta.rapidminer.com/latest/studio/connect/database/jdbc/mssql.html#win-auth
Unfortunately, the functionality described in that article is not yet live, it will come with RapidMiner Studio 9.4 soon.

For now, you will need to copy that .dll into the RapidMiner Studio installation folder, into the jre/bin folder and restart Studio.

Regards,
Marco

macinr

Thanks Marco,
I tried and no luck with proposed solution. I went a step further and created a dedicated user "rm" on the db, and the message I get is 
"Login failed for user 'rm'. ClientConnectionId:6ee55dc3-be1b-44b8-bf8b-e60f21126bd8"

Maybe it has something to do with how I've set up the user? I tried to login with the newly created user using Microsof SQL Management Studio and it works ... but not through Rapid Miner...any ideas what else I could check?

Thanks
Marcin 

Marco_Boeck

Hi,

If you're trying to connect with a regular user, you must NOT set integratedSecurity. So remove "integratedSecurity=true;" from your connection URL and try again with that new user.

Regards,
Marco

macinr

Hi Marco,
I did remove the flag

guylaine_bourqu

Hello, I have the same problem: unable to connect to local sql server instance. I have spent I don't know how many hours trying everything found on Google, I keep getting the error message that TCP/IP connection to the host has failed. I had no problems with previous versions of Rapidminer. I have the following URL:
jdbc:sqlserver://LENOVO\MSSQLSERVER2012:1433;databaseName=%{database}
The connection works well with Tableau and PowerBI, either with Windows auth or with user & pwd. Any idea before I throw my computer by the window ?