April 21, 2018 at 4:57 pm
We just offloaded SSRS onto its own machine. Ran into the typical Double hop issues. I verified the SPNs and delegation and everything was peachy from within the domain. However, We have an ASP web app in a DMZ off the domain that connects using domain credentials that is still having the double hop issues. For whatever reason, we can't change to SQL Server authentication. Is there a way to resolve this?
April 22, 2018 at 5:08 pm
you may be able to - but being a DMZ you probably should not anyway.
have a look at https://www.experts-exchange.com/questions/25053526/Passing-user-credentials-from-a-trusted-domain-through-SPN-and-Delegation.html. this contains other links that may help you on this issue.
and this one (and related) http://www.adopenstatic.com/cs/blogs/ken/archive/2008/06/28/17805.aspx
April 22, 2018 at 5:41 pm
I resolved this issue this morning. It was really the simplest most painfully obvious solution too. We simply created a second data source and used the domain credentials in question rather than using credentials passed by the user. This got around the double hop issue.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply