Good catch Rubes!

You are right Steve. Now I created a user with same name at server level and got logged on by using it. I see now that privileges are more effective,...

thanks for responses. only to clarify, the following is my test by using SQL Server Management Studio:

1. I created a sql server user named "muhammed"

2. mapped it to "mydatabase" existing...