INF: How to Remove the Default Mapping of Windows NT Administrators to SQL Server SA
Article ID: 202446
Article Last Modified on 10/3/2003
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q202446
SUMMARY
In some situations, access control policies may stipulate that the Windows NT Administrator(s) should not be given system administrator (SA) access to SQL Server. A default installation of SQL Server permits members of the local Administrators group to be allowed trusted connections as SA. This article explains how to disallow such connections when necessary.
NOTE: It is not possible to absolutely prevent a Windows NT Administrator from obtaining SA access to SQL Server because the Windows NT Administrator can always add any account to any group, as well as modify registry entries or permissions.
Additional query words: right priviledge priviledges admin admins
Keywords: kbhowto kbinfo KB202446