I have need your's help in how Web & Database load balancing work in windows server 2008. We are using MS SQL 2008 STD for database & MS Windows 2008 ENT for web server.
For 1 Web server & 1 DB server there is no problem. EX:- Now we have 20 Web server with photos, Videos, Files etc.. & 8 DB server with database. We are giving DB server access from Web server only. My problem is when user visit our site then he goes to login page how we need to send that user to where his data located in DB & Web server.
I request you all please help he. If you know any thing please reply me.