MS SQL database connnection

Chico

Hi there,

I'm not sure the database connection in rapidminer server is still available right now?

I was trying to create a new MS SQL connection in rapidminer server which is downloaded from aws marketplace. But the connection has failed.
After checking the iptable in the image, I couldn't find the 1433 port which MS SQL connection need it.

Any suggestions?

Kind regards,
Chico

MartinLiebig

Hi,

are you talking about our AWS images? As far as i remember we ship them with a postgres, not MS SQL.

Best,
Martin

CC: @ZSzatmari

Chico

Since I need to create a database connection to grab raw data in MS SQL server, but it looks like the port is not opened when I checked the iptables in the instance.

===

AMI: RapidMiner Server 9.5.3 BYOL

Chain INPUT (policy ACCEPT)

target prot opt source destination

Chain FORWARD (policy DROP)

target prot opt source destination

DOCKER-USER all -- anywhere anywhere

DOCKER-ISOLATION-STAGE-1 all -- anywhere anywhere

ACCEPT all -- anywhere anywhere ctstate RELATED,ESTABLISHED

DOCKER all -- anywhere anywhere

ACCEPT all -- anywhere anywhere

ACCEPT all -- anywhere anywhere

ACCEPT all -- anywhere anywhere ctstate RELATED,ESTABLISHED

DOCKER all -- anywhere anywhere

ACCEPT all -- anywhere anywhere

ACCEPT all -- anywhere anywhere

ACCEPT all -- anywhere anywhere ctstate RELATED,ESTABLISHED

DOCKER all -- anywhere anywhere

ACCEPT all -- anywhere anywhere

ACCEPT all -- anywhere anywhere

ACCEPT all -- anywhere anywhere ctstate RELATED,ESTABLISHED

DOCKER all -- anywhere anywhere

ACCEPT all -- anywhere anywhere

ACCEPT all -- anywhere anywhere

Chain OUTPUT (policy ACCEPT)

target prot opt source destination

Chain DOCKER (4 references)

target prot opt source destination

ACCEPT tcp -- anywhere xxxx.compute.internal tcp dpt:https

ACCEPT tcp -- anywhere xxxx.compute.internal tcp dpt:http

ACCEPT tcp -- anywhere xxxx.compute.internal tcp dpt:http

ACCEPT tcp -- anywhere xxxx.compute.internal tcp dpt:webcache

ACCEPT tcp -- anywhere xxxx.compute.internal tcp dpt:amqp

ACCEPT tcp -- anywhere xxxx.compute.internal tcp dpt:amt-esd-prot

ACCEPT tcp -- anywhere xxxx.compute.internal tcp dpt:pvuniwien

Chain DOCKER-ISOLATION-STAGE-1 (1 references)

target prot opt source destination

DOCKER-ISOLATION-STAGE-2 all -- anywhere anywhere

DOCKER-ISOLATION-STAGE-2 all -- anywhere anywhere

DOCKER-ISOLATION-STAGE-2 all -- anywhere anywhere

DOCKER-ISOLATION-STAGE-2 all -- anywhere anywhere

RETURN all -- anywhere anywhere

Chain DOCKER-ISOLATION-STAGE-2 (4 references)

target prot opt source destination

DROP all -- anywhere anywhere

DROP all -- anywhere anywhere

DROP all -- anywhere anywhere

DROP all -- anywhere anywhere

RETURN all -- anywhere anywhere

Chain DOCKER-USER (1 references)

target prot opt source destination

RETURN all -- anywhere anywhere

ZSzatmari

Our RapidMiner Server AWS Marketplace AMIs (images) are prepared with PostgreSQL as a RapidMiner Server database backend, but it is only for the RapidMiner Server own management data storage. You should be able to connect to any existing MS SQL server as database from any RapidMiner processes. If you have an external MS SQL database, then there is no firewall restriction on the RapidMiner Server cloud image side for any outgoing connection. If you experience any connection issues, then we propose to check your instance's networking setup in AWS (security gorup, subnet settings, IGW, etc...) and the networking/firewall setup of your MS SQL database.