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.