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?
You need a Read-Only Database user, which also opens up port 7050 in the firewall for remote access to PGSQL
000027335 - Connecting to or querying the RSA Authentication Manager 8.1 database using pgSQL