Unable to connect to Data Source when connect to VPN
When I connected to company VPN connection, I was unable to connect to the Data Source (SQL Server) which store my connections.
It gave me the following error:
InvalidOperationException - Invalid operation. The connection is closed.
Screenshots: https://imgur.com/g3rgClv
However, when I test the data source connection in General > Test Database, it said "Connection to the database successful!".
I also test the database connection with a DB Client "HeidiSQL", it was successful too. I can do queries and see the data with my AD account.
Please see the screenshots below
Is there any thing prevent the connect under VPN environment?
Thank you.
https://imgur.com/vfvvlGr (please copy and paste)
https://imgur.com/2Bdn9bS (please copy and paste)
All Comments (3)
Hello,
You connect successfully even with the VPN opened? It seems that a Firewall cut the connection to the database.
Regards
David Hervieux
Yes, data sources said connected successfully with VPN opened.
Is there any specific port used other than the usual SQLServer communication port 1433 needed? I tested the port in VPN environment and it was opened.
Hello,
I suspect that your VPN is blocking the communication with your SQL Server.
RDM use the same authentication method that Microsoft use in SQL Server Management Studio (SSMS).
Is it possible for you to install this application and try to authenticate on your database using SSMS when connected on the VPN?
Do you receive the same error message?
Best regards,
Jeff Dagenais