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.  screenshot of error message
mwagoner_73Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Fabrice LambertFabrice LambertCommented:
How do you etablish the connection (give as much details as possible) ?
Do you have any rights on the server ?
0
Paul MacDonaldDirector, Information SystemsCommented:
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.
0
Fay ADBACommented:
Have you tried connecting by an IP address instead of DSN name?
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

mwagoner_73Author 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).
0
Paul MacDonaldDirector, Information SystemsCommented:
With the VPN up, can you ping the IP address?
0
mwagoner_73Author Commented:
yes, we can ping the IP successfully
0
Paul MacDonaldDirector, Information SystemsCommented:
Then it's very likely a firewall/filtering problem.
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
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.
0
mwagoner_73Author Commented:
So how would i go about setting up that dynamic port?
0
mwagoner_73Author 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
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.