Thanks for the ideas Dave. I double-checked the SQL login - that's what I'm using in enterprise mgr. TCP/IP is also already enabled - I really thought that would be the solution earlier...
Doesn't enterprise mgr use port 1433 just like CF? What does CF do differently from enterprise mgr or the System DSN console in establishing database connections? I'm puzzled. -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 12:49 PM To: CF-Talk Subject: RE: setting up network data source > On my dev machine, I can successfully set up a System DSN > using Win XP's admin tools. > > On my dev machine, I can successfully connect to the database > using Enterprise Mgr. > > On the remote server, I can successfully create a datasource > in CF Administrator to this database locally. > > On my dev machine, I cannot create a data source in CF > Administrator. It times out trying to establish a connection. Are you sure you're connecting using a native SQL login when you're using Enterprise Manager? If so, perhaps you're connecting via Named Pipes instead of via TCP/IP. Make sure that your SQL Server is configured to accept TCP/IP connections. You can do this using the Server Network Utility from the server console. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231290 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
