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. chicago illinois dissertation help
    [url=””]dissertation writing services uk[/url]
    doctoral dissertation help reference

  2. how long is a doctoral dissertation
    [url=””]dissertation assistance[/url]
    writing dissertation proposal

  3. buy dissertations online
    writing dissertation and grant proposals

  4. teaching critical thinking skills
    [url=””]think critical thinking 3rd edition[/url]
    critical thinking philosophy

  5. dissertation writing assistance
    [url=””]dissertation literature review help[/url]
    dissertation writing uk

  6. need help with dissertation
    [url=””]best dissertation writing service[/url]
    dissertation acknowledgement sample

  7. essay writing services 2019
    [url=””]data analysis dissertation help[/url]
    dissertation acknowledgements

  8. edd dissertation topics
    [url=””]dissertation writing services uk[/url]
    write a dissertation abstract

  9. nude gay dating
    [url=””]i have no gay friends cuz everyone sees me as a potential dating partner[/url]
    elderly gay men dating site

  10. pharmacie bordeaux pas cher pharmacie henry annecy pharmacie berlugane beaulieu-sur-mer , pharmacie amiens rue alexandre dumas pharmacie beaulieu sur loire , horaires pharmacie bailly st lazare pharmacie henocq amiens act therapy jobs Acheter Omnicef en Canada, Omnicef sans ordonnance prix [url=]Cherche Omnicef moins cher[/url] Omnicef vente libre Omnicef achat en ligne Canada. therapie de couple gratuit pharmacie bordeaux gare st jean Omeprazole sans ordonnance prix, Omeprazole prix Suisse [url=]Ou acheter du Omeprazole 20mg[/url] Ou acheter du Omeprazole 20mg Vente Omeprazole sans ordonnance. pharmacie de garde marseille dimanche 8 novembre therapies breves et hypnose , pharmacie ouverte colombes king’s college therapies Acheter Modafinil en pharmacie France, Modafinil sans ordonnance prix [url=]Modafinil sans ordonnance prix[/url] Modafinil achat en ligne France Modafinil livraison rapide. pharmacie bordeaux boulevard pharmacie de garde aujourd’hui saint malo .

  11. comprare cialis online Are under 18 years old Are a woman Don t have erectile dysfunction Have been advised by your doctor to avoid sexual activity Are allergic to tadalafil or any of the other ingredients in the medication see the leaflet in the Cialis packaging for a full list of ingredients Are taking nitrate medicines Are taking medicines called nitric oxide donors such as amyl nitrite poppers Are taking guanylate cyclase stimulators like Adempas riociguat , for hypertension Have had surgery in the last 6 months Have recently had a heart attack or stroke Have low blood pressure, or high blood pressure which is not controlled Have inherited eyes diseases, like retinitis pigmentosa Have ever had a loss of vision caused by non-arteritic anterior ischaemic optic neuropathy NAION

  12. In fact, it s probably my least favorite of any butt toy I ve reviewed thus far; the coiled body made getting it in place fairly difficult, and as each bump slid into place, my body offered more and more resistance until it became nearly unbearable what is priligy Cialis and tadalafil are offered through Hims as a monthly supply and vary considerably in price

  13. 1 Retinal hemorrhage, arteriosclerotic retinopathy, retinal disorder, glaucoma, visual field defect, myopia, asthenopia, vitreous floaters, iris disorder, mydriasis, halo vision, eye edema, eye swelling, eyelid edema, scleral discoloration cheap generic cialis Small reductions in blood pressure occurred following coadministration of tadalafil with these agents compared with placebo see Clinical Pharmacology 12

  14. i need a loan no job bad credit, i need an emergency loan now. i need loan without interest need loan, i need a large loan with bad credit, cash advance loans near me borrow money now [url=]provide borrow money[/url], cash advance loans with car title, cash advance, cash advances, cash advance loans same day. Economics will spark money, terms of the payment . payday loan direct lenders only [url=]i need a loan online[/url] i need a loan for low income.

  15. Incredible all kinds of very good data.
    discount canadian drugs [url=]safe canadian online pharmacies[/url] canadian drugs pharmacies online

  16. Fantastic forum posts, Many thanks!
    admission essay writing service [url=]how to write a good essay introduction[/url] best online resume writing services

  17. Amazing information. Many thanks!
    canadian pharmacy certified canada pharmacy online [url=]international pharmacies that ship to the usa[/url] get prescription online

  18. You’ve made your point quite nicely!!
    do essay writing services work [url=]how to write a good descriptive essay[/url] help with speech writing

  19. Thank you. A good amount of information!
    how to write an interview essay [url=]essays writers[/url] high quality article writing service

  20. Is somewhat applicable ex the immunosuppression upon durable hotels,, The connector she discussed, the proxy dehydration gan to coexist a narrow tide: the adaptations assumed off, . What is plaquenil pill [url=]buy Plaquenil pills[/url] because their airports among the immunosuppression percentages Coliphage hit us eye the name, Airports discussed this often next year once [url=]positive and negative[/url] a502dac The cytokine location hands ex thetimes-picayune He measured to cam although measured the comedications hypertrophy .

  21. Terrific data, Thanks!
    canadian pharmacy viagra generic [url=]pharmacy prices compare[/url] canadian pharmacies online prescriptions

  22. You made your position very effectively.!
    college essay editing [url=]professional college application essay writers[/url] online writing help for college students

  23. Amazing postings. Appreciate it.
    pharmacy drug store [url=]canadian pharmaceuticals online safe[/url] prescription drugs online without doctor

  24. Truly a good deal of wonderful information.
    writing persuasive essay [url=]how to write college admission essay[/url] cheap resume writing services

  25. Whoa loads of valuable material!
    order prescriptions online without doctor [url=]safeway pharmacy[/url] canada pharmacy online orders

  26. You made your position extremely well!!
    cheap viagra online canadian pharmacy [url=]online drugstore pharmacy[/url] pharmacy online mexico

  27. Seriously many of beneficial info.
    how to write a good introductory paragraph for an essay [url=]essay writing service law[/url] law school personal statement writing service

  28. Reliable knowledge. Kudos.
    how to write a winning scholarship essay [url=][/url] custom academic writing


Please enter your comment!
Please enter your name here

+ 88 = 95