April 10, 2009 at 3:24 pm
A customer of ours is running Windows Server 2008 and SQL 2008. SQL Backups (BAK & TRN) & Integrity Check have not been running since the maintenance plan was set up. We had tested the jobs on setting up the maintenance plan, and those test still show as succesful while all subsequent jobs have failed.
I tried to delete the maintenance plan to recreate it today and got the following error message:
Exception has been thrown by the target of an invocation. (mscorilib)
Additional Information:
Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456)
The errors that show in the History for each job are pretty much the same, as follows:
Stop failed for Job 'xxxxx_Full backup'
Additional Information:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
SQLServerAgent Error: Request to stop job xxxxx_Full backup (from User sa) refused because the job is not currently runing. (Microsoft SQL Server: Error 22022)
I tested by creating a new Maintenance Plan in hopes I could at least get the backups working. When I attempted to run the job, it failed as above. I was, however, able to delete this newly created plan without errors.
Any suggestions?
April 11, 2009 at 4:31 am
It sounds like you've set up the maintenance jobs or the sql agent, or both, to run under the 'sa' login and the password is not correct. Try running under a domain account that belongs to the admin role.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 14, 2009 at 11:23 am
Well, I've uninstalled and reinstalled SQL. I'm currently in the process of uninstalling and reinstalling another time (this time I'll be removing the existing SQL folders and removing the SQL registry tree).
Clean install of SQL, and I set up a maintenance plan to do full backup of the Master database. I try to run the job, and still get the error. Full error as follows:
===================================
Stop failed for Job 'MaintenancePlan.Subplan_1'. (Microsoft.SqlServer.Smo)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Stop+Job&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Smo.Agent.Job.Stop()
at Microsoft.SqlServer.Management.SqlManagerUI.StopAgentJobs.StopJobAction.DoAction(ProgressItemCollection actions, Int32 index)
at Microsoft.SqlServer.Management.SqlStudio.Controls.ProgressItemCollection.DoWorkOnThread()
===================================
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
at Microsoft.SqlServer.Management.Smo.Agent.Job.Stop()
===================================
SQLServerAgent Error: Request to stop job MaintenancePlan.Subplan_1 (from User pylmansrv2k8\Administrator) refused because the job is not currently running. (.Net SqlClient Data Provider)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=22022&LinkId=20476
------------------------------
Server Name: PYLMANSRV2K8
Error Number: 22022
Severity: 16
State: 1
------------------------------
Program Location:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
April 14, 2009 at 4:36 pm
Is your SQL Agent enabled? and also did you check registry keys, just my two cents.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply