user map is auto unchecking sql?

Question

user map is auto unchecking sql?

Seshagiri Rao Vadrevu 101

hi all,

iv tried to give access to a specific db for a user, via gui ( instance -> security -> logins -> user -> right click properties -> user mapping )

where I'm checking map -> and gave access as a DB writer and clicked ok

the task executed successfully but when I check the user there is DB writer permission but the map is getting un-checked automatically

can anyone help me fix this

Seeya Xi-MSFT 16,756 Reputation points

2021-07-21T06:37:18.89+00:00

Hi @Seshagiri Rao Vadrevu ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

2 answers

Your answer

Seeya Xi-MSFT 16,756 Reputation points

2021-07-21T06:37:18.89+00:00

Hi @Seshagiri Rao Vadrevu ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Answer 1

JEFFREY WONG 0

To whom it may concern,
This fixed this issue for me:

Use [database]
grant connect to [user]

0 comments

Answer 2

Seeya Xi-MSFT 16,756

Hi @Seshagiri Rao Vadrevu ,

the task executed successfully but when I check the user there is DB writer permission but the map is getting un-checked automatically

Did you restart SSMS and try again? What‘s your version?
Does your user actually have permission to write?

Best regards,
Seeya

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Seshagiri Rao Vadrevu 101 Reputation points

2021-07-16T02:09:30.42+00:00

it's a remote desktop connection, iv restarted ssms multiple times and the user actually db reader writer and public access checked.. when I check the map box next to that database name which that user has access to, and click ok.. it is executing it but. when you open user properties again it appears unchecked user map.. but when you select that DB .. the user still has DB reader, writer, and public boxes ticked but the map checkbox keeps unchecking, no matter how many times you try
Seeya Xi-MSFT 16,756 Reputation points

2021-07-16T05:49:18.697+00:00

Hi @Seshagiri Rao Vadrevu ,
Run select @@VERSION to check the version
IIf it is not the latest version, I recommend you to update it.
Seshagiri Rao Vadrevu 101 Reputation points

2021-07-19T03:22:12.087+00:00

will try and let you know
Schellhammer, Michael 1 Reputation point

2021-07-27T15:50:25.407+00:00

I have run into this same issue. We made sure we are running the most recent version, have even rebooted the machine. We are assigning group rights to a database. We grant them rights to the database, add datareader and datawriter. Runs OK, but when we go back in, the database is unchecked. If we select the database though (click the name, not the checkbox) , we can see that datareader and datawriter are enabled. I will say that this group is from a different domain than what the server is on. We have granted rights to other databases on this server though without any issues.
Seeya Xi-MSFT 16,756 Reputation points

2021-07-28T03:17:10.837+00:00

Hi @Schellhammer, Michael ,

So it is not SSMS issue.
Alternatively, you can also create a new Login user.

Best regards,
Seeya