Thank you Rob again. regards Mario ----- Original Message ----- From: "Rob Baxter" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 30, 2002 3:00 PM Subject: RE: SQL server trouble
> If you are able to figure out what service is grabbing 1433 ahead of sql > server, I'd suggest changing the startup parameter for that service to > manual to allow sql to get it first. Of course you then have to remember to > manually start that other service after every reboot. > > </rob> > > -----Original Message----- > From: Mario Martinez [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 30, 2002 2:23 PM > To: CF-Talk > Subject: Re: SQL server trouble > > > Tony: > This file you are taking about does not contain any info about port 1433. > You can be sure I did a search in microsoft site before going to the list , > although I did not find the right keyword combinations at the begining . > After making a cousious search in the SQL Errorlog I found the right keyword > combination. > thanks friend > regards Mario > > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, May 30, 2002 2:11 PM > Subject: RE: SQL server trouble > > > > just out curiosity. I wonder, if the next time this happens, if you viewed > > the services file, (c:\winnt\system32\drivers\etc\services) if it would > tell > > you what is hooked on that port. if it does, then you know what app is the > > culprit. > > > > Anthony Petruzzi > > Webmaster > > 954-321-4703 > > [EMAIL PROTECTED] > > http://www.sheriff.org > > > > > > -----Original Message----- > > From: Mario Martinez [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, May 30, 2002 1:46 PM > > To: CF-Talk > > Subject: Re: SQL server trouble > > > > > > Thank you for your responses friends. > > I finally found the answer in www.microsoft.com in the troubleshouting > > section. > > The problem was that somehow one winsock service(as the port asiggment is > > dinamically on it) was steeling the 1433 port and SQL server could not > > listen in 1433 port. What I did was to stop all the services except the > > defaults, restart the SQL service and restart the others services again, > in > > this way SQL server takes this port firts. > > I have to work around it because it could happen again anytime > > I restart the machine. > > > > Thanks for your concern > > > > regards Mario > > ----- Original Message ----- > > From: "Rob Baxter" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, May 30, 2002 12:32 PM > > Subject: RE: SQL server trouble > > > > > > > check to make sure your SQL server is listening on tcp port 1433 (unless > > you > > > have changed the default port). You can either do a netstat -an from the > > sql > > > box or from the client machine try > > > > > > telnet sql-server-ip 1433 > > > > > > If you get a response your traffic is getting through. If not you've > > either > > > got something in the way (firewall) or a problem with your SQL network > > > libraries. I actually just had this problem yesterday so if that is it > > I'll > > > tell you what worked for me. Have you made any configuration changes to > > SQL > > > recently? > > > > > > </rob> > > > > > > -----Original Message----- > > > From: Mario Martinez [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, May 30, 2002 12:10 PM > > > To: CF-Talk > > > Subject: SQL server trouble > > > > > > > > > Hi all friends: > > > > > > I got a coldfusion system with an SQL server . Today I came in here and > I > > > realize that I can't connect this SQL server from any other computer > > through > > > ODBC . I could do that before , now none of my remotly ODBC connections > > are > > > working > > > This is the error I receive when I try to connect remotly: > > > 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: 11 > > > [Microsoft][ODBC SQL Server Driver]General network error. Check your > > network > > > documentation. > > > > > > Any ideas will be more than appreciate. > > > regards > > > Mario > > > > > > > > > > > > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
