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
Does 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" 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
