By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

SQL Server Agent on RDS / EC2

0

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

Topics
DatabaseMigration & ModernizationAnalyticsCompute
Tags
Microsoft SQL ServerAmazon Relational Database ServiceAmazon EC2DatabaseRDS Custom for SQL Server
Language
English
Poison Ivy
asked a year ago587 views
1 Answer
0

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 reference.

AWS
adrian-AWS
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content