I have configured Web farm for dot net websites using network share path on 10 servers , the aim behind this is to get latest code / uploaded files available on all servers at the same time and all servers communicate with db server using windows authentication , of course this I have used three different NIC so as to divide traffic.
Al was working fine and one fine day , on one web which was reports page we were getting error “Authentication failed”, so I tried lot but not getting the cause of error as nothing is getting written on Web servers Event log.
Now I thought of checking SQL server’s error log and in that I found “SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure [CLIENT: < IP of web server >]”
Here I got the hint to check that webserver of which IP has been written in SQL error log, taken remote of the webserver and opened IIS to see under which user the application pool is running and got the cause “ all webservers app pool was running under network service but on this it was running under windows local user “
The root cause was “password was expired for the user under which the app pool was running” once I reset the password wen went away and all was running fine.
Then I re-configured that app pool to run under network service so as to avoid such error in future too J