SQL Server Agent on RDS / EC2

Question

Hello, Im new on EC2 and RDS, and having difficulties on finding SQL Server Agent on the SSMS i have installed on RDS. i have included the screenshot here. please kindly help to navigate where to look for the SQL Server Agent. thanks in advance.

screenshot

![screenshot](/media/postImages/original/IMRmhziLkhQSa9GFGUet2IQg)

Answer

Is it possible that you have an instance running SQL Server Express? SQL Server Agent is not supported on Express Edition.

Also, if you're logging in with a different user than master, you would need to add the user to the SQLAgentUserRole. Here is the [documentation ](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.Agent.html) reference.

SQL Server Agent on RDS / EC2

相关内容