When I am asked why I want to do this, I really got upset. Just answer my question and stop asking me why! Should I tell you I do not want to share my password? Must be a "won't fix" or "by design" scenario where I should only create one user. Ok, Ok, all my fault.
Anyway, here is the procedure:
I use Visual Studio 11's Server Explorer and then create a "new query" from right-click menu.
- Create login in the master database
CREATE LOGIN login0 WITH password='< your password >
- create user in the database you want to login, remember to switch out of master database
CREATE USER user0 FROM LOGIN login0;
- grant permission to the user
the last step is to set up the permission by choose one of the following