com.rapidminer.operator.UserError: Database connection failed: connection MSSQL is unknown.

IkalausIkalaus MemberPosts:3Contributor I
edited December 2018 inHelp

Hello!

I'm trying to run process from server and then there are an error "com.rapidminer.operator.UserError: Database connection failed: connection MSSQL is unknown. Please define the connection properly."

When i click run process locally it works.

How can i upload connection from studio? or how can i solve this problem.

Other quiestion

When trying to reload Database drivers there are error

Cannot reload database drivers, 'C:\Rapid\standalone\configuration\.RapidMiner\jdbc_properties.xml' not found.

1.JPG 26K
2.JPG 51.4K
Tagged:

Answers

  • sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM ModeratorPosts:2,959Community Manager

    hello@Ikalaus- you need to create database connections in Server if you want it to use them. Log into the web interface as admin and then go to Administration -> Database connections. Set everything up there (including testing) and you should be good to go.


    Scott

  • IkalausIkalaus MemberPosts:3Contributor I

    Hello thanks for answer.

    I have already created conections in server

    I think that maybe there are another solution to create from studio and then atach to server.

  • sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM ModeratorPosts:2,959Community Manager

    @Ikalaus- have you saved the process on the server first, and then set the parameters for Read Database? You have to save the process on the server so that the server database connections will propagate to your Studio database connections.


    Scott

  • IkalausIkalaus MemberPosts:3Contributor I

    Hi@ScottGenzer

    No i saved first in studio.

    ThanksI'll try save first on the server.

    sgenzer
Sign InorRegisterto comment.