Here's my scenario
No AD anywhere (all standalone boxes)
I have an sql server database in a VM in azure. Windows Authentication only. This is my data source
It's a standalone box. I can connect to it using windows authentication by using "RUNAS /netonly /user:VMNAME\MyUserName" with both SSMS and SSDT
I have SSAS installed locally.
I want to deploy a cube locally that connects to the database but I'm not sure how i'm supposed to setup the data source. I've put in VNMame\MyUserName as the impersonation details but to no avail
Error msg from the sql database engine on the azure VM is
Message
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Could not find a login matching the name provided. [CLIENT: my.ip.add