i guess i will have to address this after the holiday since i am leaving for the rest of the week. thanks for your advice.
-----Original Message----- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 3:32 PM To: SQL Subject: RE: SQL Server connection thru CF Admin yes, same network, same submask. -----Original Message----- From: Jacob [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 3:29 PM To: SQL Subject: RE: SQL Server connection thru CF Admin Are the servers on the same network? same submask? At 03:11 PM 11/19/2001 -0500, you wrote: >oh, thing in my case is that i dont have access to the servers. > >-----Original Message----- >From: Jacob [mailto:[EMAIL PROTECTED]] >Sent: Monday, November 19, 2001 2:56 PM >To: SQL >Subject: RE: SQL Server connection thru CF Admin > > >I have got that error many times. It was either a routing issue with a >load balancer / firewall or choosing TCP/IP in client config. > >It is making a connection to the SQL server, but the connection is not >allowed access. > >Check passwords, stop and restart the CF Server or SQL Server, create a new >user in SQL with minimal rights like public and select only. > >At 02:48 PM 11/19/2001 -0500, you wrote: > >Um, no. Both servers not behind a firewall and no load balancing. > > > >-----Original Message----- > >From: Jacob [mailto:[EMAIL PROTECTED]] > >Sent: Monday, November 19, 2001 2:45 PM > >To: SQL > >Subject: RE: SQL Server connection thru CF Admin > > > > > >Are the CF servers behind and firewall or load balance? How about the SQL > >servers? > > > >Jacob > > > >At 02:38 PM 11/19/2001 -0500, you wrote: > > >Error Message: > > > > > >Connection Failed: > > >SQLState: '01000' > > >SQL Server Error: 10061 > > >[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen > > >(Connect()). > > >Connection Failed: > > >SQLState: '08001' > > >SQL Server Error: 17 > > >[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not > >exist > > >or access denied. > > > > > > > > > > > > > > >-----Original Message----- > > >From: James Taavon [mailto:[EMAIL PROTECTED]] > > >Sent: Monday, November 19, 2001 2:24 PM > > >To: SQL > > >Subject: RE: SQL Server connection thru CF Admin > > > > > > > > >Jacob, > > > > > >did that. no luck. > > > > > > > > > > > >-----Original Message----- > > >From: Jacob [mailto:[EMAIL PROTECTED]] > > >Sent: Monday, November 19, 2001 2:20 PM > > >To: SQL > > >Subject: Re: SQL Server connection thru CF Admin > > > > > > > > >When setting up using the ODBC Manager, try using the IP address and in > > >Client Configuration, choose TCP/IP. > > > > > >Let me know what happens. > > > > > >At 02:11 PM 11/19/2001 -0500, you wrote: > > > >Another question, > > > > > > > >Trying to connect CF to SQL Server, but keep coming up with "Failed". > >Tried > > > >doing it using ODBC Manager, but came up with an SQL Error 17. It also > >said > > > >my database id not exist. I dont understand that if I connect to it >using > > > >Enterprise Manager and am able to list tables and run queries from the > > > >environment. When creating the datasource I use the username and >password > > > >establish a connection. Any ideas on what I could be missing? > > > > > > > >James > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
