How do i setup with ODBC connection

mwagoner_73
mwagoner_73 used Ask the Experts™
on
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.  screenshot of error message
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Fabrice LambertConsulting
Distinguished Expert 2017

Commented:
How do you etablish the connection (give as much details as possible) ?
Do you have any rights on the server ?
Paul MacDonaldDirector, Information Systems

Commented:
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.
Fay ADBA

Commented:
Have you tried connecting by an IP address instead of DSN name?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
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).
Paul MacDonaldDirector, Information Systems

Commented:
With the VPN up, can you ping the IP address?

Author

Commented:
yes, we can ping the IP successfully
Paul MacDonaldDirector, Information Systems

Commented:
Then it's very likely a firewall/filtering problem.
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
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.

Author

Commented:
So how would i go about setting up that dynamic port?

Author

Commented:
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
protocols enabled and dynamic port set to 1433listening on port 1433odbc3.pngodbc2.pngodbc1.png
"Batchelor", Developer and EE Topic Advisor
Top Expert 2015
Commented:
Ok, it runs on port 1433. In that case you can  omit the instance name SQLEXPRESS, but it should not matter if you keep it.
Interestingly the netstat output shows port 1433 bound to 913208-paf-flex, and the 172.* address you used connected. Check that MSSQL is indeed bound to that address, and you are using the correct IP.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial