Wednesday, August 01, 2012 5:16 PMI have created a new database in SQL 2008. When I go to the Security tab\Users and then select New User, the user I am expecting does not show up. How do I get users to show up so I can select the one I want? The one's that show up are not the one I need. How do I add a user for selection?
Wednesday, August 01, 2012 5:25 PMAnswerer
When I go to the Security tab\Users and then select New User, the user I am expecting does not show up.
Then the user don't have a server login. In SSMS open node "Security" => "Logins" and add the user first there, then you can add it as database user.
Wednesday, August 01, 2012 5:25 PM
If you have a desired login existed on the server, simply map it. for example as below
CREATE USER [test1] FOR LOGIN [test1]
EXEC sp_addrolemember N'ROLE', N'test1'
Thanks, Satish Kumar. Please mark as this post as answered if my anser helps you to resolves your issue :)