Whenever I attempt to start SQL Server Agent I get the following error message: "An error 5 - (Access is denied) occurred while performing this service operation on the SQLServerAgent service"
I log in to the SQL Server as 'sa'. What could be the possible problem?Originally posted by AlveenX
Whenever I attempt to start SQL Server Agent I get the following error message: "An error 5 - (Access is denied) occurred while performing this service operation on the SQLServerAgent service"
I log in to the SQL Server as 'sa'. What could be the possible problem?
What user is set to startup the SQLAgent service? This user must be added in SQLServer logins and give system administrator rights over the SQLServer.
ionut|||The easy way (i think), on Services, try to put the service starting with the "local system account"|||SQL Server uses a windows account to start the sql server agent service. This user should have preferably administrator rights on the machine where the sql server resides. This user can be a local user ( in that case "local system account" is best, as pal19 already mentioned) or, if the sql server has to communicate with other (sql) servers, a domain user account.
You can change the user account that is used in the enterprise manager. Go to management --> sql server agent --> right click and select properties --> general tab. You can also go to the services tab in the Windows administrative tools and change the properties of the sql server agent service there.|||Thanks Jora, Pal19 and Ionut Calin. SQL Server Agent has eventually started. Thanks so much for your help.
AlveenX
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment