SQL Server 2008 user mapping mapping is not saved

Question

I am trying to provide a SQL Server 2008 domain user. This user should be able to log into the database using the server management studio and run PowerShell scripts by executing SELECT queries in the database. My problem is that my settings are not saved.

In the server management studio, I right-click on Security-> Logins-> right click on → Properties-> User mappings-> mark my database, which is the first one provided by "db_datareader" and "public". Click OK.

The error does not appear. But when I check user mappings again, my database is no longer marked! What did I miss? Really puzzled ... there must be something very simple ...

- update -:

soved: deleted user login +, added them back, and the rest .. is now normal. many thanks!

Answer 1

use master; GO create login [<domain\user>] from windows; GO use [<yourdb>]; GO create user [<domain\user>] for login [<domain\user>]; GO ALTER ROLE db_datareader ADD MEMBER [<domain\user>]; GO