not able to connect sql server after dropping Builtin\admin
On one of our servers we have droped the Builtin\\admin from the sql server logins, which created an issue for the users to connect to the sql server using windows authenticaion. Users who are using sql login account are able to connect with out any issue. But this didn't happen on any other servers. (we fixed the issue by adding the builtin\\admin.)
what might be the reason for this?
And one more question is even our group (Sql DBA) is also using windows authentication why didn't we face the same issue? (we were able to login without any issues)
If you removed the BUILTIN\\Administrators group and your users where then not able to connect, I would review what groups those Windows accounts are apart of.
Since your account is part of a group that has a login within the instance of SQL Server (SQL DBA), you were still able to access it.
can you please tell,how to check who is the members of Builtin\Administrators,
Is the Builtin\administrator which appears in the sql login same as the administrators group at Windows level?
this link
http://www.sqlservercentral.com/Forums/Topic459568-359-1.aspx has some discussion about what to do with the BUILTIN\\Administrators account and this link
http://support.microsoft.com/kb/932881 has info about the group itself
