aimshelpdesk
asked on
ColdFusion sql JDBC error
We are running coldfusion mx ver 7 and we connect to various MS sql 2000 servers running SP4 running on MS windows 2003 ENT.
The problem that we are having we we are getting the following error
[Macromedia][SQLServer JDBC Driver]Error establishing socket.
Address already in use: connect
I have not been able to reproduce this error on my pc but I have several other pc's that this is happening on a regular basis. We are also having this same issue now with some of our clients. In looking through the logs i am not finding anything of real value to help in diagnosing this issue. Any Ideas?
The problem that we are having we we are getting the following error
[Macromedia][SQLServer JDBC Driver]Error establishing socket.
Address already in use: connect
I have not been able to reproduce this error on my pc but I have several other pc's that this is happening on a regular basis. We are also having this same issue now with some of our clients. In looking through the logs i am not finding anything of real value to help in diagnosing this issue. Any Ideas?
Are the web servers and the DB servers in the same physical location? If not this might be a permissions issue. I am thinking of a similar issue I have seen with the 1433 port not being open on the firewall when the web and db server were not in the same location.
ASKER
The app dos have to connect through the firewall but it has been connecting through the firewall for some time now. What is making this more diffucult is that it dosen't happen all the time.
Did this start happening after SP4 went on the server. I googled this and found some refernces to that
ASKER
Yes it seems to have been happening on the SP4 servers. I havent found anything good searching on google.
There is not a lot of good info out there on this. It seems to point to an issue with SP4. I don't suppose that there is any chance of moving away from SP4..... ALthough this is prolly not a good idea.
We use BlueDragon JX 2 and we do not have this issue with our sp4 server.
We use BlueDragon JX 2 and we do not have this issue with our sp4 server.
ASKER
Removing a major sp on MS SQL is not something I would dare try.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.