December 10, 2014 at 8:07 am
Hi
Really hope someone can point me to a solution since I have looked everywhere and still no idea
If I log on to the SQL server and using IE go to http://sql1/reportServer I see the reportServer webpage just fine.
However if I go to another server in the same domain and do exactly the same thing (same user account, same URL) I get a windows box asking for username and password. It doesn't matter what username I use I still get prompted for username and password.
I've looked in the sys.dm_exec_connection and it says NTLM so I am guessing that SPN are not the cause.
We have another SQL instance on the same SQL server and you can reach the reporting webpage just fine no matter where you are.
The only thing I have noticed different is the working instance has login for DPM$ (being a DPM instance) but the default instance does not have a SQL1$ entry. Don't know if that is important.
Does anyone have something I can try. It really beats me why it would locally but not remotely.
Thanks
Laurie
December 10, 2014 at 8:16 am
what's the authentication mode in the reportserver.config file?
If it says NTLM in sys.dm_exec_requests, it's possibly "fallen back" to it because it failed the Kerberos reqs. I had the same challenge/response box and setting up an SPN for the report service URL worked in my case.
December 10, 2014 at 3:31 pm
Hi
And thanks heaps. Yes this was the answer.
I had to add both the FQDN and the NETBIOS entries and rebooted SQL server.
More study for me
Cheers
Laurie
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply