Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

no access to SQL server using proxy

I have some strange behaviour trying to access our company databases. I can access them when using direct (no proxy), but the moment I select proxy I cannot access the servers anymore (MS SQL).

This is pretty annoying as I have a process crawling websites that need the proxy to be set, and I want to load the results to our databases but that doesn't work unless I disable the proxy.

Any advice on what I need to set to also get access to my databases using proxy?

I'm using RM7.4

Find more posts tagged with

AI Studio

Server

SQL

Accepted answers

BalazsBaranyRM

Hi,

did you try listing the name or ip address of your database server in the "No proxy for" list? This only works if you're using the Manual Proxy setting.

Regards,

Balázs

kayman

Sorry, too fast again... I can access my databases now with manual proxy but I loose access to the internet :-(

So this is what I have :

Using system proxy : access to the web but not to database or localhost RM server

Using direct (no proxy) : access to database, localhost RM server but not web

Using manual proxy and no proxy for localhost|mydb1|mydb2 : access to database, localhost RM Server but not to web anymore

What would be the magic recepy ?

[UPDATE] I had to remove the socks settigns, that did the trick for me.

Now I get access to all of them using manual proxy, thanks for the support !

All comments

BalazsBaranyRM

Hi,

did you try listing the name or ip address of your database server in the "No proxy for" list? This only works if you're using the Manual Proxy setting.

Regards,

Balázs

kayman

yeah, no success with that one either. I can give it a try with the IP.

tbh, i am actually more suprised it works without the proxy as with the proxy, since I should only have access to the servers within the network by default.

Thomas_Ott

Do you need to specify an instance under the database schema parameter?

Like "database;instance=sqlexpress"

kayman

Seems I was a bit too fast, I've tried again entering my database names under manual proxies and it seems to be ok, took just a bit more time as usual so I was probably not patient enough while I tried it before.

Thomas_Ott

Cool! Happy RapidMining!

kayman

Sorry, too fast again... I can access my databases now with manual proxy but I loose access to the internet :-(

So this is what I have :

Using system proxy : access to the web but not to database or localhost RM server

Using direct (no proxy) : access to database, localhost RM server but not web

Using manual proxy and no proxy for localhost|mydb1|mydb2 : access to database, localhost RM Server but not to web anymore

What would be the magic recepy ?

[UPDATE] I had to remove the socks settigns, that did the trick for me.

Now I get access to all of them using manual proxy, thanks for the support !