sql server agent

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Agent » sql server agent

sql server agent

Rate Topic

Display Mode

Topic Options

Author

Message

sunandas

Posted Wednesday, February 25, 2009 4:40 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 14, 2009 1:31 AM
Points: 177, Visits: 108

Hi,

My sql server agent services is not starting.I just cant understand why this thing happened suddenly.Though i tried several times and tried to start both by automatic & manually.Also I restart the server but there is no change.And one funny thing is that though I have unregistered the EM from server but it is coming automatically.So I cant understand how this thing possible.

Please help me out to find a solution and to start my sql server agent services.

Regards.
Sunanda

Post #664116

Rhythmfree

Posted Sunday, March 01, 2009 10:53 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 03, 2009 9:36 PM
Points: 9, Visits: 52

Sunanda,

Restart your machine and Start SQL Server Manually..

Thanks,
Rhythmfree

Love is life & love is blind, love demands giving and sacrifice, still love is love. Nobody knows what is it..?

Post #666354

raj acharya

Posted Tuesday, March 03, 2009 12:18 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 17, 2012 7:07 AM
Points: 186, Visits: 343

hi,

do one thing... goto services... in run type services and then in services ...
sql server agent(mssqlserver) try to restart or start from here.... is there any positive result if no then
go to properties of that services in logon change account and try it must be run... you can set network services or administrator account ... try this and tell me

Raj Acharya

Post #667067

Sakthivel Chidambaram

Posted Tuesday, March 03, 2009 2:11 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, March 21, 2013 5:40 PM
Points: 309, Visits: 807

Hi,
Check event log for more info and error message on why it is not starting.

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc

Post #667103

sunandas

Posted Tuesday, March 03, 2009 2:16 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 14, 2009 1:31 AM
Points: 177, Visits: 108

I have checked from all sites.
But ur suggestion worked out.Actually i had to change from properties of sql server agent.

Regards.
Sunanda

Post #667104

Sakthivel Chidambaram

Posted Tuesday, March 03, 2009 4:27 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, March 21, 2013 5:40 PM
Points: 309, Visits: 807

Nice to see that it worked...

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc

Post #667163

« Prev Topic | Next Topic »

Permissions