This is just a quick note, almost a continuation of my Access Denied, Not Possible post. I have been working on some queries for a Default Trace presentation that I am preparing for the Space Coast User Group and SQLSaturday #21 – Orlando, and one of the queries has to do with trying to find logins that have gained access through a Windows Group. Since I am working on my laptop (no domain), I decided to add the Builtin\Administrators group, delete my explicit login, and get access via the group. Interestingly enough, in order to get access to SQL Server via Builtin\Administrators you need to run SSMS as Administrator. Here’s the error I get when not running SSMS as administrator:
No, I do not leave Builtin\Adminstrators as sysadmin on my servers and with SQL Server 2008, I do not have it at all.