SQL Server Agent Missing in SQL Server Management Studio SSMS

In this article I will explain, how to solve the problem: SQL Server Agent Missing in SQL Server Management Studio (SSMS).

Following are the reasons for SQL Server Agent is missing in SQL Server Management Studio (SSMS).

1. SQL Server Agent is not supported by the SQL Server edition.

SQL Server Developer, Standard, Enterprise and Web editions supports SQL Server Agent.

The following query is to verify SQL Server edition in SSMS.

SELECT SERVERPROPERTY('Edition')

Note: SQL Server Express editions do not support SQL Server Agent.

For downloading SQL Server Developer edition, please refer the following URL Download SQL Server.

2. Login account connecting to SSMS is not a part of sysadmin role.

If the Login account connected to SSMS is not a part of sysadmin role in SQL Server, then SQL Server Agent would not be visible.

In order to check whether the Login account belongs to sysadmin role, the following query will be used in SSMS.

SELECT IS_SRVROLEMEMBER('sysadmin')

If the value is zero, then the logged in user does not belong to sysadmin role and hence you won’t be able to see SQL Server Agent.

Thus, the solution is to log in with user which belongs to sysadmin role in order to use SQL Server Agent.

Description is required.

SQL Server Agent Missing in SQL Server Management Studio (SSMS)