Forum Discussion

mgarrettdev's avatar
mgarrettdev
New Member
6 years ago

Azure Analysis Services Can't Connect to On-Premises SQL Server using Data Gateway

Hello,

 

Here is my situation:

 

I have an Azure Analysis Services Tabular Model deployed and have configured an On-Premises Data Gateway to refresh the data from an on-premises SQL Server. Both the Tabular Model and the AS Model reside in the same region (North Central US) and are configured correctly (a green check mark is present) but I am receiving the following error:

 

The JSON DDL request failed with the following error: Failed to save modifications to the server. Error returned: 'An error occurred during On-Premise Gateway related activity. Additional error details: DM_GWPipeline_Gateway_MashupDataAccessError
Received error payload from gateway service with ID 2912898: Async operation 1188e867-3bf0-4f6b-86d9-0163e645a004 is faulted with [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessException: MashupException encountered while accessing the target data source.

GatewayPipelineErrorCode=DM_GWPipeline_Gateway_MashupDataAccessError
GatewayVersion=3000.40.15 --->
[1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: InternalMashupException:<pi>Microsoft.Data.Mashup.InternalMashupException (0x80004005): We're sorry, an error occurred during evaluation. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: The user name or password is incorrect.
---> Microsoft.Mashup.Evaluator.Interface.ErrorException: The user name or password is incorrect.
---> Microsoft.Mashup.Evaluator.Interface.ErrorException: The user name or password is incorrect.
---> System.Security.SecurityException: The user name or password is incorrect.
---> System.Security.SecurityException: The user name or password is incorrect.

at System.Security.Principal.WindowsIdentity.KerbS4ULogon(String upn, SafeAccessTokenHandle& safeTokenHandle)
at System.Security.Principal.WindowsIdentity..ctor(String sUserPrincipalName, String type)
at System.Security.Principal.WindowsIdentity..ctor(String sUserPrincipalName)
at Microsoft.Mashup.Engine1.Runtime.CredentialExtensions.GetImpersonationWrapper(String username, String password, IEngineHost host, IResource resource)
at Microsoft.Mashup.Engine1.Runtime.CredentialExtensions.GetImpersonationWrapper(IResourceCredential credential, IEngineHost host, IResource resource)
at Microsoft.Mashup.Engine1.Library.Common.SqlResourceCredentialDispatcher.Apply(WindowsCredential credential)
at Microsoft.Mashup.Engine1.Library.Common.SqlResourceCredentialDispatcher.Apply(ResourceCredentialCollection credentials)
at Microsoft.Mashup.Engine1.Library.Common.ConnectionStringResourceCredentialDispatcher.ConstructConnectionString(String server, String database, ResourceCredentialCollection credentials, Nullable`1 connectionTimeout)
at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.CreateConnectionInfo()
at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.get_ConnectionInfo()

 

 

 

My windows account that I am using to try to process the model has admin access to the backend database so that is not the issue. I am not sure what I am missing.

 

Any help would be greatly appreciated,

 

MGDev

2 Replies