Prevent unauthorized users from accessing SQL Server 2000
One of the SQL Server 2000 databases that I administer is configured for Windows authentication. I added an integrated logon for the domain user group. However, 20 of those in the domain user group who should not have access to the server are still able to access it. How can I prevent these unauthorized users from accessing the server while making the least number of changes to the server?

Software/Hardware used:
ASKED: June 23, 2009  4:06 PM
UPDATED: June 23, 2009  6:24 PM

Answer Wiki:
Create another domain group for the users you don't want to have access, and put them in the group. Add that group as a Login to the SQL Server, but set the SQL Server to deny access to that login. This will prevent the users from having any access to the SQL Server.
Last Wiki Answer Submitted:  June 23, 2009  6:24 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _