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

  29. pharmacie en ligne keto pharmacie nansouty bordeaux horaires comprime ramipril generique [url=][/url] pharmacie saint quentin beauvais .
    pharmacie ouverte wasquehal [url=][/url] pharmacie amiens rue alexandre dumas .
    pharmacie avenue stalingrad argenteuil [url=][/url] pharmacie en ligne vaccin grippe , pharmacie lafayette poitiers .

  30. pharmacie soussan beaulieu sur mer act therapy worksheets pharmacie valence [url=][/url] interim pharmacie bordeaux .
    pharmacie ouverte uzemain [url=][/url] pharmacie bourges centre .
    pharmacie beauvais rue de la madeleine [url=][/url] therapy act holder , therapie de couple toulouse .

  31. Interpretation At the planned second interim analysis, addition of 2 years of adjuvant palbociclib to adjuvant endocrine therapy did not improve invasive disease free survival compared with adjuvant endocrine therapy alone lasix mechanism of action In some embodiments, the light source can be directed to a particular tissue or cell that is expressing the ER fusion protein e

  32. Cochrane No evidence to suggest tamoxifen benefits patients with relapsed ovarian cancer lasix 40 mg tablet Aside from the usual Post Cycle Therapy products such as Novaldex and Clomid, HCG is also proving to be a very effective addition to a PCT regimen

  33. Dx 1 26 2010, IDC, 4cm, Stage IIA, Grade 3, 0 2 nodes, ER PR HER2 Targeted Therapy 2 8 2010 Avastin bevacizumab Chemotherapy 2 8 2010 Adriamycin doxorubicin, Cytoxan cyclophosphamide, Taxotere docetaxel, Xeloda capecitabine Surgery 9 4 2010 Lymph node removal Left, Sentinel; Mastectomy Left Radiation Therapy 10 18 2010 Breast, Lymph nodes Surgery 12 13 2010 Prophylactic mastectomy Right Hormonal Therapy 12 31 2010 Tamoxifen pills Nolvadex, Apo Tamox, Tamofen, Tamone Hormonal Therapy 9 30 2011 Aromasin exemestane Dx 3 2018, IDC, 4cm, Stage IV, metastasized to brain lungs, Grade 3, 0 2 nodes, ER PR HER2- lasix magnesium edited and revised manuscript; T

  34. therapies manuelles kine therapies manuelles kine pharmacie leclerc pontivy [url=][/url] pharmacie de garde nanterre .
    pharmacie bourges rue louis mallet [url=][/url] pharmacie de garde marseille site officiel .
    pharmacie bentz beaulieu sur dordogne [url=][/url] pharmacie ouverte gennevilliers , pharmacie de garde rueil .

  35. pharmacie beauvais horaires therapies analytiques pharmacie leclerc erstein telephone [url=][/url] pharmacie moizard amiens .
    pharmacie autour de moi de garde [url=][/url] pharmacie de garde nc .
    pharmacie st quentin beauvais [url=][/url] traitement epilepsie , therapie magnetique .

  36. cialis tablets for sale U 20 AFCON Percious Boah belter powers Black Satellites into final Ghana s Black Satellites got a measure of revenge and a ticket to the final of the Under 20 Africa Cup of Nations when they defeated the Young Scorpions of the Gambia 1 0 in the semi final clash at the Stade Olympique De Nouakchott in Mauritania on Monday

  37. pharmacie de bailly pharmacie mulhouse pharmacie de garde vannes [url=][/url] pharmacie de bailly romainvilliers .
    pharmacie rue jean jaures argenteuil [url=][/url] une pharmacie ouverte Г  proximite .
    pharmacie ouverte woluwe saint lambert [url=]–achat-en-ligne-Belgique[/url] pharmacie beauvais garde .
    pharmacie boulogne billancourt avenue victor hugo [url=][/url] pharmacie khun angers .
    pharmacie thoraval brest fax [url=][/url] pharmacie becker monteux horaire , pharmacie boulogne billancourt rue michelet .

  38. therapie de couple questionnaire pharmacie saint nicolas angers pharmacie auchan porte des alpes [url=][/url] pharmacie boulogne billancourt avenue pierre grenier .
    pharmacie autour [url=][/url] act therapy kent .
    therapie yverdon [url=][/url] pharmacie ouverte ile d’oleron .
    therapies manuelles et energetiques [url=][/url] pharmacie de garde beaulieu nantes .
    pharmacie auchan bourges [url=–prix-sans-ordonnance-Paracetamol-en-pharmacie-Suisse][/url] therapie cognitivo-comportementale clermont ferrand , therapie quantique yannick verite .

  39. мухарбек караев видео. Взять [url=]кредит вебмани[/url] мгновенно. анекдоты про нарто

  40. pharmacie aix en provence saint jerome pharmacie de garde orleans parapharmacie leclerc hyeres [url=][/url] pharmacie de garde avignon numero .
    pharmacie ouverte tours [url=][/url] pharmacie toledano argenteuil .
    pharmacie khun angers [url=][/url] pharmacie de garde beaulieu sur dordogne .
    pharmacie de garde aujourd’hui mayotte [url=][/url] pharmacie auchan woippy horaire .
    medicaments et alcool [url=][/url] medicaments bagage cabine , pharmacie en ligne reunion .

  41. страдальческие картинки. Получить займ вебмани [url=][/url]. онлайн видео домашнее унижение

  42. pharmacie france argenteuil horaires pharmacie bailly st lazare pharmacie marc brest [url=][/url] pharmacie etampes .
    formation therapies breves grenoble [url=][/url] pharmacie de garde roanne .
    ketoconazole pharmacie en ligne [url=][/url] pharmacie becker Г  monteux .
    pharmacie materiel medical argenteuil [url=][/url] traitement herpes genital .
    pharmacie de garde yamoussoukro aujourd’hui [url=][/url] pharmacie pas cher autour de moi , pharmacie de garde gardanne .

  43. where can i buy stromectol ivermectin 2b are pathways by which omega 3 fatty acids have been shown to inhibit breast cancer invasive properties; again certain pathways are shown in red to emphasize the circumstantial evidence our inference from the data that they may be involved in inhibition by omega 3 fatty acids of progestin stimulation of breast cancer invasion

  44. pharmacie hopital d’annecy pharmacie ouverte uzemain traitement fibromyalgie [url=][/url] pharmacie en ligne nimes .
    pharmacie en ligne lille [url=][/url] pharmacie beauvais champs dolent .
    pharmacie barbes bourges [url=][/url] pharmacie gare avignon .
    medicaments mal de dents [url=][/url] pharmacie touati argenteuil .
    therapies comportementales et cognitives pleine conscience [url=][/url] comprime un generique , pharmacie de garde etampes .

  45. reno payday loans [url=]careers for management majors[/url] mail merge outlook

  46. cheap online courses for college credit [url=]regina housekeeper plus[/url] fight traffic ticket florida

  47. Members of the Expert Panel were responsible for reviewing and approving the penultimate version of the guideline, which was then circulated for external review, and submitted to the Journal of Clinical Oncology JCO for editorial review and consideration for publication what does nolvadex do

  48. Some studies suggest improved response to docetaxel or paclitaxel, while others suggest relative resistance where to buy priligy in malaysia ACF aberrant crypt foci APC adenomatous polyposis coli ARR androgen response elements CCSP club cell secretory protein DCIS ductal carcinoma in situ EGFP enhanced green fluorescent protein HER2 human epidermal growth factor receptor 2 HNPCC hereditary nonpolyposis colorectal cancer IPMN intraductal papillary mucinous neoplasm MIND mammary intraductal MMR mismatch repair MMTV mouse mammary tumor virus Msh2 mutS homolog 2 MUC1 mucin1 PanIN pancreatic intraepithelial neoplasia PDAC pancreatic ductal adenocarcinoma PIN prostatic intraepithelial neoplasia PPAR peroxisome proliferator activated receptor rtTa reverse tetracycline transactivator TAg large tumor antigen TMPRSS2 transmembrane serine protease 2

  49. You explained this exceptionally well!
    discount canadian drugs [url=]ordering prescriptions from canada legally[/url] weight loss drugs prescription

  50. Wonderful data. Kudos.
    aarp canadian pharmacies [url=]free online pharmacy technician training[/url] recommended canadian pharmacies

  51. having trouble urinating male [url=][/url] sql many to many relationship

  52. You’ve made your stand pretty effectively.!
    canadian pharmacy 24 com [url=]top canadian pharmacies[/url] reputable canadian pharmacies online

  53. Great content. Thanks a lot!
    phendimetrazine online pharmacy [url=]fda approved online pharmacy[/url] walgreens pharmacy gig harbor store hours

  54. лодочка для суши картинки видео реклама мтс red energy [url=]заказать попперс москва[/url] игра интернет знакомства картинки на рабочий стол цветы скачать бесплатно без регистрации

  55. cloth disposable diapers вар крафт видео с паладином [url=]попперс заказать москва[/url] гимн украины новый год searly mattress

  56. 4 12, 15 17 Nine of these studies involved newer antidepressants, and three involved gabapentin siphene buy no prescription Fourteen patients dropped out of the trial including two patients who died and two patients who had terminal disease, disabling them in attending the final follow up

  57. how to print from my ipad to a wireless printer [url=]portable eye wash stations[/url] bank of america business account login


Please enter your comment!
Please enter your name here

− 7 = 3