Home > IT Answers > Microsoft Windows > Prevent unauthorized users from accessing SQL Server 2000
SQL Server Ask the Experts
2,585 pts.
 Prevent unauthorized users from accessing SQL Server 2000
Integrated Logon, SQL Server 2000, SQL Server security, Windows authentication
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
RELATED QUESTIONS
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.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _