question

SeshagiriRaoVadrevu-4123 avatar image
0 Votes"
SeshagiriRaoVadrevu-4123 asked SeeyaXi-msft commented

user map is auto unchecking sql?

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

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SeshagiriRaoVadrevu-4123 ,

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.

0 Votes 0 ·

1 Answer

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered SeeyaXi-msft commented

Hi @SeshagiriRaoVadrevu-4123,

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.

· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·
SeeyaXi-msft avatar image SeeyaXi-msft SeshagiriRaoVadrevu-4123 ·

Hi @SeshagiriRaoVadrevu-4123 ,
Run select @@VERSION to check the version
IIf it is not the latest version, I recommend you to update it.

1 Vote 1 ·

will try and let you know

0 Votes 0 ·

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.

0 Votes 0 ·
SeeyaXi-msft avatar image SeeyaXi-msft SchellhammerMichael-4258 ·

Hi @SchellhammerMichael-4258,

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

Best regards,
Seeya

0 Votes 0 ·