Tuesday, March 27, 2012

can we delete NT AUTHORITY\SYSTEM in sql server 2005?

Hi Folks,
In our sql server 2005 cluster server, we have a loginuser called
NT AUTHORITY\SYSTEM with sysadmin server role.
What is the purpose of that account?
Can we delete that login?
If we delete that will there be any problems?
We are using separate domain accounts for all sql services.
Please help.
Thank you
--KumarKumar,
Visit following link:
http://support.microsoft.com/kb/263712
NT AUTHORITY\SYSTEM restricts NT ADMIN and help to execute FullText as
FullText need builtin\administrators or NT AUTHORITY\SYSTEM.
Hope this will help.
"Kumar" wrote:
> Hi Folks,
> In our sql server 2005 cluster server, we have a loginuser called
> NT AUTHORITY\SYSTEM with sysadmin server role.
> What is the purpose of that account?
> Can we delete that login?
> If we delete that will there be any problems?
> We are using separate domain accounts for all sql services.
> Please help.
> Thank you
> --Kumarsql

No comments:

Post a Comment