> I'm trying to setup an odbc connection from a webserver on > the DMZ to one of our SQL servers(2kSP1) but cant, I can > ping and telnet into SQL Server from the webserver.
Is the SQL Server configured to allow connections via TCP/IP, as opposed to Named Pipes, which may use NetBIOS over TCP/IP? What port is the SQL Server configured to listen on? The default is 1433. Did you configure the ODBC client to use TCP/IP? You can do that within the ODBC Control Panel. Is traffic to port 1433 allowed through the firewall to the database server? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists