I am trying to map a Login to one of the Databases in the Server Instance. However, I am unable to do so through SSMS.
I have login xxxxxxxx at the Instance Level. I am trying to map this Login to one of the DBs in this Instance. I going to the properties page of the login through Security folder and going to the User Mapping options. I am clicking the check box of the DB that i want say A and clicking on the OK button. The window shows as if it is executing. However, when I check the properties again, this DB remains unchecked.
Is there a script using which we can map a DB to a Login at the Instance level.