Our web server is on a different box than our SQL server. When I first set up the website, I could access it, but it wasn't passing the authenticated user credentials to our SQL server (as expected).
I did the
SETSPN -A configuration to add the SPN to our domain for the new website on the webserver (as we always do), and now the website is challenging for user id and password, but won't accept the credentials (3 times, then no access 401).
The website is configured for
Identity Impersonation and
windows authentication, just like the other 8 websites on the same server with the same configuration, that all work.
This only occurs on NEW websites, and usually, we have to reboot the server to fix it.
Any suggestions to get this to work with out a reboot?