about MSSQLSERVER run as LocalSystem

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
RateIf 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@.21cn.com> 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
>

about MSSQLSERVER run as LocalSystem

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
Ratehi,
localsystem account doesn't have network priviledges. this is a security
feature.
Peter.
"rate" <spring_pb@.21cn.com> wrote in message
news:O%23a2VHxRGHA.2536@.tk2msftngp13.phx.gbl...
> 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
>
>