RE: setting up network data source
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
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. -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 2:23 PM To: CF-Talk Subject: Re: setting up network data source I would still look into firewall issues...Named Pipes uses the same ports as File and Print sharing, so some firewall may be letting that through, but not 1433 (TCP). -jim On 2/3/06, Paul <[EMAIL PROTECTED]> wrote: > Both use the same port here. It must be to do with TCP, assuming the other > two are using named pipes. I'll see what I can stir up, I guess. Thanks > for taking some time on this. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231315 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
Re: setting up network data source
I would still look into firewall issues...Named Pipes uses the same ports as File and Print sharing, so some firewall may be letting that through, but not 1433 (TCP). -jim On 2/3/06, Paul <[EMAIL PROTECTED]> wrote: > Both use the same port here. It must be to do with TCP, assuming the other > two are using named pipes. I'll see what I can stir up, I guess. Thanks > for taking some time on this. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231305 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
RE: setting up network data source
Both use the same port here. It must be to do with TCP, assuming the other two are using named pipes. I'll see what I can stir up, I guess. Thanks for taking some time on this. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 1:53 PM To: CF-Talk Subject: RE: setting up network data source > 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. Enterprise Manager (and CF) use whatever port they're told to use. The default SQL Server listener is on TCP/1433. You would have to look in your Client Network Utility to see what you're actually using. Enterprise Manager and your System DSN could well be using Named Pipes instead of TCP/IP. 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:231302 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
RE: setting up network data source
> 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. Enterprise Manager (and CF) use whatever port they're told to use. The default SQL Server listener is on TCP/1433. You would have to look in your Client Network Utility to see what you're actually using. Enterprise Manager and your System DSN could well be using Named Pipes instead of TCP/IP. 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:231299 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
RE: setting up network data source
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
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:231286 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
RE: setting up network data source
Are you running SQL server on a standard port? Do you have some kind of firewall preventing access to the network for the cf service? Try running CF as a user or at least check 'allow to interact with desktop' checkbox. If you have any sort of firewall locally, disable it and see if that helps. Note, that windows SP2 comes with a firewall, and sometimes you might not even know that it's there and enabled. Russ > -Original Message- > From: Paul [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 12:39 PM > To: CF-Talk > Subject: RE: setting up network data source > > Sorry I didn't specify... SQL Server, yes. The server is using SQL > authentication, which works when I connect using enterprise mgr but not cf > admin. > > -Original Message- > From: John Beynon [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 10:23 AM > To: CF-Talk > Subject: Re: setting up network data source > > SQL server i guess? What authentication is the server using - NT > authenication or SQL authentication, that's usually the best place to > start looking. > > jb. > > On 03/02/06, Paul <[EMAIL PROTECTED]> wrote: > > I'm trying to connect my local CF instance to a database on another > server > > in my network, and I'm having trouble. Here's what I know. > > > > > > > > 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. > > > > > > > > I suspect I may be making a stupid mistake - does anyone spot it? > > > > > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231266 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
RE: setting up network data source
Sorry I didn't specify... SQL Server, yes. The server is using SQL authentication, which works when I connect using enterprise mgr but not cf admin. -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 10:23 AM To: CF-Talk Subject: Re: setting up network data source SQL server i guess? What authentication is the server using - NT authenication or SQL authentication, that's usually the best place to start looking. jb. On 03/02/06, Paul <[EMAIL PROTECTED]> wrote: > I'm trying to connect my local CF instance to a database on another server > in my network, and I'm having trouble. Here's what I know. > > > > 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. > > > > I suspect I may be making a stupid mistake - does anyone spot it? > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231262 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
Re: setting up network data source
SQL server i guess? What authentication is the server using - NT authenication or SQL authentication, that's usually the best place to start looking. jb. On 03/02/06, Paul <[EMAIL PROTECTED]> wrote: > I'm trying to connect my local CF instance to a database on another server > in my network, and I'm having trouble. Here's what I know. > > > > 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. > > > > I suspect I may be making a stupid mistake - does anyone spot it? > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231258 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
