October 12, 2012 at 5:49 am
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 10:26 am
Can you check the DB if those users are disabled?
October 12, 2012 at 11:13 pm
User is newly added and I can login to the database with the same user ID. Only problem is with write access to the database. When I check the error details, it says you are not the database owner.
October 15, 2012 at 11:56 am
Can you check if the user has added to the role
db_denydatawriter
October 15, 2012 at 5:49 pm
I have already checked it and confirmed that only db_reader, db_writer & public were selected
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply