Re: SQL Server 2005: Error 14258...SQL Server Agent is starting
- From: "Ciprian Gerea [MSFT]" <Ciprian.Gerea@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 28 Feb 2006 18:09:38 -0800
Did you look at the SqlAgent log? That should give more information about
the state of the agent service. You can find the log in the equivalent of
c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\sqlagent.out.
--
Ciprian Gerea
SDE, SqlServer
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jill" <Jill@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B4F66222-5AD6-4832-8FCF-FAE8D1D78CDC@xxxxxxxxxxxxxxxx
When ever I try creating a job under SQL Server 2005 I get the error
message:
"Error 14258: cannot perform this operation while SQL Server Agent is
starting; try again later".
When you look under services the service looks like it has already
started.
If you try stopping the SQL Server Service or the Agent service from the
services screen they both lock up because the agent will not stop.
I am running SQL Server 2005 on Windows server 2000 SP4 under NT security.
After checking TechNet I did notice the question from Vsiat which looked
like the same problem under SQL Server 2000 where the problem was light
weight pooling this is not my problem.
Has anyone got any ideas.
--
Jill
.
- Prev by Date: ANN: Version 2.6 of SQLExecMS is released.
- Next by Date: Re: email notificaiton when log files are getting large
- Previous by thread: ANN: Version 2.6 of SQLExecMS is released.
- Next by thread: Re: SQL Server 2005: Error 14258...SQL Server Agent is starting
- Index(es):
Relevant Pages
|
