SQL AGENT IS NOT NOT ABLE TO START....

Question

SQL AGENT IS NOT NOT ABLE TO START....

Ratheesh4sql

SSCommitted

Points: 1811
More actions
March 12, 2013 at 10:31 am

#275113

Hi,
Can anyone help me ?
SQL AGENT IS NOT NOT ABLE TO START....Getting an error " The process terminated unexpectedly [0x8007042b] in my development server.
I installed one more instance for that also the same issue is occuring....not able to change for sql agent server user in configuration manager.

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Geoff A SSChampion Points: 11511 More actions · Answer 1

check the file system permissions on the folders where the system databases were installed to verify that the local windows group and or user that runs the agent has the correct permissions.

Ratheesh4sql SSCommitted Points: 1811 More actions · Answer 2

i have given the user for administrator privilege even i tried with administrator user but no luck.

WoundedParrot SSCommitted Points: 1647 More actions · Answer 3

This thread may help.

http://www.sqlservercentral.com/Forums/Topic882222-146-1.aspx

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 4

Are you using the Configuration Manager to change accounts and set rights? You should be.

Ratheesh4sql SSCommitted Points: 1811 More actions · Answer 5

Hi..Thanks for your link..

But unfortunately my issue is not solved changing the Outputlog and user rights.

When i am trying to change the service user itself i am getting an unexpected error...Even if try using administrator.

Ratheesh4sql SSCommitted Points: 1811 More actions · Answer 6

Yes i am using the configuration manager only for changing service account....But no luck

Ratheesh4sql SSCommitted Points: 1811 More actions · Answer 7

hi All,

When i check the event viewer am getting error like

SQLServerAgent could not be started (reason: Unable to connect to server 'Node1\Inst1'; SQLServerAgent cannot start).

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 8

Is this a valid instance name? Is it started?

If you connect to the instance with the same administrator account, does it work?

Ratheesh4sql SSCommitted Points: 1811 More actions · Answer 9

Is this a valid instance name? Is it started?

If you connect to the instance with the same administrator account, does it work?

Yes the instance is able to start with administrator user.......But unfortunately SQl agent is not able to start or set the service account....

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 10

The instance starting has nothing to do with the administrator. I'm asking if you can connect from SSMS with the administrator account, the same one used as the SQL Agent service account.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

ratheesh4sql (3/12/2013)
Hi..Thanks for your link..
But unfortunately my issue is not solved changing the Outputlog and user rights.
When i am trying to change the service user itself i am getting an unexpected error...Even if try using administrator.

What is the exact text of that error?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

kevaburg SSCoach Points: 18131 More actions · Answer 12

I experienced this problem when using using an AD account user as the account to run the Server Agent and forgot to set "Password does not Expire" in the account settings. Spent ages looking for that one......