Re: Local system permissions

From: SQL Server Development Team [MS] (sqldev@microsoft.com)
Date: 12/02/02 

From: "SQL Server Development Team [MS]" <sqldev@microsoft.com>
Date: Mon, 2 Dec 2002 10:05:08 -0800

sp_grantlogin [nt authority\system] will allow "localsystem" to log in to
SQL Server, then sp_addsrvrolemember [nt authority\system], sysadmin to
make the login a member of sysadmin. Incidentally this will also allow
full-text search (mssearch) to work. 

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Kim" <John@Doe.com> wrote in message news:3de74b6b$1@news.carlbro.dk...
> Hi
>
> I have been restricting permissions on our databases, which resulted in
that
> I removed the builtin administrator group and created a new group for
DBA's
> only.
> It works fine...but when our backup program - a third party product -
which
> runs under the local system account tries to make a backup of the
databases
> it get an access denied.
>
> How can I reapply  (sa) permissions to the local system account?
>
> thanks
>
> Kim
>
>

Relevant Pages

  • Re: Local system permissions
    ... >> I have been restricting permissions on our databases, ... >> How can I reapply permissions to the local system account? ...
    (microsoft.public.sqlserver.security)
  • Local system permissions
    ... I have been restricting permissions on our databases, ... I removed the builtin administrator group and created a new group for DBA's ... runs under the local system account tries to make a backup of the databases ... How can I reapply permissions to the local system account? ...
    (microsoft.public.sqlserver.security)
  • Re: Local system permissions
    ... I support the Professional Association for SQL Server and its user community ... > I have been restricting permissions on our databases, ... > How can I reapply permissions to the local system account? ...
    (microsoft.public.sqlserver.security)
  • Re: Service slow starup
    ... would not be able to load up the databases. ... Local System account, the process immediatly shows up in Task Manager's ... When I start under Administrator account, ... process immediatly consumes 80MB, ...
    (microsoft.public.windows.server.general)