I just wrapped up a case for an issue I see every once and a while. The scenario is the following:
I’ve seen where some people go into Kerberos troubleshooting mode, but that in itself is not a Kerberos issue. The pattern for a normal Kerberos issue would be the following:
So, for this particular issue, the answer lies in the URL. More specifically in the Host of the URL.
If Internet Explorer detects periods within the Host Name, it will automatically force you into the Internet Zone.
If we were to just browse to the Netbios name as opposed to the Fully Qualified Domain Name (FQDN), we would see a different zone. Usually Local Intranet. The problem with the Internet Zone is that it will not automatically log you into the web site:
The fact that a Netbios will put you into the Intranet Zone allows for the automatic login to work. I thought we actually had this documented in the Reporting Services Books Online documentation, but looking for it, I was not able to find it.
So, if you are getting prompted for Credentials, as yourself if you getting to the web site or not. If you do get through to the web site, chances are you may be hitting this issue, although that could happen for different reasons. The main thing is that it is probably not a Kerberos issue, which is how this issue was presented to me.
So, we have identified that you have periods in your host name for the URL. How do we get rid of the prompts? You have a couple of options. Each with their pro’s and con’s.
There are probably other options as well, but these are probably the most obvious from my perspective. Hopefully this will help some people who hit this issue.
Adam W. Saxton | Microsoft SQL Server Escalation Services
https://twitter.com/awsaxton
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.