[dba-SQLServer] Users in SQL Server

jwcolby jwcolby at colbyconsulting.com
Sun Dec 4 09:59:19 CST 2011


Several times now I have run into an issue where SQL Server does not have a pair of users I use for 
my Access application called DiscoAdmin and DiscoApp.  The problem is that one of the the databases 
that I am picking up on that server was already set up and has those users.  When I try to set those 
users up in the server's security it tells me that "the server principal 'DiscoApp' already exists. 
  Basically I am able to create the user but not assign rights  - db_reader, db_writer etc.

I have always been fuzzy about how this stuff works and I just need an explanation of why it won't 
allow me to set these rights even though the user exists and the check boxes are enabled when I 
select that database.  I just discovered that if I delete the user out in that database and then set 
the rights through the user back in the server security stuff it happily accepts my changes and 
re-adds the user to the database.  This just seems strange.  If I don't do this rigamarole then I 
have a DiscoApp in the database with a set of rights for that database but when I look at it back at 
the server level it does not reflect those rights for that user for that database.

Any assistance great fully accepted.
-- 
John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it




More information about the dba-SQLServer mailing list