Deployment to Azure Analysis Services erroring out for on-Premises data source

Question

I'm trying to connect to an on-Premises data source while deploying a tabular model to Azure analysis services. I have configured the gateway. While deploying, below is the error:

DM_GWPipeline_Gateway_DataSourceAccessError
Received error payload from gateway service with ID 510657: Error creating OLE DB row set..
Error creating OLE DB row set.
Error logging on user '<pi>[myuserid]</pi>'.
Logon failure: the user has not been granted the requested logon type at this computer*

I'm otherwise able to log into the server using the same ID. Could you please help me with the error?

Answer 1

Hi @Azure-Data-Guy ,

Thank you for posting query in Microsoft Q&A Platform.

Could you please check below document and try to grant the Right logon locally and see if that helps.
Grant a Member the Right to Logon Locally.
https://learn.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-r2-and-2008/ee957044(v=ws.10)