impersonation for specific username and password

Question

impersonation for specific username and password

mtl20144102

Old Hand

Points: 394
More actions
October 26, 2018 at 3:25 pm

#366928

How do you set up impersonation for a specific username and password in sql server 2016 for windows authentication? It's to setup impersonation in an SSAS project.

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

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

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 1

mtl20144102 - Friday, October 26, 2018 3:25 PM
How do you set up impersonation for a specific username and password in sql server 2016 for windows authentication? It's to setup impersonation in an SSAS project.

I know little of SSAS but I came up with the following Google search in just a minute or two. It seems like it may cover it for you.
https://www.google.com/search?q=using+effectiveusername+to+impersonate+in+ssas

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

mtl20144102 Old Hand Points: 394 More actions · Answer 2

This is the option I want to use for SSAS but I'm getting invalid username or password. This is what I have when I sign into SSMS. How do you set it up in SSMS?

Thom A SSC Guru Points: 99130 More actions · Answer 3

Does that user have an login on SSAS? They are different to those on the Data Engine. I would suspect that the login does not.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk