[SOLVED]Microsoft SQL Server connection

duyguduygu Member Posts: 12 Contributor I
edited November 2018 in Help
Hello everyone!
I am new at rapidminer. I connect a Microsoft SQL Server (remote). Connection was fine however; instead of my tables "trace_xe_action_map" and
"trace_xe_event_map" are in table section.
Urgent!
Thank you in advace.

Answers

  • homburghomburg Moderator, Employee, Member Posts: 114 RM Data Scientist
    Hi duygu.

    Could you please check in the database connection manager whether you have specified the correct database schema?

    Cheers,
        Helge
  • duyguduygu Member Posts: 12 Contributor I
    Hello Helge,

    yes it is correct. When i connected the first time it was ok, i could see my tables, but now i cant see them.

    thanks.
  • homburghomburg Moderator, Employee, Member Posts: 114 RM Data Scientist
    Good to know that it worked before. Did you do any change to you mssql database? The tables you mentioned are system tables stored at the master instance in the sys schema. Can you try to connect to your database using another sql client to check whether your database is still functioning correctly?

    Cheers,
      Helge
  • duyguduygu Member Posts: 12 Contributor I
    Yes i checked, now it is working correctly. I dont understand why it did that, but thank you :d
Sign In or Register to comment.