Impersonation in SSAS Data Source

Impersonation Tab
Impersonation Tab


We are gonna discuss about the use of Impersonation tab in Data Source wizard of SSAS solution in this post. First lets discuss about WHY we need to impersonate and then different types in which we can impersonate.

When we design a  cube in which data source is using windows authentication then it will be executed as current user. But, when you deploy the database to the server there will be no current user. In this case when a user requests AS to process an object it needs to know under what security context to connect to the data source. Essentially you need to get the AS service to impersonate another user in order to retrieve data from an external source on a user’s behalf.

There are FOUR types available in which you can impersonate Data Source.

1) Use a specific Username and Password.

2) Use the Service Account.

3) Use the credentials of the Current User.

4) Inherit (in SQL 2008 and above)/ Default (SQL 2005).

Now lets see where you can provide this impersonation information in SSAS Solution.

1) Open New Solution.

2) Add New Data Source.

3) Provide Database connectivity Details.

4) After providing data source details if you click on next then you can see a Wizard page to provide impersonate info for the data source as shown below.


Impersonation Tab
Impersonation Tab

Now lets see in detail the use of each impersonation type.

 Use a specific Username and Password – 

Select this option to have the Analysis Services object use the security credentials of a specified Windows user account.

• User name – Type the domain and name of the user account to be used by the selected Analysis Services object. The domain and name of the user account uses the following format:
<Domain name>\<User account name>
• Password – Type the domain and name of the user account to be used by the selected Analysis Services object.

When Analysis Services account does not have relational data base access then Use Specific User Name and password option is used.
Specific user name and password is passed to analysis server but it will be encrypted due to security. Example like when the data sources are like –
1) OLE DB/Microsoft Directory Services
2) SQL Server Compact Edition

Use the Service Account – 

Select this option to have the Analysis Services object use the security credentials associated with the Analysis Services service that manages the object. The service account credentials will be used for processing, ROLAP queries, remote partitions, linked objects, and synchronization from target to source. For DMX OPENQUERY statements, local cubes, and mining models, the credentials of the current user will be used. This option is not supported for out-of-line bindings.

Service Account
Service Account

“Use the Service Account” option is mostly used by developers. In this, Analysis Services startup account information will be used to connect relational database.

 Use the credentials of the Current User – 

This is similar to the first option what we discussed i.e Specify a user account. If you selects this option then it will take the current logged in user details. Remember that this option is not supported for processing, ROLAP queries, remote partitions, linked objects, and synchronization from target to source.

Default/Inherit – 

Analysis services will have Service Account and User Account. If you select this option then it will take the  details of default user account . This option uses the default setting for the database for processing objects, synchronizing servers, and executing the OpenQuery data mining statements.

So guys, based on requirement Pick the best one that suits you. Happy Coding !!


Roopesh Babu V


  1. Regards, Very good information!
    [url=]buy phd dissertation[/url] mba dissertation writing services uk [url=]dissertation service[/url] dissertation proposal timeline

  2. Many thanks! Good stuff.
    [url=]benefits of paying somebody to do my homework[/url] someone do my homework online [url=]how do you say do my homework in spanish[/url] how do you say i do my homework in spanish

  3. You actually stated it superbly!
    [url=]help with masters dissertation[/url] dissertation writers in uk [url=]research proposal dissertation[/url] dissertation writing help uk

  4. Thanks, Plenty of information!
    [url=]good thesis[/url] service quality and customer satisfaction questionnaire thesis [url=]thesis[/url] history paper thesis

  5. Nicely put. With thanks.
    [url=]writing a personal essay[/url] american essay writers [url=]essay paper writer[/url] can someone write my essay for cheap

  6. You said it very well.!
    [url=]essay homework help[/url] essay writing helper [url=]writing help[/url] help writing essays for college

  7. You made your position very well!!
    [url=]how to write an analysis paper[/url] write my college paper [url=]college papers for sale[/url] write my paper co

  8. You definitely made your point.
    [url=]best site to buy research papers[/url] research proposal apa [url=]research papers to buy[/url] cheap custom research paper

  9. You’ve made your position quite nicely!.
    soaring eagle online casino michigan [url=]riversweeps online casino login[/url] online casino gambling

  10. Superb material. Thanks.
    [url=]australian essay writing service[/url] writing services [url=]cheap essay service[/url] smart writing service

  11. Fine postings. Thanks a lot!
    [url=]essay writing service reviews[/url] writing an argumentative essay [url=]paper writing services legitimate[/url] best essay service

  12. Thank you, Valuable stuff.
    [url=]pay someone to write an essay[/url] pay to have an essay written [url=]can i pay someone to write my essay[/url] buy essay for college

  13. You mentioned this superbly.
    [url=]thesis writing service[/url] community service thesis statement [url=]define thesis statement[/url] thesis in an essay

  14. Thanks. Loads of material.
    [url=]bestdissertation[/url] phd proposals [url=]phd dissertation help[/url] nursing dissertation help

  15. Really quite a lot of fantastic data!
    [url=]order admission essay[/url] buy essay for college [url=]pay for essay[/url] buy essay online review

  16. This is nicely put! .
    [url=]essay writers online[/url] paper writer [url=]essay writter[/url] online essay writer

  17. This is nicely expressed! !
    [url=]write my paper reviews[/url] write my paper [url=]research paper writers[/url] paper writer service

  18. Cheers, A lot of information!
    [url=]doctoral dissertation help usa[/url] dissertation editors [url=]dissertation express[/url] writing dissertation service

  19. Kudos. Plenty of stuff!
    [url=]term paper help[/url] buy research paper [url=]research paper writer[/url] proposal writing

  20. You actually expressed that exceptionally well.
    [url=]phd dissertation help[/url] what is a phd [url=]writing dissertation[/url] dissertation writing service

  21. Regards, Plenty of posts!
    [url=]essay writing website[/url] writing service essay [url=]legit essay writing service[/url] cv writing service

  22. Valuable stuff. Regards!
    [url=]dissertation editing services[/url] phd thesis [url=]what is a phd[/url] dissertation service

  23. Nicely put. Thanks a lot!
    [url=]do my essay free[/url] who can write my essay [url=]write a essay[/url] website that writes essays for you

  24. You actually reported this well!
    [url=]dissertation writers[/url] buy dissertations [url=]phd dissertation help[/url] best dissertation

  25. Information clearly regarded..
    [url=]writing dissertation[/url] phd paper [url=]phd paper[/url] dissertation proposal

  26. Many thanks, I appreciate this.
    [url=]pay someone to write my college essay[/url] pay for an essay [url=]pay for essays[/url] essay for sale

  27. You said it adequately.!
    [url=]write my paper reviews[/url] professional essay writers [url=]write paper for me[/url] how to write a philosophy paper

  28. You made your point pretty clearly!!
    [url=]pay for papers[/url] pay someone to write your paper [url=]buy a paper for college[/url] buy a paper for college

  29. You suggested it effectively!
    [url=]buy a paper for college[/url] pay to write paper [url=]pay someone to write paper[/url] buying papers for college

  30. A holistic approach to healthcare should consider factors such as the [url=]Accutane 30 mg price[/url] as part of treatment planning.

  31. Always finish a full course of [url=]doxycycline tablets canada[/url], even if symptoms have improved.

  32. Discussing [url=]modafinil 100mg price[/url] with your healthcare provider is an important step in managing your treatment and overall health.

  33. priligy generic canada [url=]can i buy dapoxetine over the counter[/url] dapoxetine india online

  34. You suggested it exceptionally well.
    [url=]buy essay[/url] pay someone to write paper [url=]buy essay online[/url] buy an essay online

  35. Don’t let your patients suffer from thyroid hormone deficiency, prescribe [url=]137 mg Synthroid[/url] today!

  36. generic cymbalta best price [url=]cymbalta 30 mg capsule[/url] cost of cymbalta without insurance

  37. Tips clearly taken..
    [url=]thesis titles[/url] argumentative thesis statement [url=]a good thesis statement[/url] working thesis

  38. Nicely put, With thanks.
    [url=]essay bot[/url] help essay [url=]help me write my essay[/url] essay writer

  39. Very good data. Thanks!
    [url=]write a research paper[/url] write my paper for me [url=]paper writing[/url] essay writter

  40. You actually revealed that really well.
    [url=]write my paper for me free[/url] essay writer [url=]professional essay writers[/url] writing a good essay

  41. Thanks a lot! I enjoy this!
    [url=]paper help[/url] custom research paper writing services [url=]paper writing service[/url] pay someone to write your paper

  42. Incredible all kinds of very good advice!
    [url=]admission essay writing service[/url] essay review service [url=]writing an opinion essay[/url] essay writing service cheap

  43. Thanks a lot. I like it!
    [url=]pay someone to write paper[/url] buy essays [url=]pay for essays[/url] pay to write my essay

  44. Great advice. With thanks!
    [url=]dissertation[/url] dissertation writing services [url=]dissertation service[/url] dissertation paper

  45. Kudos. I appreciate this!
    [url=]essaytyper[/url] the college essay guy [url=]help me write an essay[/url] essay writing service

  46. Good information, Kudos.
    [url=]cpm homework help[/url] do my finance homework [url=]coursework[/url] pay someone to do my homework

  47. Whoa quite a lot of valuable advice.
    [url=]resume writing services[/url] essay writing companies [url=]paper writing services legitimate[/url] college essay writing services

  48. Whoa many of useful material!
    [url=]buy essay online[/url] pay for essay reviews [url=]pay someone to write my college essay[/url] pay someone to write my college essay

  49. This is nicely expressed! !
    [url=]essay review service[/url] essay service review [url=]essay writing help service[/url] writing a compare and contrast essay

  50. Whoa loads of good advice!
    [url=]help me write an essay[/url] medical school personal statement [url=]help with essay writing[/url] help essay

  51. Nicely put. Thank you.
    [url=]research paper writers[/url] research paper writer [url=]term paper help[/url] buy term papers online

  52. Amazing material, Kudos!
    [url=]hire someone to do my homework[/url] online coursework [url=]do my college homework[/url] do my math homework for me


Please enter your comment!
Please enter your name here

+ 46 = 49