|
|
|
Right there with Babe
 
Group: General Forum Members
Last Login: Yesterday @ 6:18 AM
Points: 768,
Visits: 194
|
|
Comments posted to this topic are about the content posted at http://www.sqlserv
Aunt Kathi
Microsoft
(Former SQL Server MVP)
|
|
|
|
|
Right there with Babe
Group: General Forum Members
Last Login: Monday, May 14, 2012 2:37 AM
Points: 732,
Visits: 166
|
|
I find that adding in the 'nt authority\system' account in (as an admin) prior to removing the builtin\admin stops a lot of the pain with 3rd party backup solutions etc.
Steven
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Friday, May 11, 2012 10:52 AM
Points: 251,
Visits: 129
|
|
Here are some more gotchas. Some I have run into and some just came up when I searched for "Builtin Administrators" in the MS Knowledge Base with SQL Server 200 selected as the product. PRB: SQL Server Full-Text Search Does Not Populate Catalogs
http://support.microsoft.com/default.aspx?scid=kb;en-us;317746 BUG: IsAlive check does not run under the context of the BUILTIN\Administrators account in SQL Server 2000 Enterprise Edition
http://support.microsoft.com/default.aspx?scid=kb;en-us;291255 Be especially careful on clusters. See the following article for more information on this topic in relation to clustered instances of SQL Server: INF: How to impede Windows NT administrators from administering a clustered instance of SQL Server
http://support.microsoft.com/kb/263712/EN-US/ There were some other articles that came up in the search but I did not include the ones marked "FIX" or "INF" except for the one clustering article. Basically, make sure everything is working right before you remove this group account. That way, if anything breaks, you know exactly why. Then you can put the group back in and research the proper solution.
Bryant E. Byrd, BSSE MCDBA MCAD
SQL Server DBA
bryant{at}mindfair.com
|
|
|
|
|
Mr or Mrs. 500
Group: General Forum Members
Last Login: Friday, May 18, 2012 7:42 AM
Points: 544,
Visits: 116
|
|
| Do you know where none of my 5 servers (SQL 2000 Std) have the "Via group membership" option in the login propierties screens?
|
|
|
|
|
Right there with Babe
Group: General Forum Members
Last Login: Yesterday @ 6:18 AM
Points: 768,
Visits: 194
|
|
The "Via group membership" option disappeared after I changed the setting. I thought it was odd as well, but I was just glad the problem was solved!
Aunt Kathi
Microsoft
(Former SQL Server MVP)
|
|
|
|
|
Keeper of the Duck
Group: Moderators
Last Login: Friday, May 04, 2012 4:11 PM
Points: 6,553,
Visits: 1,729
|
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Friday, March 03, 2006 11:20 AM
Points: 8,
Visits: 1
|
|
Interesting article. Now that I accidently deleted the the BUILTIN/Admin, how can I add it back in? Thanks for the help Bill
|
|
|
|
|
Keeper of the Duck
Group: Moderators
Last Login: Friday, May 04, 2012 4:11 PM
Points: 6,553,
Visits: 1,729
|
|
|
|
|
|
SSC-Addicted
Group: General Forum Members
Last Login: Today @ 1:27 AM
Points: 447,
Visits: 823
|
|
I've made a point of removing it from new servers once SQL is installed and the service and agent startup accounts are properly set. That way it is out before any databases (other than master etc) or users are created so they are created with the rights and logins they need.
|
|
|
|
|
SSC Rookie
Group: General Forum Members
Last Login: Yesterday @ 10:58 AM
Points: 49,
Visits: 36
|
|
Interesting. Thanks for your comments, especially on the "Through Group Membership" issue.
|
|
|
|
