Error 87 From Getproxyaccount Online 604
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...
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > xp_cmdshell Error 87 from GetProxyAccount on line 604 Want to Advertise Here? Solved xp_cmdshell Error 87 from GetProxyAccount on line 604 Posted on 2004-01-11 MS SQL Server 1 Verified Solution 7 Comments 5,216 Views Last Modified: 2007-12-19 I am getting the following error [Macromedia][SQLServer JDBC Driver][SQLServer]xpsql.cpp: Error 87 from GetProxyAccount on line 604 This is through ODBC... The user I am http://microsoft.public.sqlserver.programming.narkive.com/k33lqtau/help-xpsql-cpp-error-87-from-getproxyaccount using in the ODBC connection is not a domain user, just a login created within SQL itself... I found some articles that talk about this problem, but it refers to me setting up domain user - I don;t have access to the domain, neither do I want to work with a domain user, is there any way of fixing this? Other info: The odbc calls a Stored Procedure with the following reference to xp_cmdshell -- create the string to https://www.experts-exchange.com/questions/20847848/xp-cmdshell-Error-87-from-GetProxyAccount-on-line-604.html perform the export SET @string = 'bcp "##' + @fileName + '" out "' + @path + @fileName + '.xls" -c -U"export" -P"export"' -- perform the export EXEC master..xp_cmdshell @string 0 Question by:Tacobell777 Facebook Twitter LinkedIn Google LVL 34 Best Solution byarbert You don't have to use a domain account. When you go into the "job system" properties on your sql agent, click the "reset proxy account". it will ask you for a new user/password and domain. For the Go to Solution 7 Comments LVL 34 Overall: Level 34 MS SQL Server 33 Message Accepted Solution by:arbert2004-01-11 You don't have to use a domain account. When you go into the "job system" properties on your sql agent, click the "reset proxy account". it will ask you for a new user/password and domain. For the domain, just put the name of the local server (of course, that account has to exist on the local server). Brett 0 LVL 34 Overall: Level 34 MS SQL Server 33 Message Expert Comment by:arbert2004-01-11 Also, I'm sure you know what the risk is by allowing non-syadmins the ability to execute XP_CMDSHELL.... 0 LVL 17 Overall: Level 17 MS SQL Server 1 Message Author Comment by:Tacobell7772004-01-11 Maybe a stupid question, but how do I get in there? 0 LVL 17 Overall: Level 17 MS SQL Server 1 Message Author Comment by:Tacobell7772004-01-11 I am aware about the security ri
running the http://www.verycomputer.com/156_8a04356fe41fb8fc_1.htm xp_cmdshell [Microsoft][ODBC SQL Server Driver][SQL Server]xpsql.cpp: Error 87 from GetProxyAccount on line 604 some saidto run this exec master..xp_sqlagent_proxy_account N'SET', N'DomainName', N'UserName', http://www.dlldownloadcenter.com/Error_87_From_Getproxyaccount_On_Line_604.html N'Password' but didn't make any difference .. HELP any ideas. do we need to set something up outside the server? thanks mic error 87 Top Error 87 from GetProxyAccount on line 604 by 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 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 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 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 m