Error 14258

Hi,

I am new to the organization that I am working and we are running SQL Server 200O server. System has been working fine till last couple of days (It running for past two years).

SQLAGENT.exe has been using almost 50% of the CPU time so yesterday I started the SQL server. I want to modify some of the SQL server JOB but when I click on the properties of any job it gives me the following error:

"Error 14258 - Cannot perform this operation while SQL server agent is starting. Try again later."

I checked SQLAGENTSERVICE service and it is started also in the service manager it shows as started. We have a backup job scheduled for 5 days of the weeks but since last 10-12 days it is not running.

Our SQL Server is configured for thread mode processing. I checked for this error in www.support.microsoft.com but the solution given there is something to do with the fiber mode processing.

Could any body tell me why am I getting this error and what is the work around. Everything has been working fine till last two weeks back. Off course SQL server is running as the base product and no service packs have been applied. Other than applying the service pack is there any other solution, since things have been working fine.

Regards

VbabsDid you restart the MSSQLServer service as well ? Have you rebooted the server ? What version of sql are you using including service pack ? What do the logs report back to when this first started (look at both sql server and event logs) ?|||Originally posted by rnealejr
Did you restart the MSSQLServer service as well ? Have you rebooted the server ? What version of sql are you using including service pack ? What do the logs report back to when this first started (look at both sql server and event logs) ?

Hi,

I have rebooted server twice and all the service including SQLAGENTSERVICE show started. MSSSQLSERVER service stopped and restarted and server is working fine. As I have written erlier, NO SERVICE packs have been applied so far, it is running on the base product (ORIGINAL SQL SERVER 2000). This has been working for past two years (from 2001 onwards) and just last two days back this error poped up.

Also after now 72 hours of restart the agent service shows the same status (STARTED) but in the enterprise manager it still gives the same error.

Help!!!

Cheers

Vinod|||What is displayed in the sql server agent log (as well as the sql logs) when this error is returned ? Also, update your ss to the highest service pack that you can.sql