cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
RitaWK Helper III
Helper III

The on-premises data gateway's service account failed to impersonate the user.

The Microsoft troubleshooting page doesn't give enough information on how to fix this issue. We have been using the gateway for over a year with an admin account set up in the Gateway and all of the sudden, today it's failing with this error:

The on-premises data gateway's service account failed to impersonate the user.

Does anyone have more information that is NOT in the troubleshooting page on how to remedy this?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
RitaWK Helper III
Helper III

Re: The on-premises data gateway's service account failed to impersonate the user.

We solved the issue, somehow the environment changed and we had to do this- if this helps others having the same error:

For the delegation settings on the gateway service account,
Check 'Trust this user for delegation to specified services only'
And not 'Use Kerberos only' but 'Use any authentication protocol'

View solution in original post

1 REPLY 1
RitaWK Helper III
Helper III

Re: The on-premises data gateway's service account failed to impersonate the user.

We solved the issue, somehow the environment changed and we had to do this- if this helps others having the same error:

For the delegation settings on the gateway service account,
Check 'Trust this user for delegation to specified services only'
And not 'Use Kerberos only' but 'Use any authentication protocol'

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Kudoed Authors