Home > IT Answers > SQL Server > Prevent unauthorized users from accessing SQL...
SQL Server Ask the Experts
2435 pts.
0
Q:
Prevent unauthorized users from accessing SQL Server 2000
SQL Server 2000, Windows authentication, Integrated Logon, SQL Server security
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?
ASKED: Jun 23 2009  4:06 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
47055 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Jun 23 2009  6:24 PM GMT by Mrdenny   47055 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0