SQLServerAgent security context does not have server-autorestart privileges. 
Author Message
 SQLServerAgent security context does not have server-autorestart privileges.
Hi group,
    We have suddenly started getting the message 'SQLServerAgent security
context does not have server-autorestart privileges.' in our application
event log, once every 5 seconds, which is v v annoying! It is SQL Server 7
running on NT4 server. Anybody got any ideas where I should look?

TIA,

Paul



Sat, 28 Feb 2004 18:19:32 GMT
 SQLServerAgent security context does not have server-autorestart privileges.

It sounds like someone changed the account or the privlageges of the account
that the SQL Agent runs under.

--
Andrew J. Kelly,  SQL Server MVP
TargitInteractive

I proudly support the PASS SQL Server user community and its upcoming user
event,
 PASS 2001 North America. For details, visit <http://www.sqlpass.org>
www.sqlpass.org.)


Quote:
> Hi group,
>     We have suddenly started getting the message 'SQLServerAgent security
> context does not have server-autorestart privileges.' in our application
> event log, once every 5 seconds, which is v v annoying! It is SQL Server 7
> running on NT4 server. Anybody got any ideas where I should look?

> TIA,

> Paul



Sat, 28 Feb 2004 20:17:04 GMT
 SQLServerAgent security context does not have server-autorestart privileges.
Hi Andrew,
    I have checked the account that SQL uses, and it is the same as it has
been for several months, error free. It has also been tried as the domain
administrator account, still with no joy. :(

Any and all advice will be gratefully received.

Paul
--



Quote:
> It sounds like someone changed the account or the privlageges of the
account
> that the SQL Agent runs under.

> --
> Andrew J. Kelly,  SQL Server MVP
> TargitInteractive

> I proudly support the PASS SQL Server user community and its upcoming user
> event,
>  PASS 2001 North America. For details, visit <http://www.sqlpass.org>
> www.sqlpass.org.)



> > Hi group,
> >     We have suddenly started getting the message 'SQLServerAgent
security
> > context does not have server-autorestart privileges.' in our application
> > event log, once every 5 seconds, which is v v annoying! It is SQL Server
7
> > running on NT4 server. Anybody got any ideas where I should look?

> > TIA,

> > Paul



Sat, 28 Feb 2004 20:50:08 GMT
 SQLServerAgent security context does not have server-autorestart privileges.
Paul,

In BOL following is stated :
heading : Creating SQL Server Services User Accounts
Service                     Permission
Functionality
SQLServerAgent     Member of the Administrators local group         Use the
autorestart feature

Could it be your serveragent user has been removed from the local
administrators group ?

Jobi


Quote:
> Hi Andrew,
>     I have checked the account that SQL uses, and it is the same as it has
> been for several months, error free. It has also been tried as the domain
> administrator account, still with no joy. :(

> Any and all advice will be gratefully received.

> Paul
> --



> > It sounds like someone changed the account or the privlageges of the
> account
> > that the SQL Agent runs under.

> > --
> > Andrew J. Kelly,  SQL Server MVP
> > TargitInteractive

> > I proudly support the PASS SQL Server user community and its upcoming
user
> > event,
> >  PASS 2001 North America. For details, visit <http://www.sqlpass.org>
> > www.sqlpass.org.)



> > > Hi group,
> > >     We have suddenly started getting the message 'SQLServerAgent
> security
> > > context does not have server-autorestart privileges.' in our
application
> > > event log, once every 5 seconds, which is v v annoying! It is SQL
Server
> 7
> > > running on NT4 server. Anybody got any ideas where I should look?

> > > TIA,

> > > Paul



Sat, 28 Feb 2004 21:34:58 GMT
 SQLServerAgent security context does not have server-autorestart privileges.
Make sure the accounts which start Both SQLServerAgent and MSSQLServer
services are  part of the local administrators
group. Only then will you not see this message.
Gautam Udeshi
Microsoft SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. ? 2001 Microsoft Corporation. All rights
reserved.



Sun, 29 Feb 2004 13:05:46 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Error: [LOG] SQLServerAgent security context does not have server-autorestart privileges

2. SQLServerAgent security context does not have server-autorestart privileges

3. SQLServerAgent does not have server-autorestart privileges.

4. SQLServerAgent does not have server-autorestart privileges.

5. SQLServerAgent does not have server-autorestart privileges.

6. SQLServerAgent security context does not have server-autorestart privileges.

7. SQLServerAgent security context does not have server-autorestart privileges.

8. SQLServerAgent security context does not have server-autorestart privileges.

9. SQLServerAgent security context does not have server-autorestart privileges.

10. SQLServerAgent security context does not have server-autorestart privileges.

11. SQLServerAgent as local account spews server-autorestart error

12. SQL Agent server-autorestart privileges


 
Powered by phpBB® Forum Software