Re: Local system permissions

From: Kim (John@Doe.com)
Date: 12/12/02 

From: "Kim" <John@Doe.com>
Date: Thu, 12 Dec 2002 10:32:54 +0100

It will not recognize [nt authority\system] as an account....?

btw: I'm using SQL Server 7.0

-Kim

"SQL Server Development Team [MS]" <sqldev@microsoft.com> wrote in message
news:#VrZ3zimCHA.2644@tkmsftngp02...
> 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)