Re: windows service

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

I think that the LocalSystem does has permission to access the network, I
have a couple of processes running as LocalSystem and they listen to and
send/receive data over the network.

Maybe the OP is running the SQL server with win. auth.

Why don't you put a try/catch when you open the connection and perform the
DB operations?

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation


"Nicholas Paldino [.NET/C# MVP]" <mvp@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:uoGeM$3PFHA.2520@xxxxxxxxxxxxxxxxxxxxxxx
> J,
>
> The LocalSystem account does not have permissions to access the network
> either. You need to use the NetworkService account in order to access the
> network (assuming the SQL server is on another machine or you are
> accessing it through TCP/IP on the same machine).
>
> Hope this helps.
>
>
> --
> - Nicholas Paldino [.NET/C# MVP]
> - mvp@xxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> "J" <j@xxxxxxxxxx> wrote in message
> news:rdun5199k0i3jhcg98q1e7g6nrq2f6e8g5@xxxxxxxxxx
>> Well, the account for the windows service is set to "LocalSystem", and I
>> have
>> assigned user id and password for the SQL server connection string.
>>
>> Any idea?
>> Thanks.
>>
>>
>> On Tue, 12 Apr 2005 09:36:03 -0700, "Salvador"
>> <Salvador@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>>
>>>Hi,
>>>
>>>The first thing that you should notice is that the service uses another
>>>account to run, maybe you have a permissions issue. Try to load your
>>>server
>>>with your user and check again.
>>>
>>>hope this helps
>>>Salva
>>
>
>


.

Relevant Pages

  • Re: Getting User Name
    ... If your users log into a network, ... can't seem to capture the unique ID. ... The SQL database is running with user permissions for our ERP ... permissions can be carried from SQL Server. ...
    (microsoft.public.access.forms)
  • Re: How to Backup Database File Location In Network Drive ?
    ... account with permissions to the network share used for backup. ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: run services as?
    ... permissions on the host. ... you can always monitor what account is accessing ... they have no network access. ... and give permissions on the SQL Server folders to this group. ...
    (microsoft.public.sqlserver.setup)
  • How to determine what permissions are required for an assembly
    ... I need an application to load signed assemblies from the network share. ... assembly in the network share connects to SQL Server database using the SQL ... assembly gets "Local_Intranet" permissions. ...
    (microsoft.public.dotnet.security)
  • Re: 2 pc network - cant see host files from pc 2 on pc 1
    ... Assuming that you have firewall protection via your internet router try ... workgroup because it will be needed for the network to work correctly. ... see if you can access TCP ports 139 and 445 on computer one of which at ... permissions. ...
    (microsoft.public.windowsxp.security_admin)