question

srivivek avatar image
srivivek asked

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)
loginconnectionauthenticationbuiltin
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Shawn_Melton avatar image
Shawn_Melton answered
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.
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

srivivek avatar image srivivek commented ·
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?
0 Likes 0 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
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
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.