Тёмный

Fix "SQL SERVER AGENT START ACCESS DENIED" 

MS SQL DBA Tech Support
Подписаться 15 тыс.
Просмотров 6 тыс.
50% 1

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.

Опубликовано:

 

21 май 2023

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 8   
@alexsama536
@alexsama536 2 часа назад
tdlr, just start it from services msc
@subbareddy-ho4lx
Hi i am useing NT Service\SQLSERVERAGENT still i am facing access denied issue
@subbareddy-ho4lx
i don't have personal service accounts kindly help me on this issue
@shamilpm262
I have got windows could not start the sql Server Agent (MSSQLSERVER) service on local computer.
Далее
MSSQL - How to configure SQL Proxy and Credentials
9:12
🎙СТРИМ на 4 МИЛЛИОНА🍋
3:12:45
Просмотров 1,3 млн