AnsweredAssumed Answered

RSA AM 8.1 connect to PostgreSQL database

Question asked by Mike Gercevich on Apr 27, 2017
Latest reply on Apr 27, 2017 by Mike Gercevich
Branched to a new discussion

I am trying to establish a connection from a remote server to execute SQL queries against the RSA AM 8.1 SP1 database using the open source ADO.Net provider from Npgsql

 

I am attempting to open the connection with the following connection string:

"Host=rsaserver.company.com;Port=7050;Database=db;Username=rsa_dba;Password=xxxxxxxxxx;SSL Mode=Require;Trust Server Certificate=True"

 

On Connection.Open(), I receive the following exception:

"No connection could be made because the target machine actively refused it"

 

I am able to execute queries over an SSH connection using the identical User/Password with the local rsautil utility. Is there some configuration that needs to be changed to allow the PostgreSQL SQL server to accept connections remotely? Is the rsa_dba account forbidden to connect remotely? I am attempting to mimic the functionality found in the SDK's SQLSample.vbs example script. Has anyone else been able to get this working?

Outcomes