Hi all,
We are using a database connection defined on servicecenter to connect do our db2 database:
This connection works fine, but we were informed by our cibersecurity responsible that we are using not secure ports to connect do db2 database. This servicecenter configuration uses port 8471 instead of 9471 secure port.
Is it possible to force the database connection to use the secure port?We tried to use the advanced configuration with a connection string "DataSource=MyServerName:9471; Database=IASPQA; UID=username; PWD=password" and "DataSource=MyServerName; Port:9471; Database=IASPQA; UID=username; PWD=password" to force the secure port to be used, but we receive an error testing the database connection everytime we try to pass the port configuration (Connection String test failed: The ConnectionString property is invalid.).
If we test the connection without the Port configuration the connection is successful.
What should we do to configure the connection to use only the secure ports to connect to db2?
Thanks in advance,
Vitor Rocha
Hi Vitor,
have you seen on the database side in order to accept the connections throu the port number 9471?
From what you explain, from this perspective it looks that the connection string is not written correctly, it looks right but the machine is the boss.
Regards and hope that you can overcome this problem.
Hi @carl ruhle ,
Thanks for your reply.
The database accepts connections through the port 9471, the problem seems to be the format of the connection string.
When I try to pass the port in the connection string, even when I pass the port 8471 wich is the default, I receive a Connection string error.
I tried to pass the connection string with various formats, but whatever I try, the error is the same.
Hi @Vitor Rocha,
on the connection string I think this is missing
Security=SSL;
Regards