Msg 15410, Level 11, State 1

Msg 15410, Level 11, State 1, Server Server\INST2, Procedure
sp_addrolemember, Line 75
User or role ‘mydomain\JShah’ does not exist in this database.

Login already has an account under a different user name on particular database. For example mydomain\JShah user is mapped to database as user name jshah

ALTER USER [jshah] WITH NAME=[mydomain\jshah]
execute sp_AddRoleMember ‘DBRole’,’mydomain\jshah’

We can pass the actual user name
execute sp_AddRoleMember ‘DBRole’,’jshah’

Thanks for the comment, will get back to you soon... Jugal Shah

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s