Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

query Expand / Collapse
Author
Message
Posted Monday, November 25, 2013 4:02 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 2:00 AM
Points: 522, Visits: 2,012
i need to find the List of users with access to BUILTIN\SQL Server?

what is BUILTIN\SQL Server account ?
Post #1517489
Posted Monday, November 25, 2013 7:46 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 11:38 AM
Points: 588, Visits: 895
Here is a KB article describing what the BUILTIN\Administrators login is:
http://support.microsoft.com/kb/263712

and here is a blog post about removing the group (which is a bigger deal on 2000 and 2005):
http://www.mssqltips.com/sqlservertip/1017/security-issues-with-the-sql-server-builtin-administrators-group/

To review who is in 'BUILTIN\Administrators' use the following:
EXEC xp_logininfo 'BUILTIN\Administrators', 'members'




Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1517511
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse