Most of the time I fixed it by changing from Name Pipes to TCP/IP, especially if the servers are on two different networks. Name Pipes are a little faster, but TCP/IP provides are more stable connection.
The load balance was another issue. Trying to load balance two SQL servers (both read only). Got it to work, but it was tricky. At 03:09 PM 11/19/2001 -0500, you wrote: >really? what did you do to solve it? different in each case? > >-----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 > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
