Error 87 From Getproxyaccount On Line
its something to do with running the xp_cmdshell[Microsoft][ODBC SQL Server Driver][SQL Server]xpsql.cpp:Error 87 from GetProxyAccount on line 604thanksmic oj 2003-12-04 07:57:34 UTC PermalinkRaw Message You get this error because you do not have a valid account as the proxyaccount. Basically, this account is used when a non-sysadmin user invokesxp_cmdshell. This is fully documented in book online under xp_cmdshell.Here is a quick script to help you set the account.e.g.--see the current settingexec master..xp_sqlagent_proxy_account N'GET'--set itexec master..xp_sqlagent_proxy_account N'SET',N'DomainName',N'UserName',N'Password'---ojRAC v2.2 & QALite!http://www.rac4sql.netPost by a***@discussions.microsoft.comDoes any one know what this is abouti think its something to do with running the xp_cmdshellError 87 from GetProxyAccount on line 604thanksmic mike 2003-12-08 01:09:19 UTC PermalinkRaw Message You were right there was no proxyset up. But setting it up stillget same error! HELP!Is there something esle we have to set up at theserver or outside sql server to get this 2 work.mike-----Original Message-----You get this error because you do not have a validaccount as the proxyaccount. Basically, this account is used when a non-sysadmin user invokesxp_cmdshell. This is fully documented in book onlineunder xp_cmdshell.Here is a quick script to help you set the account.e.g.--see the current settingexec master..xp_sqlagent_proxy_account N'GET'--set itexec master..xp_sqlagent_proxy_account N'SET',N'DomainName',N'UserName',N'Password'---ojRAC v2.2 & QALite!http://www.rac4sql.netPost by a***@discussions.microsoft.comDoes any one know what this is abouti think its something to do with running the xp_cmdshell[Microsoft][ODBC SQL Server Driver][SQL Server]Error 87 from GetProxyAccount on line 604thanksmic. 2 Replies 16 Views Switch to linear view Disable enhanced parsing Permalink to this page Thread Navigation a***@discussions.microsoft.com 2003-12-04 06:02:28 UTC oj 2003-12-04 07:57:34 UTC mike 2003-12-08 01:09:19 UTC about - legalese Loading...
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums Old Forums CLOSED - General SQL Server xp_cmdshell fails Forum Locked Printer Friendly Author Topic delpiero Yak Posting Veteran Italy http://microsoft.public.sqlserver.programming.narkive.com/k33lqtau/help-xpsql-cpp-error-87-from-getproxyaccount 98 Posts Posted-07/26/2005: 22:06:01 Dear all, I think this is a typical problem but I have followed the solutions from BOL yet the error is still there: In my stored procedure, I included a call to xp_cmdshell to execute a DTS package using DTSRUN (the DTS package performs some processing in Analysis Server), an an OS command. From my application, I http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=52869 used a non-sysadmin SQL Server login called APP_USER to connect to SQL Server, and it maps to database user APP_USER in databases master and APP (the application database). I granted execute permission on xp_cmdshell to the user APP_USER in master database, and then run the xp_sqlagent_proxy_account as follows:EXEC master.dbo.xp_sqlagent_proxy_account N'SET', N'APP-SERVER', N'administrator', N'password' The 3 parameters are the SQL Server machine name, administrator user name and its password, respectively. So I run the stored procedure using the APP_USER account in query analyzer, yet at the line the xp_cmdshell is called, the following error occurs:Msg 50001, Level 1, State 50001xpsql.cpp: Error 87 from GetProxyAccount on line 604 Did I do anything wrong? Or what else must I do to let APP_USER successfully run the stored procedure?Many thanks,delpiero dragan Starting Member South Africa 17 Posts Posted-07/27/2005: 03:36:05 I had a problem much like yours a few months ago. These are the procedures I created in case it happens again. It's very step-by-step, see if it helps youOn the database server 1.) Start - Control Panel – Administrative Tools – ServicesEnsure that the SQLSERVERAGENT service is s
to resolve it. In the following paragraphs, we can help you find your Error 87 From Getproxyaccount On Line 604 and suggest whatever you might try to correct the error. How to Fix Error 87 From Getproxyaccount http://www.dlldownloadcenter.com/Error_87_From_Getproxyaccount_On_Line_604.html On Line 604 ? What Causes Error 87 From Getproxyaccount On Line 604? Error 87 From Getproxyaccount On Line 604 Codes are caused in one method or another by misconfigured system files within your windows os. Common Error 87 From Getproxyaccount On Line 604 you may receive: Common Error 87 From Getproxyaccount On Line 604 Error Messages:The most common Error 87 From Getproxyaccount On Line 604 errors that can appear on a Windows-based error 87 computer are: "Error 87 From Getproxyaccount On Line 604 not found." "The file Error 87 From Getproxyaccount On Line 604 is missing." "Error 87 From Getproxyaccount On Line 604 Access Violation." "Cannot register Error 87 From Getproxyaccount On Line 604." "Cannot find %PROGFILES64%\WIDCOMM\Bluetooth Software\Error 87 From Getproxyaccount On Line 604." "Cannot start Bluetooth Software. A required component is missing: Error 87 From Getproxyaccount On Line 604. Please install Bluetooth Software again." "This application failed error 87 from to start because Error 87 From Getproxyaccount On Line 604 was not found. Re-installing the application may fix this problem." How to Solve Error 87 From Getproxyaccount On Line 604? Troubleshoot Error 87 From Getproxyaccount On Line 604 Error Manually.Fix Error 87 From Getproxyaccount On Line 604 by updating Windows 7 for the latest version. Click Start button, and kind windows update from the searching box. Then click windows update since the picture below.Please make sure that if there is any updates need to be updated urgently. If windows shows that there are important updates available. Please update it over time. Windows update is a crucial procedure to mend Error 87 From Getproxyaccount On Line 604 problem. 1) Start your computer and log on for an administrator.2) Click on the Start button then select AllAccessories and Programs, System Tools, after which click System Restore.3) In the new window, select "Restore my computer with an earlier time" option and then click Next.4) Select the most up-to-date system restore point in the "With this list, click a restore point" list, and then click Next.5) Click Next in the confirmation window.6) Restarts the computer as soon as the restoration is finished. Fix Error 87 From Getproxyaccount On Line 604 Error Immediately!The First Step: Download SmartPCFixer and do the installation on your personal com