Link to home
Start Free TrialLog in
Avatar of RyanIrish
RyanIrish

asked on

ODBC to SQL server on different subnet

Hello,


I'm attempting to create an ODBC connection to a SQL server that is on a different subnet (connected via IPSec tunnel), but nothing I've seen suggested is working.


I have ODBC Driver 18 for SQL Server installed on the client, and as stated by many, the SQL server pool dropdown is empty.


I've tried manually entering the servername\instance and IP\instance, no luck.


I know the credentials I'm using are correct.


The error being thrown when I try to select the default database:

User generated image


I have no idea what to do with this...I don't run into this issue on any clients that are on the same subnet.


Thank you for any suggestions.




ASKER CERTIFIED SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RyanIrish
RyanIrish

ASKER

Thank you...setting the encryption to 'optional' worked!


User generated image