Link to home
Create AccountLog in
Avatar of mwagoner_73
mwagoner_73Flag for United States of America

asked on

How do i setup with ODBC connection

I am trying to establish an ODBC connection from our home office to a SQL database on a hosted server @ Rackspace.  I can ping the server but can not establish the connection.  User generated image
Avatar of Fabrice Lambert
Fabrice Lambert
Flag of France image

How do you etablish the connection (give as much details as possible) ?
Do you have any rights on the server ?
Please tell me you're going across a VPN, and not sending this traffic across the Internet unencrypted.

Either way, make sure whatever firewalls are between you and the SQL database allow traffic on port 1433.  You may need others, depending on how you're set up and what your SQL Server is doing.
Avatar of Fay A
Fay A

Have you tried connecting by an IP address instead of DSN name?
Avatar of mwagoner_73

ASKER

I have tried connecting to the IP when connected to the VPN and it returns the same error message.  I can not seem to get port 1433 opened up on the server which maybe the issue??  trying to connect using the SA account... this is SQLExpress (if that matters).
With the VPN up, can you ping the IP address?
yes, we can ping the IP successfully
Then it's very likely a firewall/filtering problem.
Very likely a firewall issue. SQL Express usually does not run on port 1433. Instead, UDP 1434 is used to ask for the real port, if you provide an instance name. And that dynamic port might not be set up to allow passing the firewall.
So how would i go about setting up that dynamic port?
I think I got the dynamic port setup...when I try to run through the ODBC connection over the VPN I am still getting errors... see attached screenshots
User generated imageUser generated imageUser generated imageUser generated imageUser generated image
ASKER CERTIFIED SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account