ODBC Access to SQL Table

I need your help. I have a MS SQL Server in our DMZ that I need to setup an
MS Access ODBC connection to the SQL Server. I am using port 1433 opened on
the firewall but I can't bring up the SQL Server. Is there as way to
trouble shoot these issues or maybe a document on setting up ODBC
connections? I have no trouble within the LAN in our Active Directory.
Please help! Thanks
NC Beach BumDoes your SQL Server allow incoming connections for TCP/IP on port 1433.
Perhaps check your client configuration and make sure that it allows
incoming connections. If this is SQL 2005 you can use your surface area
configuration tool to make sure the protocol is allowed.
--
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"NC Beach Bum" <NCBeachBum@.discussions.microsoft.com> wrote in message
news:EBE2C819-A798-48BD-A179-B511C9D79B31@.microsoft.com...
>I need your help. I have a MS SQL Server in our DMZ that I need to setup
>an
> MS Access ODBC connection to the SQL Server. I am using port 1433 opened
> on
> the firewall but I can't bring up the SQL Server. Is there as way to
> trouble shoot these issues or maybe a document on setting up ODBC
> connections? I have no trouble within the LAN in our Active Directory.
> Please help! Thanks
> --
> NC Beach Bum