Re: Local system permissions

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

From: "Kim" <John@Doe.com>
Date: Fri, 13 Dec 2002 15:25:23 +0100

Well that didn't work either anyway it might be my system that is corrupt in
some way (its a very old installation with a lot of junk).
I'm in the process of moving it all on a w2k platform, so I didn't want to
spend to much time managing accounts on this server... I solved the problem
by using a regular account instead.

thanks to all

Kim

"Gert E.R. Drapers" <GertD@SQLDev.Net> wrote in message
news:OaIK8hfoCHA.1872@TK2MSFTNGP09...
> I think it is case sensitive, this is what I use for the various account
> type.
>
> -- NetworkService
> exec sp_grantlogin N'NT AUTHORITY\NETWORK'
> exec sp_addsrvrolemember N'NT AUTHORITY\NETWORK', sysadmin
>
>
> -- LocalSystem
> exec sp_grantlogin N'NT AUTHORITY\LOCAL SERVICE'
> exec sp_addsrvrolemember N'NT AUTHORITY\LOCAL SERVICE', sysadmin
>
> -- System
> exec sp_grantlogin N'NT AUTHORITY\SYSTEM'
> exec sp_addsrvrolemember N'NT AUTHORITY\SYSTEM', sysadmin
>
> GertD@SQLDev.Net
>
> Please reply only to the newsgroups.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> You assume all risk for your use.
> Copyright © SQLDev.Net 1991-2002 All rights reserved.
>
> "Kim" <John@Doe.com> wrote in message news:3df86465$1@news.carlbro.dk...
> > 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
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... >> exec sp_grantlogin N'NT AUTHORITY\NETWORK' ... >> exec sp_addsrvrolemember N'NT AUTHORITY\LOCAL SERVICE', sysadmin ... >> Please reply only to the newsgroups. ...
    (microsoft.public.sqlserver.security)
  • Re: Local system permissions
    ... I think it is case sensitive, this is what I use for the various account ... exec sp_grantlogin N'NT AUTHORITY\NETWORK' ... sysadmin ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.sqlserver.security)
  • Re: The Microsoft Search service cannot be administered under the pres
    ... the BUILTIN\Administrator account as well as a member of the Sysadmin role? ... SQL Server Full-Text Search Does Not Populate Catalogs ... you or your server's sysadmin have removed the ... exec sp_defaultdb N'NT Authority\System', N'master' ...
    (microsoft.public.sqlserver.fulltext)
  • Re: NT AuthoritySystem
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... > EXEC sp_grantlogin and received ...
    (microsoft.public.sqlserver.security)
  • Re: what exec?
    ... reason the Exec seem to think that they have the upper hand. ... the Leadership provide Scouting for every member of the Group. ... Oddly, that may have arisen as a consequence of, for some reason, ... are both on cub account and regularly have to sign chqs together. ...
    (uk.rec.scouting)