October 11, 2012 at 11:38 pm
Hi,
I am having strange issue with my SQL 2008 R2 Server. We have an active-active cluster with 2 different instances running on it. On one of the instance which is installed recently, when I add windows users and assign db_reader & db_writer permissions but users are not able to write anything to database. We have similar setup in another location where everything works fine as expected. I have compared all permissions and roles. It is not a complex permissions to miss anything. No problem for users with sysadmin permissions.
At the moment I don't have any clue whats wrong? Is SQL 2008 R2 installation could be corrupted or some components missing?? Any help is greatly appreciated.
October 12, 2012 at 3:09 am
Check if you accidently checked db_denydatawriter for the login.
October 12, 2012 at 4:22 am
Check your database for deny.
USE [DATABASE]
SELECT user_name([memberuid]) as [Username], User_Name([groupuid]) as [Role_Name]
FROM [sys].[sysmembers]
where User_Name([groupuid]) = 'db_denydatareader'
Something with the public role?
October 12, 2012 at 5:48 am
Thanks for your suggestions. But unfortunately, db_denywriter is not selected and it is confirmed. If I give the user sysadmin role, he is able to do everything. But only db_writer is not working. I am not sure if I can attach any screenshots for your better understanding. Any log file which can help to assess?
October 12, 2012 at 5:53 am
Did you check wether the mapping is correct for your login?
October 12, 2012 at 6:38 am
Yes, I verified it is mapped to db_reader, db_writer & public for the respective databases
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply