Re: Granting login and access privileges to LocalSystem

From: Mary Bray (no_at_spam.com)
Date: 09/29/04


Date: Wed, 29 Sep 2004 19:53:57 +1000

You need to run sql under a domain user account - local system cannot be
used for cross server communication.
What is it that you need SQL to do?

"Eskimo" <Eskimo@discussions.microsoft.com> wrote in message
news:9E17CB4E-9A8B-4AE9-B75A-F0CB5C49AD0E@microsoft.com...
> Hi,
>
> Our software runs services that access a SQL Server 2000 database that is
> located somewhere on the domain. The services use the LocalSystem
> credential.
>
> How can I grant SQL login access and DB read/write access to a specific
> LocalSystem account on a SQL server?
>
> Example: On domain 'Domain1', I want to grant the LocalSystem account of
> the
> 'Server1' system login access to the SQL server located on the 'Server2'
> system.
>
> How can this be done?
>
> Thanks in advance for your help.
>
> --
> The Eskimo



Relevant Pages

  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... issues, such as a server that might have IIS running on the same machine, ... applicable to SQL 2000 environment, ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • RE: MP Install issue
    ... Where in the installation are you talking about specifying the account rather ... > MPDB ERROR - CONNECTION PARAMETERS ... > SQL Server Name: servername ... > with a trusted SQL Server connection. ...
    (microsoft.public.sms.setup)
  • Re: SQL Express Fails with Hardware Error
    ... The LocalSystem account is a built-in account, ... which the SQL Service runs. ... MCSE, CCEA, Microsoft MVP - Terminal Server ... Minimum Hardware Requirement (Warning) ...
    (microsoft.public.sqlserver.setup)
  • Re: Replication across non-trusted domains requires Win2k Application server and not Domain Controll
    ... you can do it by using SQL authentication instead of NT authentication. ... that the SQL Agent account on your subscriber has rights to read it. ... Or is it possible to install SQL server ... > upon a Windows 2K Domain Controller(Server with Active directory ...
    (microsoft.public.sqlserver.security)
  • Re: Replication across non-trusted domains requires Win2k Application server and not Domain Controll
    ... you can do it by using SQL authentication instead of NT authentication. ... that the SQL Agent account on your subscriber has rights to read it. ... Or is it possible to install SQL server ... > upon a Windows 2K Domain Controller(Server with Active directory ...
    (microsoft.public.sqlserver.replication)