I have two webservers (IIS) in front of two SQL servers. The CSS load-balances between both webservers then sticks the client to either webserver. The webserver turns around and queries the SQL database to provide the information back to the client. Stickyness is required between the client, the webserver and the SQL server. I can get the client to stick to the webserver and I can get the webserver to stick to the SQL server but I do not know how to stick the client to the SQL server (double stickyness).
1- Is it feasible?
2- How do I parse through SQL code to find the session ID and use it for stickyness?