A useful trick if you're having this types of issue is to firstly ping the machine and then try telneting to the port.
telnet ip.add.ress.here 1433 The ping tells you the routing is fine, the telnet tells you whether it's a firewall issue. (Telnet also works with mail servers (port 110 pop, 143 imap, 25 smtp.) Glad you got it sorted, Jenny >>-----Original Message----- >>From: Paul [mailto:[EMAIL PROTECTED] >>Sent: 03 February 2006 23:26 >>To: CF-Talk >>Subject: RE: setting up network data source >> >> >>I fixed it... It was the security policy on the db server; I had enabled >>port 1433 but not the SQL Server listener... or something. I'm not very >>familiar with Win2k3's security config stuff just yet. >> >>Thanks again for your advice. >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231325 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
