cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User II
Super User II

Error 1069 - On Premises Data Gateway Service wont' start - logon failure

I have the On Premises Gateway installed on a Windows 7 PC. Not in personal mode.

 

It works fine until I do something as simple as run Windows Update and apply patches.

 

Then on the reboot, the service refuses to log in, with error 1069 in the event log and when I try to manually restart it.

 

It is configured with the default NT Service\PBIEgwService account that it installs with. That works fine.

 

The only fix is to uninstall, reinstall, and then select the "migrate/restore/takeover" gateway option.

 

Is there anything I am doing wrong to cause this? Is there any way to repair this without the lengthy uninstall/reboot/reinstall/takeover process? This is getting tiresome.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
3 REPLIES 3
Moderator v-yuezhe-msft
Moderator

Re: Error 1069 - On Premises Data Gateway Service wont' start - logon failure

@edhans,

Please help to post the gateway service logs which locate in C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log.

I’m not sure if the patched Windows updates affect the gateway service. But when you get 1069 error, have you checked that if the NT Service\PBIEgwService account has Log on as a Service right? And are you able to start gateway service when you change the service account to administrator of your computer?
1.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User II
Super User II

Re: Error 1069 - On Premises Data Gateway Service wont' start - logon failure

Thanks Lydia. I have bookmarked this. When this happens again, which could be tomorrow or mid-December, I will definitely get the logs. The logs were delted when I uninstalled and removed everything before reinstalling.

 

I will also see if the PBIEgwService is somehow being denied the "log on as a service" right after an update. I tend to think that might be the problem and will test before I reinstall.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
qb359
New Member

Re: Error 1069 - On Premises Data Gateway Service wont' start - logon failure

I have this issue as well. So far the only "fix" I have found is to open services.msc, open the 'PBIEgwService' service and retype my password. This lets you not have to reinstall the entire gateway but still not a true fix. I'm still searching for a better fix than this. I'll keep you updated. 

 

See this link:

 

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/49fa7a85-f522-4fdf-beb4-6e270a3fc047/error-...

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.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors