Msg 15410, Level 11, State 1


Error:
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.

Cause
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

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

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

Advertisements

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

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s