sql server - SQL database permissions required to use impersonation from SSRS connection -


i encountering following error when try specify datasource ssrs sql server db (2008) using "credentials stored securely in server" - specified windows account "s2\killian" option "impersonate authenticated user after connection has been made" checked.

msg 15157, level 16, state 1, line 1 setuser failed because of 1 of following reasons: database principal 's2\killian' not exist, corresponding server principal not have server access, type of database principal cannot impersonated, or not have permission.

obviously method of impersonation uses setuser() function behind scenes , msdn documentation states dbowner permissions required in order use function. getting above error when using dbowner. not in position use sysadmin because of security policy.

does know how mechanism of authentication , impersonation working without assigning sysadmin priveleges on sql server database windows account used ssrs data source.

is there way of getting setuser() work without sysadmin priveleges?

thanks killian

the clue "the database principal 's2\killian' not exist"

any connection uses context change on database side (eg setuser, execute as etc) requires impersonated user exists in sys.server_principals and/or sys.database_principals.

assuming use ad group, not individual logins, cause same error above. outside of permissions. if db_owner, can impersonate @ database level. if can't, it's because of previous paragraph.

i've thought idiotic option ssrs have. msdn says uses setuser deprecated. ideally, you'd impersonate before connection possible asp.net apps don't know ssrs (which asp.net app of course)

sorry lack of "do , works" answer...


Comments

Post a Comment

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

i'm using abcpdf , i'm curious if can recursively call addimageurl() function assemble pdf document compile multiple urls? something like: int pagecount = 0; int theid = thedoc.addimageurl("http://stackoverflow.com/search?q=abcpdf+footer+page+x+out+of+", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetochain(theid); } pagecount = thedoc.pagecount; console.writeline("1 document page count:" + pagecount); //flatten document (int = 1; <= pagecount; i++) { thedoc.pagenumber = i; thedoc.flatten(); } //now try again theid = thedoc.addimageurl("http://stackoverflow.com/questions/1980890/pdf-report-generation", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetoc
Read more

java - Android recognize cell phone with keyboard or not? -

in android app, want detect user's device if device has keyboard(like motorola milestone) , show corresponding user interface. guys know how that? ! regards justicepenny http://developer.android.com/reference/android/content/res/configuration.html public int keyboard the kind of keyboard attached device. 1 of: keyboard_nokeys, keyboard_qwerty, keyboard_12key. that's it!
Read more

iphone - How would you achieve a LED Scrolling effect? -

how achieve led scrolling effect example below? led sign - led ticker emulator iphone , ipad http://img.skitch.com/20101201-rsfh4p1bajb1wp94k466pdpiuj.preview.jpg sometimes remunerates comment in other posts :) have put code you, should implement font '8pin matrix' realistic feeling. uilabel *label; - (void)viewdidload { [super viewdidload]; label = [[uilabel alloc]initwithframe:cgrectmake(10, 50, 300, 20)]; label.font = [uifont fontwithname:@"courier-bold" size:16.0]; label.backgroundcolor = [uicolor blackcolor]; label.textcolor = [uicolor greencolor]; label.linebreakmode = uilinebreakmodecharacterwrap; // otherwise "…" label.text = @"this led text scrolled "; // blanks space between [self.view addsubview:label]; [nstimer scheduledtimerwithtimeinterval:0.12f target:self selector:@selector(scrolllabel) use
Read more