- Windows Authentication
- SQL Server AND Windows Authentication
- The security mode is set to SQL Server and Windows, and
- You know the password of SQL Server's sa login
- Open SQL Server Enterprise Manager
- Expand the nodes to reveal your SQL Server instance
- Expand your SQL Server instance node to reveal the various nodes
- Expand the Security node and click Logins
- Right-click the BUILTIN\Administrators login and click Delete, click Yes when prompted for confirmation
Referred:
http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/cc3339b8-24f4-4e5a-ae2f-fd491e93864d
No comments:
Post a Comment