Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

On premise data gateway, invalid username or password error for SSAS

Hi everyone,

 

I try to make a connection to my SSAS cube via Standard on-premise data gateway and I always get an invalid username or password error!

 

Here are the configuration that I did after reading troubleshooting doc:

 

  1. The gateway service run with my windows account, this acccount is administrator on the server.
  2. My UPN and windows account are set correctly in our organization AD. TGGAU is set correctly for our domain.
  3. The command "whoami /upn" return the good email adress used to connect to PowerBI service.
  4. The SSAS server belong to the organization domain.
  5. All the other connection type like Sql server, Excel file are working properly.
  6. We use Sql Server 2019 Enterprise version.
  7. When I try to run a report (with SSAS as datasource correctly configured) in Power BI service, I see the trace on SSAS (profiler) and I see that the NTDomainName and NTUserName are passed correctly to SSAS, but an invalid username or password message is generated.
  8. In SSAS, my account is a server administrator and I add the account as full control role for the SSAS database.
  9. We use a specific port to access the SSAS server, not the default one.
  10. In SSMS, when I try to connect to SSAS with the Additionnal Connection Parameters : [email protected], I am not able to connect, it generate the same error as I have with the gateway.

What am i missing? It's been quite a while that I am trying to figure out what I do not do correctly.

 

Thank you for your help, 

Gervais.

 

Connection error to Analysis server
On-Premise Data Gateway
SSAS

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi FarhamAhmed,

      Thanks for your response. I appreciate.

       

      Yes I did. I verified every aspect included in this article, listen to both video. 

       

      I also change the Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config file

      to set the ADUserNameLookupProperty and the ADUserNameReplacementProperty with my email-UPN has describe in the document without any success. The only thing I did not do is to set a value for the ADServerPath. Since the AD name resolution is running, I do not think it has any effect with my problem.

       

      Any help will be welcome.

       

      Have a good day.

      Gervais.

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Paul,

      I did the mapping has you explain in your post.

      I am able to connect to my SSAS server with my account Domain\Username when using SSMS.

      When I verify the log of the on-premise data gateway, my doman\username is passed correctly in the connection string. 

      Still having the problem!

      Thanks for your post.

      G.