We help IT Professionals succeed at work.

Cannot make ODBC Connection to SQL 2008 on named instance over firewall

rsilver24
rsilver24 used Ask the Experts™
on
Hi I am having an issue making an ODBC connection to my SQL server from a server in my DMZ over the firewall.  I have configured the named instance to use a different port.  I can telnet to that server and port on my server in the DMZ, but I cannot make an ODBC connection.  Any idea what else needs to be configured?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
If you ca Telnet then the firewall is not a problem.

Make sure in the DNS you are creating you use sql native client and pass the correct user name and password.

Also if you are using Integrated security -make sure the logegd in windows user has permissions on the sql server.you can verify this by checking on the sql server,the security tab and looking at users.

Author

Commented:
Thank you.  Installing the SQL Native client fixed this issue