Why can't I connect to analysis services from ssms?

Adam Garcia 0 Reputation points
2024-03-05T20:42:07.4366667+00:00

I am getting the below error. Is there something I am missing?

Unable to obtain authentication token using the credentials provided. (Microsoft.AnalysisServices.AdomdClient)


There was an error parsing WS-Trust response from the endpoint. This may occur if there is an issue with your ADFS configuration. See https://aka.ms/msal-net-iwa-troubleshooting for more details. Error Message: Federated service at https://autologon.microsoftazuread-sso.com/hebmex.com/winauth/trust/2005/windowstransport?client-request-id=be14d818-e5ab-476d-8d70-ea848665328c returned error: <S:Envelope xmlns:wsa="http://www.w3.org/2005/08/addressing" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" xmlns:wst="http://schemas.xmlsoap.org/ws/2005/02/trust" xmlns:S="http://www.w3.org/2003/05/soap-envelope">

<S:Header>

<wsa:Action S:mustUnderstand="1" wsu:Id="Action">http://schemas.xmlsoap.org/ws/2005/02/trust/RSTR/Issue</wsa:Action>

<wsa:To S:mustUnderstand="1" wsu:Id="To">http://schemas.xmlsoap.org/ws/2004/08/addressing/role/anonymous</wsa:To>

<wsse:Security S:mustUnderstand="1">

  <wsu:Timestamp wsu:Id="TS" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">

    <wsu:Created>2024-03-05T20:34:58.0736711Z</wsu:Created>

    <wsu:Expires>2024-03-05T20:39:58.0736711Z</wsu:Expires>

  </wsu:Timestamp>

</wsse:Security>

</S:Header>

<S:Body xmlns:S="http://www.w3.org/2003/05/soap-envelope">

<wst:RequestSecurityTokenResponse xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" xmlns:wst="http://schemas.xmlsoap.org/ws/2005/02/trust">

  <wsp:AppliesTo>

    <wsa:EndpointReference xmlns:wsa="http://www.w3.org/2005/08/addressing"></wsa:EndpointReference>

  </wsp:AppliesTo>

  <psf:pp xmlns:psf="http://schemas.microsoft.com/Passport/SoapServices/SOAPFault">

    <psf:reqstatus>0x8004882c</psf:reqstatus>

    <psf:errorstatus>0x80045b00</psf:errorstatus>

  </psf:pp>

</wst:RequestSecurityTokenResponse>

</S:Body>

</S:Envelope> (Microsoft.AnalysisServices.AdomdClient)


Federated service at https://autologon.microsoftazuread-sso.com/hebmex.com/winauth/trust/2005/windowstransport?client-request-id=be14d818-e5ab-476d-8d70-ea848665328c returned error: <S:Envelope xmlns:wsa="http://www.w3.org/2005/08/addressing" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" xmlns:wst="http://schemas.xmlsoap.org/ws/2005/02/trust" xmlns:S="http://www.w3.org/2003/05/soap-envelope">

<S:Header>

<wsa:Action S:mustUnderstand="1" wsu:Id="Action">http://schemas.xmlsoap.org/ws/2005/02/trust/RSTR/Issue</wsa:Action>

<wsa:To S:mustUnderstand="1" wsu:Id="To">http://schemas.xmlsoap.org/ws/2004/08/addressing/role/anonymous</wsa:To>

<wsse:Security S:mustUnderstand="1">

  <wsu:Timestamp wsu:Id="TS" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">

    <wsu:Created>2024-03-05T20:34:58.0736711Z</wsu:Created>

    <wsu:Expires>2024-03-05T20:39:58.0736711Z</wsu:Expires>

  </wsu:Timestamp>

</wsse:Security>

</S:Header>

<S:Body xmlns:S="http://www.w3.org/2003/05/soap-envelope">

<wst:RequestSecurityTokenResponse xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" xmlns:wst="http://schemas.xmlsoap.org/ws/2005/02/trust">

  <wsp:AppliesTo>

    <wsa:EndpointReference xmlns:wsa="http://www.w3.org/2005/08/addressing"></wsa:EndpointReference>

  </wsp:AppliesTo>

  <psf:pp xmlns:psf="http://schemas.microsoft.com/Passport/SoapServices/SOAPFault">

    <psf:reqstatus>0x8004882c</psf:reqstatus>

    <psf:errorstatus>0x80045b00</psf:errorstatus>

  </psf:pp>

</wst:RequestSecurityTokenResponse>

</S:Body>

</S:Envelope> (Microsoft.Identity.Client)


BUTTONS:

OK


Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
438 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,245 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Greg Low 1,495 Reputation points Microsoft Regional Director
    2024-03-05T23:02:34.99+00:00

    Very similar issue being dealt with in this article, along with steps to resolve: https://learn.microsoft.com/en-us/microsoft-365/troubleshoot/sign-in/federated-users-sign-in-error-ad-fs

    0 comments No comments