Error 22022 Client Operation Failed
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: SQL Server 2005 SQL Agent Startup Issue -SQLServer Error: 22022, CryptUnprotectData() SQL Server > SQL Server Setup & Upgrade Question 0 Sign in to vote SQL Server 2008 RC0 installed on Windows XP Professional SP3. The named instances is 'instance1' I am unable to get the SQL Server Agent to start, the message in the SQL Server Agnet Log is: Date 6/17/2008 12:38:26 PMLog SQL Server Agent (Current - 6/17/2008 12:38:00 PM) Message[298] SQLServer Error: 22022, CryptUnprotectData() returned error -2146892987, 'The requested operation requires delegation to be enabled on the machine.' [SQLSTATE 42000] Any assistance will be most appreciated. Tuesday, June 17, 2008 4:50 PM Reply | Quote Answers 0 Sign in to vote Thank you, reviewed. I will test when my domain administrators have the 'go ahead' to add these rights to the service account. Wednesday, June 18, 2008 12:15 PM Reply | Quote All replies 0 Sign in to vote You can read this article: http://support.microsoft.com/kb/943525 Hope it works. Wednesday, June 18, 2008 5:47 AM Reply | Quote 0 Sign in to vote Thank you, reviewed. I will test when my domain administrators have the 'go ahead' to add these rights to the service account. Wednesday, June 18, 2008 12:15 PM Reply | Quote 0 Sign in to vote That did the trick. Thanks for the assistance. Monday, July 07, 2008 5:29 PM Reply | Quote 0 Sign in to vote go to registery to modify the value: HKEY_Local_Machine\SOFTWARE\MICROSOFT\MICROSOFT SQL SERVER\SSQL.# (The instance number)\SQLServerAgent Find stringValue: ServerHost Change to NP: (Instance name) (example: NP: SQLinstance1) This will use named pipe to have SQL agent to connect to the database engine. Doing above to fix the ptoblem caused by Hotfix 3 Tuesday, August 12, 2008 7:23 PM Reply | Quote 0 Sign in to vote Wow! I spent 2 days working on this and the previous post fixed it.Here's the skinny:1) Windows Server 2008 x64 RTM2) SQL Server 2008 Standard x643) Workgroup joined server (no domain)SQL Express 2008 was installed. I uninstalled that with no errors. I then installed SQL 2008 with no errors. I rebooted the server and voila. SQLAgent
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 > Error when trying a test email message to a new operator Want to Advertise Here? Solved Error when https://social.msdn.microsoft.com/Forums/sqlserver/en-US/04dacb27-c124-411d-ba97-6cf97d3781fd/sql-server-2005-sql-agent-startup-issue-sqlserver-error-22022-cryptunprotectdata?forum=sqlsetupandupgrade trying a test email message to a new operator Posted on 2000-10-11 MS SQL Server 1 Verified Solution 3 Comments 411 Views Last Modified: 2008-02-20 I'm using SQLServer 7 with sp2 applied. SQLMail is configured and works OK (e.g. when using xp_sendmail). However, if I set up an operator (valid email address) and hit the "Test" message https://www.experts-exchange.com/questions/11520318/Error-when-trying-a-test-email-message-to-a-new-operator.html button I get the error message :- Error 22022 : SQLServerAgent Error. The client operation failed. Can anyone help with advice ? 0 Question by:gng Facebook Twitter LinkedIn Google LVL 142 Active today Best Solution byGuy Hengel [angelIII / a3] Does your SQL Server Agent Service run under the same account as the MS SQL Server service? Go to Solution 2 Comments LVL 142 Overall: Level 142 MS SQL Server 87 Message Active today Accepted Solution by:Guy Hengel [angelIII / a3]2000-10-11 Does your SQL Server Agent Service run under the same account as the MS SQL Server service? 0 Message Author Comment by:gng2000-10-12 This problem got resolved by stopping and restarting the SQLServerAgent service. I understand where you were going though - a/c permissions etc. Have the points for showing an interest ! Thanks. 0 Write Comment First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Comment Submit Your Comment By clicking you are agreeing to
attachment authorized available backup been cancelled cannot client closed code complete could crystal current data database directory does due each engine enough error exchange failed file found generated has have illegal index inpage interbase invalid ldifde legal Lotus manipulation memory mix must network non http://software.programming4.us/tags/operation/default.aspx?PageIndex=10 notes object oci open oracle out outlook overlapped perform performing permission permitted public query reason reported response restore restrictions rsync section SEND/RECEIVE ERROR: 0x80004005 Operation Failed sending socket sql storage supported terminated This operation has been cancelled due to restrictions in effect on this computer. thread time timed timeout tns unable updateable use user utl_file view violates volume vpn waiting web when windows word you your Outlook 2003 fails with "The operation failed. An object could not be error 22022 found." Outlook 2003, connected to an exchange server, no longer works. I get an error: "The operation failed. An object could not be found," and Outlook seems to use a lot of CPU cycles - sometimes over 90%. I rebuilt the profile as suggested in a MSKB article. Also, Outlook has been configured to... Posted to Outlook (Forum) by software on 06-13-2009 Error when trying a test email message to a new operator I'm using SQLServer 7 with error 22022 client sp2 applied. SQLMail is configured and works OK (e.g. when using xp_sendmail). However, if I set up an operator (valid email address) and hit the "Test" message button I get the error message :- Error 22022 : SQLServerAgent Error. The client operation failed.... Posted to MS SQL Server (Forum) by software on 06-13-2009 Can't Start Apache server!!!! Hello Everyone, I'm Getting an error for Apache server 2.0.59, " Error : The requested operation has failed! " I encounter this error when i start my apache server's tray icon. It was working good before untill i restarted it. i'm using WinXP (SP2) Plzzzzzzz help me. Regards. Posted to Web Servers (Forum) by software on 06-13-2009 Why do I get an invalid file operation error when I run a PL/SQL script with UTL_FILE? I am attempting to learn how to use the UTL_FILE utility so I can develop a script generating code for doing electronic data comparisons of various Oracle Tables. When I try to run the following simple UTL_FILE script that I got off of the web I get an invalid file operation error. Here is what happens... Posted to PL / SQL (Forum) by software on 06-13-2009 Disk Array Errors on AIX Our IBM drive array has reported an error. I need to determine which drive(s) are experiencing errors. None has fully failed yet, but they are reporting "Array Operation Error"