AmazonRDS SQL Server User

I need to add a SLQ Server login on our AmazonRDS Instance.

Can't run it with Create Login code because I am getting the message(s) below.

How can I add the USer through the EC COnsole?

Msg 50000, Level 15, State 1, Procedure rds_create_login_trigger, Line 105
Unable to modify or set default database for logins when mirroring is enabled as these changes cannot be applied to the mirror
Msg 3609, Level 16, State 2, Line 1
The transaction ended in the trigger. The batch has been aborted.
Msg 15007, Level 16, State 1, Line 3
'WrkCrm' is not a valid login or you do not have permission.
Who is Participating?
lrbristerConnect With a Mentor Author Commented:
It has to do with Added Group in RDS Documentation
Found my own solution
Pawan KumarDatabase ExpertCommented:
You have a trigger called Procedure rds_create_login_trigger --- This is not allowing you to create login.

It says you cannot create logins since mirroring is enabled and these changes cannot be applied to the mirror.

Can you check the trigger code?

WrkCrm is a valid login correct ?
Pawan KumarDatabase ExpertCommented:
@Author - Any update on this :)
lrbristerAuthor Commented:
None yet
Still looking for a answer
There is only the master login
I am trying to add another login
lrbristerAuthor Commented:
Found my own solution
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.