Forum Discussion
Cannot connect with SSAS in Gateway
Hi
I've been tying to create a gateway to connect to a cube from SSAS but I cant, this is the problem
Im 100% rigth about the connections credentials. Im doing this becuause I cant connect from Desktop, so I readed that It is neccesary to create a Gateway... but... I cant...
PD: From Excel I CAN connect to that SSAS server.
4 Replies
AlejandroPCar,
What version of SSAS do you use? Are you able to connect to SSAS server from SQL Server Management Studio(SSMS) in the machine that installing gateway with same connection strings?
Besides, do SSAS server and gateway locate in same domain?
Regards,
LydiaAnonymous,
Hi, Im very new using SSAS so... hahahaha I dont understand much that you are asking, but I cant connect from SQL Management Studio, this is the result:Hope this can help us to understand what is happening
thanks for your response
AlejandroPCar,
This is a SSAS connection issue. It seems that you use unsupported authentication method to connect to SSAS, see https://social.technet.microsoft.com/wiki/contents/articles/15274.using-claims-authentication-across-the-microsoft-bi-stack.aspx.
In your scenario, please use Windows authentication to connect to SSAS database.
Regards,
Lydia
