I am trying to connect to SSAS tabular cube. Below are details
1) Mine is standlone system.
2) For login to system no Domain required.
3) Sql server is also installed on same machine. I am able to connect and browse the cube
4) I am able to connect to Sql server database using Enterprise gateway.
a) I am not able to connect to SSAS cube using Analysis service Connector because of 'Effective User Name mismatch' error.
b) If I am trying to connect through Enterprise gateway, it is not connecting. Might be because no domain configured.
Anyone, please advice.