SQL Server Performance

Alternative of BUILTINAdministrators Logins

Discussion in 'General DBA Questions' started by sonnysingh, Feb 27, 2008.

  1. sonnysingh Member

    Hi Folks
    Any help on this please......

  2. Jon M Member

    Hello,
    Try this:
    Go to your "Security" folder and right-click the login for BUILTINAdministrators. Under General tab you should see Security access radio buttons: Grant access and Deny access. Choose Deny access and next time you login and you use a userid that is a part of BUILTINAdministrators to let's say register your SQL Server via Enterprise Manager, you will receive an error message like the one below:
    SQL Server registration failed because of the connection failure displayed below. Do you wish to Modify anyway?
    Login failed for user 'MySQLServerAdministrator'
    -OR if via SQL Query Analyzer-
    [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user 'MySQLServerAdministrator'.
    Let me know if this is the solution you want.
    Jon M

Share This Page