Fix "SQL SERVER AGENT START ACCESS DENIED"

Published: 22 May 2023
on channel: MS SQL DBA Tech Support

7,809

See the logs for the exact issue:

1.Provide the permission on the sql server agent folder.
2.Add the sql server agent service account as login with sysadmin. Keep this as a Optional
3.Execute the below commands
USE master;
GO
EXEC sp_configure 'show advanced option', '1'; --Enable advanced options
RECONFIGURE;

EXEC SP_CONFIGURE 'Agent XPs', 1;
GO
RECONFIGURE;
GO
4.start the agent if it is not restarting talk to client for downtime and restart the sql server and start the agent manually using services.msc if not started.

Please do comment if any steps helped you in your real time.

Watch video Fix "SQL SERVER AGENT START ACCESS DENIED" online, duration hours minute second in high quality that is uploaded to the channel MS SQL DBA Tech Support 22 May 2023. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 7,809 times and liked it 18 visitors.

10,484