I have setup analysis services on iis following this guide: configure-http-access-to-analysis-services-on-iis-8-0 and have added iisClientCertificateMappingAuthentication on top. This works fine when accessing the website from Excel, PowerBI and SSMS. However when I want to extract data with the SQLServer powershell module via invoke-ascmd, I only get a error back that a connection to the server couldn't be made.
I have tried connecting to the server with the powershell module in various ways and right now I'm at the following point:
Client -> IIS Server : Works from Excel, PowerBI and SSMS, but not invoke-ascmd.
IIS Server -> IIS Server Public IP : Works from Excel, PowerBI and SSMS, but not invoke-ascmd.
IIS Server -> IIS Server 127.0.0.1 : Works from Excel, PowerBI, SSMS and invoke-ascmd.
So now I'm struggling with trying to figure out why only the SQLServer module is being denied when connecting to the public IP, but works on 127.0.0.1.