tag:blogger.com,1999:blog-2021989930591302225.post7086151862446810585..comments2023-10-18T07:48:44.802-07:00Comments on NYC DBA: "Unable to perform a SETUSER to the requested username" errorAnonymoushttp://www.blogger.com/profile/09313712310740744659noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-2021989930591302225.post-10085155590881289782009-01-22T05:51:00.000-08:002009-01-22T05:51:00.000-08:00I just want to thank you because the info that you...I just want to thank you because the info that you provided regarding the SETUSER error resolved my issue and my job is no longer failing! Thank you very much! Steven Fink (stevenfink2@gmail.com)Unknownhttps://www.blogger.com/profile/10111913807967050599noreply@blogger.comtag:blogger.com,1999:blog-2021989930591302225.post-18427721654899770262008-01-11T07:03:00.000-08:002008-01-11T07:03:00.000-08:00Yep, executed exactly as posted.Yep, executed exactly as posted.Anonymoushttps://www.blogger.com/profile/09313712310740744659noreply@blogger.comtag:blogger.com,1999:blog-2021989930591302225.post-43354753384180502132008-01-10T13:34:00.000-08:002008-01-10T13:34:00.000-08:00Ira,What value did you use for the arg2? Was it li...Ira,<BR/><BR/>What value did you use for the arg2? Was it literally the following: N'(server internal)'?<BR/><BR/>ThanksUnknownhttps://www.blogger.com/profile/07945809188908775594noreply@blogger.comtag:blogger.com,1999:blog-2021989930591302225.post-12330348952847739742008-01-09T12:17:00.000-08:002008-01-09T12:17:00.000-08:00Max,I haven't been able to locate documentation on...Max,<BR/><BR/>I haven't been able to locate documentation on the proper use of "N'(server internal)'", but my guess is that it accesses code in a SQL Server cab file or similar, which would not be accessible using the usual dll filename notation. The SQL Server Customer Advisory Team could probably provide you with more information.<BR/><BR/>IraAnonymoushttps://www.blogger.com/profile/09313712310740744659noreply@blogger.comtag:blogger.com,1999:blog-2021989930591302225.post-29295844548941508712008-01-09T11:52:00.000-08:002008-01-09T11:52:00.000-08:00From the documentation on the sp_addextendedproc a...From the documentation on the sp_addextendedproc arg1, arg2 stored procedure in the master database follows that the arg1 is a name of a new extended stored procedure, and the arg2 is the name of the dll file containing it's definition.<BR/><BR/>In your notation,<BR/><BR/>sp_addextendedproc N'sp_setuserbylogin', N'(server internal)'<BR/><BR/>what is the name of the "server internal" dll to be used, i.e. which dll file contains the definition of the sp_setuserbylogin extended stored procedure?<BR/><BR/>ThanksUnknownhttps://www.blogger.com/profile/07945809188908775594noreply@blogger.com