Hi Friends,

I observed a strange issue with SQL Server user mapping while creating a login in SQL Server 2012 SP1.

While creating a new login…

1_SQL_Server_2012_strange_issue_with_user_mapping_while_creating_a_login

After entering some required info…

2_SQL_Server_2012_strange_issue_with_user_mapping_while_creating_a_login

When I click on user mapping and select a database…

3_SQL_Server_2012_strange_issue_with_user_mapping_while_creating_a_login

The db_owner role gets selected automatically. This is not how it is supposed to be. Infact, when I click OK the login gets created but actually the role is not applied for the user. When you open the login again and verify from the same page…

4_SQL_Server_2012_strange_issue_with_user_mapping_while_creating_a_login

… the roles is actually not applied. Very misleading !