Wish I can do that... have two servers not talking and leave for a week.... ;)
Sorry I could not be of much help. The connection is being established, just no being authorized by SQL... hmmm At 03:55 PM 11/19/2001 -0500, you wrote: >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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
