SSAS without AD - It's possible?

Question

Post reply

SSAS without AD - It's possible?

tomaszfilipek

SSC Enthusiast

Points: 150
More actions
May 2, 2018 at 1:05 am

#337431

Hello.
I have not AD in my network.
Is there any way to use SSAS in this case?
I can't found other way to login than Windows Authentication.
Thanks.
Regards.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Rick-153145 SSCrazy Points: 2823 More actions · Answer 1

Yes, its possible

https://stackoverflow.com/questions/626078/analysis-services-only-windows-authentication

tomaszfilipek SSC Enthusiast Points: 150 More actions · Answer 2

Thanks for You answer.

I tried run SSMS as user from MS SQL server:

But in SSMS still have user from local computer:

Ant-Green SSC Guru Points: 113507 More actions · Answer 3

You will need to run SSMS in the security context thats running the SSAS services, to trick SSMS and SSAS into thinking your logged in as the service account.

What service is SSAS running under? Network Service / Local System, run SSMS as that account and it should let you connect.

tomaszfilipek SSC Enthusiast Points: 150 More actions · Answer 4

I found solutions.

The shortcut should look like this:

C:\Windows\System32\runas.exe /savecred /user:ComputerName\UserName "cmd /c \"C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe\""