Thursday, February 16, 2012

BUILTIN\Administrators Login

I would like to remove the BUILTIN\Administrators Login
from SQL Server 2000 for security purposes.
Will there be any problems with SQL Server 2000 running
properly if I do this?
Thank you.Whether you get problems or not depends. The following
article has an more information section with links to some
issues that could come up:
INF: How to impede Windows NT administrators from
administering a clustered instance of SQL Server
http://support.microsoft.com/?id=263712
-Sue
On Mon, 22 Mar 2004 12:58:47 -0800, "Mike"
<anonymous@.discussions.microsoft.com> wrote:

>I would like to remove the BUILTIN\Administrators Login
>from SQL Server 2000 for security purposes.
>Will there be any problems with SQL Server 2000 running
>properly if I do this?
>Thank you.|||Hi,
I had problems in the below when I removed "Syadmin role" from
BuildIN/Administrators. So I have given back the sysadmin role to solve the
issue.
1. FULL Text Indexing
2. Maintenance Plans
So do a test in test server for couple of weeks and then implement in
Production server.
Known issues after removal ,
Some things to be aware of:
Q237604 PRB: SQL Server Agent Does Not Start and Displays Error 18456
Q295034 FIX: MSSearch Takes 100% CPU if BUILTIN\Administrators Removed
Q317746 PRB: SQL Server Full-Text Search Does Not Populate Catalogs
Thanks
Hari
MCDBA
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:d9mu5054kffi4f8olts36mpa8du6um98q9@.
4ax.com...
> Whether you get problems or not depends. The following
> article has an more information section with links to some
> issues that could come up:
> INF: How to impede Windows NT administrators from
> administering a clustered instance of SQL Server
> http://support.microsoft.com/?id=263712
> -Sue
> On Mon, 22 Mar 2004 12:58:47 -0800, "Mike"
> <anonymous@.discussions.microsoft.com> wrote:
>
>

No comments:

Post a Comment