Saturday, February 25, 2012

Agent not running?

Hi I am trying to run na backup and when I run the job manually I get
an error SQL-DMO State 42000, Error 200225 SQLServerAgent is currently
not running and cannot be notified. In the event log I get these two,
but the agent is definitely running. Any ideas?
Thanks
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
You do not have sufficient operating system permission to open the
SQLServerAgent status event.
Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
The data portion of event 17052 from MSSQLSERVER is invalid.Starting the Agent service?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"hals_left" <cc900630@.ntu.ac.uk> wrote in message
news:1162561943.730620.280980@.h48g2000cwc.googlegroups.com...
> Hi I am trying to run na backup and when I run the job manually I get
> an error SQL-DMO State 42000, Error 200225 SQLServerAgent is currently
> not running and cannot be notified. In the event log I get these two,
> but the agent is definitely running. Any ideas?
> Thanks
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> You do not have sufficient operating system permission to open the
> SQLServerAgent status event.
>
> Event Type: Error
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> The data portion of event 17052 from MSSQLSERVER is invalid.
>|||Well the agent has the Green arrow on the icon in EM and when I right
click it, Start is greyed out and Stop is not. In services
SQLSERVERAGENT has the status of started, so Im confused as to why Im
getting this error.
Tibor Karaszi wrote:[vbcol=seagreen]
> Starting the Agent service?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "hals_left" <cc900630@.ntu.ac.uk> wrote in message
> news:1162561943.730620.280980@.h48g2000cwc.googlegroups.com...|||Did you check Agent for the correct instance? Perhaps you have several insta
nces of SQL Server
installed?
Assuming you did, I'd check SQL Server agent's error log for errors as the n
ext step.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"hals_left" <cc900630@.ntu.ac.uk> wrote in message
news:1162833283.408183.293470@.h54g2000cwb.googlegroups.com...
> Well the agent has the Green arrow on the icon in EM and when I right
> click it, Start is greyed out and Stop is not. In services
> SQLSERVERAGENT has the status of started, so Im confused as to why Im
> getting this error.
>
> Tibor Karaszi wrote:
>|||Only 1 instance running. It does work on the schedule when not looged
in though, its only when I manually run the job from EM it fails.Will
check the agent error log
Tibor Karaszi wrote:[vbcol=seagreen]
> Did you check Agent for the correct instance? Perhaps you have several ins
tances of SQL Server
> installed?
> Assuming you did, I'd check SQL Server agent's error log for errors as the
next step.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "hals_left" <cc900630@.ntu.ac.uk> wrote in message
> news:1162833283.408183.293470@.h54g2000cwb.googlegroups.com...

No comments:

Post a Comment