I can login as the user in my SQL Server but I am unable to access the database. Whenever I try to access it the screen shows the Microsoft SQL server error 229 showing that the Select permission was denied. I can’t understand a better way to remove it. Help me find a solution. Thanks in advance. The screenshot of the error is below:
I will try to give a try to solve this. I had also faced the similar error and was able to resolve it . I think it’s because the user doesn’t have the necessary permission to access the database. Firstly you should check whether the user is assigned to proper Server Role, User Mappings and check the schemes he has the permissions to. Still if you are getting an error then you should go to ‘Permissions’ in the properties. The SQL server provides permissions to particular data objects through which they can get access permissions. Follow the link to see and understand.
Now you have to set the Database Role Membership permissions on the database. Now click on the database having the issue and select General. After this inside the window, you will “Database Role Membership” section. Select db_datareader, db_owner options as ticked.
Now the error would be removed.
