cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
malizahid52
New Member

Cant connect to SQL Server Analysis Services with On prem Gateway

Hello Guys ,

 

I am getting this error while connecting to SQL Server Analysis Services using On-Premisis Gateway . 

 

Something went wrong.
Technical details:
Activity ID: fcae60c8-64d5-cd7d-9445-78d966328574
Request ID: d922bd0b-1d72-58db-99f7-9be759c30e03
Date: 2016-08-21 19:07:07Z (UTC)
Error text: The following system error occurred: The user name or password is incorrect.
 
This seems strange to me as when i can go to manage gateway option and click   Test all connection , it says Online : you are good to go and when i click data source settings it says connection successfull . 

 
Analysis service also has the same domain account access and i am using the same domain account in data source settings .
1 ACCEPTED SOLUTION

Accepted Solutions
malizahid52
New Member

Re: Cant connect to SQL Server Analysis Services with On prem Gateway

Thank you ankit . i have solved this issue by map user names option in data source settings . my effective user name was not resolving exactly as my email address .

View solution in original post

5 REPLIES 5
ankitpatira Community Champion
Community Champion

Re: Cant connect to SQL Server Analysis Services with On prem Gateway

@malizahid52 Can you try changing from Basic to Windows and vice-versa authentication method and see if it works that way. In typical scenario you would have a service account created which you would use for this purpose as Basic authentication method.

malizahid52
New Member

Re: Cant connect to SQL Server Analysis Services with On prem Gateway

Thank you ankit . i have solved this issue by map user names option in data source settings . my effective user name was not resolving exactly as my email address .

View solution in original post

bestek1987
New Member

Re: Cant connect to SQL Server Analysis Services with On prem Gateway

Hello.
How do I do mapping?

bestek1987
New Member

Re: Cant connect to SQL Server Analysis Services with On prem Gateway

I have identical problem. How and where i can maped user.

Anonymous
Not applicable

Re: Cant connect to SQL Server Analysis Services with On prem Gateway

What about other users? I solved the problem - now I can view my published report, but the others can`t.

I have done the same with "map user names"

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.