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 > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
