F5 to load balance MS Sql Servers

Hi Aaron, Sorry to dredge up this old topic, but I'm dealing with the exact instance you describe here with the .NET connection pooling.

 

 

"You can configure LTM to send a TCP reset if the selected pool member is marked down. This can be configure in the pool properties under 'Action on Service Down'. "

 

 

I've tried each of the options in "Action on Service Down", Reject, Drop and Reselect, but with each one there is still a failure on the next request from the connection pool. If I had control of the .NET code accessing the server I could just add a retry block, but that's not an option. Can you think of any other settings I might need to check, or other ideas to try?

 

 

Thanks in advance,

 

-Patrick