Home / Questions / 469869
Accepted
F. Gabriel Sosa Rozzi
Asked: 2022-07-20 12:59:00 +0800 CST 2022-07-20 12:59:00 +0800 CST

No access to create maintenance plan, having privileges as sysadmin

  • 772

Context: I recently got a job as a Junior DBA at a local company. They ordered me to make maintenance plans on a database and after investigating I found that SQL Server should have options from administration to generate them, as long as I log in to the server with a user that has sysadmin permissions (according to Microsoft documentation).

The fact is that I have such permissions and still do not have access enter image description here enter image description here

Any related information is greatly appreciated.

sql-server

1 Answers

  1. Best Answer

    You probably don't have an edition of SQL Server that can work with maintenance plans.

    If you have a version that is not supported by Agent, you cannot create maintenance tasks.

    • 2