Re: about MSSQLSERVER run as LocalSystem

If you need a SQL Server to be able to access other network
resources, including other servers, SQL Server needs to be
running under a domain account. Local System doesn't have
access to network resources.

-Sue

On Tue, 14 Mar 2006 10:39:16 +0800, "rate"
<spring_pb@xxxxxxxx> wrote:

Hi,it is fail when I try to open a namedpipe of another machine in sql2000's
extern storage procedure.

WNetAddConnection2() return 1312
CreateFile() return -1 and GetLastError() return 5

MSSQLSERVER is running as LocalSystem.

If MSSQLSERVER login using a user account, the extern storage procedure can
open the namedpipe of another machine.

Why? someone can give me a little explanation.

Thanks

Rate


.

Relevant Pages

  • Re: Cluster does not restart SQL group after network failure
    ... > and restart the resources on each possible node until the retry count is ... Unfortunately, until the network resource is restored, no node ... including the Network Name and the SQL Server. ... >> virtual SQL and Windows IP address resources went down and did not come up ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster does not restart SQL group after network failure
    ... Unfortunately, until the network resource is restored, no node ... including the Network Name and the SQL Server. ... cluster will bring the system online. ... > virtual SQL and Windows IP address resources went down and did not come up ...
    (microsoft.public.sqlserver.clustering)
  • Re: AUDITORS !!!! AAAAAARRRRGHH
    ... Generally speaking you use a domain account when you need the SQL Server service to be able to interact with other services on the network. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server in DMZ
    ... sql server to a domain account which have access to the ... >> I have a SQL server in DMZ which uses a local account ... >> there any way that this server can backup to a network ...
    (microsoft.public.sqlserver.server)
  • Re: Sharepoint 2003 Backup Error on Network
    ... SQL must be running under a domain account, not the sa accout, in order to ... backup to a network share. ... > COMP1 is the SQL Server Computer name and I assume that the SQL Server ...
    (microsoft.public.sharepoint.portalserver)