Nt Authority System Sqlmaint Exe Failed Sqlstate 42000 Error 22029
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » Backups » sqlmaint.exe failed (SQLSTATE 42000) (Error... sqlmaint.exe failed (SQLSTATE 42000) (Error 22029) The step failed Rate Topic Display Mode Topic Options Author Message IceMan-920581IceMan-920581 Posted Friday, October 24, 2008 1:56 AM Grasshopper Group: General Forum Members Last Login: Friday, April 10, 2009 11:11 AM Points: 12, Visits: 174 W2k, SQLserver2k SP4Simple DbThis occurs in 1-Integrity chcks and 2- Optimizations check, in a Maintenance plan.-I dont know what happend. Thanks for your help.- Post #591012 MarkusBMarkusB Posted Friday, October 24, 2008 2:09 AM SSCarpal Tunnel Group: General Forum Members Last Login: Wednesday, January 27, 2016 5:54 AM Points: 4,429, Visits: 4,204 If you have reporting enabled in your maintenance plan, there should be a logfile with more details about the error.The error you gave us is just a general error which happens every time a maintennace tasks fails. Markus Bohse Post #591016 Renuka__Renuka__ Posted Friday, October 24, 2008 2:20 AM Ten Centuries Group: General Forum Members Last Login: Tuesday, March 31, 2015 8:21 AM Points: 1,022, Visits: 1,370 Hi,Right click on Maintenance plan and select Maintenance Plan History. You may get more details there.... Renuka__ Post #591019 IceMan-920581IceMan-920581 Posted Monday, October 27, 2008 1:55 AM Grasshopper Group: General Forum Members Last Login: Friday, April 10, 2009 11:11 AM Points: 12, Visits: 174 Thanks, here the reports. I have dbo rights, but i dont undertand, this happend 2 weeks ago. Post Attachments DB Maintenance Plan10_200810240627.txt (128 views, 312 bytes) DB Maintenance Plan12_200810240617.txt (39 views, 312 bytes) DB Maintenance Plan12_200810240627.txt (22 views, 312 bytes) Post #591950 GilaMonsterGilaMonster Posted Monday, October 27, 2008 2:18 AM SSC-Forever Group: General Forum Members Last Login: Today @ 3:53 PM Points: 45,430, Visits: 43,777 Is it still happening?What login are the maintenance plans running as? What rights does that login have? Gail ShawMicrosoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no other
sphere login blackbaud labs noza blackbaud tv netwits thinktank usa uk pacific netherlands canada Error: Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). NOTE: The step was retried the requested number of times (1) without succeeding. The step failed. When attempting to make a backup through the Blackbaud Management Console, the backup history log reflects the following error message: 'Executed as user: NT http://www.sqlservercentral.com/Forums/Topic591012-24-1.aspx AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). NOTE: The step was retried the requested number of times (1) without succeeding. The step failed.' Article Number:53062 Products: Education_Edge_EE Financial_Edge Raiser_s_Edge Student_Billing On the server where the Blackbaud Management Console (BMC) is installed, download and install the SQL Server 2005 Backward https://kb.blackbaud.com/articles/Article/53062 Compatibility Components [select "Install Instructions" > Microsoft SQL Server 2005 Backward Compatibility Components > X86 Package or X64 Package (depending upon whether you are using a 32-bit or 64-bit version of SQL Server)]. The SQL Server 2005 Backward Compatibility Components are also included in your downloaded installation files for the Raiser's Edge, the Financial Edge, or the Education Edge and can be found at the following location: (If using a 32-bit version of SQL Server) - \ISSetupPrerequisites\Microsoft SQL Server 2005 Backward Compatibility\(If using a 64-bit version of SQL Server) - \ISSetupPrerequisites\Microsoft SQL Server 2005 Backward Compatibility (64-bit)\ If your SQL Server instance is installed on a server separate from your Blackbaud Management Console server, then the SQL Server 2005 Backward Compatibility Components must be installed on both servers. NOTE: The SQL Server 2005 Backwards Compatibility Components are required, regardless of the SQL Server ver
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 https://www.experts-exchange.com/questions/27429416/SQL-Server-Job-permissions-query.html Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live http://www.sql-server-performance.com/forum/threads/sqlstate-42000-error-22029.4946/ Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > SQL Server Job permissions query Want to Advertise Here? Solved SQL Server Job permissions query Posted on 2011-11-03 MS SQL Server 1 Verified Solution 14 Comments 955 Views Last Modified: 2012-08-14 I have a issue. The SQL Agent job to backup a transaction log nt authority fails with the error: Job outcome: "The job failed. The Job was invoked by User USERGROUP\sqlservice. The last step to run was step 1 (Backup)." Backup task: "Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed." The backup task log output is as follows: "Logged on to SQL Server 'XYZ' as 'TESTGROUP\srsqlservice' (trusted) Login '' is not the DBO of database 'TestDB' so cannot run nt authority system SQLMAINT.EXE." The SQL Agent service is running as Local System Acccount. The SQL Server database service is running as 'TESTGROUP\srsqlservice'. All jobs and databases are owned by SA. When I add the 'TESTGROUP\srsqlservice' user to the database TestDB with db_owner privs, the backup jobs works fine. I just can't understand why the SQl agent job is trying to log onto the database as TESTGROUP\srsqlservice when the SQL Agent is running as the Local System Account? Thanks, Conor 0 Question by:conorbrophy Facebook Twitter LinkedIn Google LVL 17 Best Solution byBarry Cunney Hi Conor, I set up my SQL Server environment as identical as possible to yours last night, a sqlmaint back job owned by sa, database owned by sa etc. The sqlmaint utility logged on to SQL Server using Go to Solution 14 Comments LVL 17 Overall: Level 17 MS SQL Server 13 Message Expert Comment by:Barry Cunney2011-11-03 Hi Conor, What exactly is in the backup job which SQL Agent is running? 0 Message Author Comment by:conorbrophy2011-11-03 Hi there, Backs up a transaction log. i.e. EXECUTE master.dbo.xp_sqlmaint '-D TestDB -Rpt "D:\MSSQL7\LOG\TestDB Transaction Log.txt" -DelTxtRpt 1WEEKS -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpLog "D:\MSSQL7\BACKUP" -DelBkUps 3DAYS -CrBkSubDir -BkExt "TRN"' 0 LVL 17 Overall: Level 17 MS SQL Server 13 Messa
(Error 22029) Discussion in 'General DBA Questions' started by rweinstein, Nov 7, 2004. rweinstein New Member My maintenance plan backup failed the other day with the following error and from my research I found that it was likely caused from not having enough disk space, which there was not sufficient space to do the backup. I removed a ton of space and it failed again last night with there being 55GB free space, when the DB is only 16GB. Executed as user: NT AUTHORITYSYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed. After I freed up some space, the backup ran okay, but the maintenance plan was still failing with the same error message. The only change I made to this Maintenance Plan backup recently, was I moved it from 6:00am to 7:00 am in the morning and I don't see anything else conflicting. My suspicion is that because this "step 1" of the plan also contains the deletion of files older than 1 day, that maybe this last setp failed after the backup was completed. I do see that it is not deleting these older files. Do you suppose that by changing the time of the backup, it would make this last step of the plan fail? This is the only reason I could think of. Below is the MP script: EXECUTE master.dbo.xp_sqlmaint N'-PlanID EB943500-B818-425F-B9B8-20EBE92FFC8D -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDB -BkUpMedia DISK -BkUpDB "Erogram FilesMicrosoft SQL ServerMSSQLBACKUP" -DelBkUps 1DAYS -BkExt "BAK"' Thanks. rweinstein, Nov 7, 2004 #2 satya Moderator Ensure the SQL Server service account has required privileges to deal the files and see whether those files are accessed by any other process during that time. Check DB maintenance plan history log file for further information. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing. satya, Nov 8, 2004 #2 rweinstein New Member Satya, No problem with the accounts. The log is showing that the backup succeeeded and the step "delete old DB backup files" has a red "X" in the "status" however the log says that 1 file was deleted when it wasn't. This is very quirkey. I am thinking about just recreating the maintenance plan from scratch, but would like to know what is going wrong. Thanks. rweinstein, Nov 9, 2004 #2 thomas New Member