Re: windows service

Willy,

If the SQL server is on another machine, and the service is running
under the Local System account (which doesn't have network access), then
yes, it will be an issue.

--
- Nicholas Paldino [.NET/C# MVP]
- mvp@xxxxxxxxxxxxxxxxxxxxxxxxxxx

"Willy Denoyette [MVP]" <willy.denoyette@xxxxxxxxxx> wrote in message
news:euDGRD4PFHA.604@xxxxxxxxxxxxxxxxxxxxxxx
>
> "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.
>
> OP said he was using a SQL server connection string specifying explicit
> credentials, so the service account is not an issue here.
>
> Willy.
>
>


.

Relevant Pages

  • Re: Trusted SQL Connections & NT AUTHORITYNETWORK SERVICE
    ... SYSTEM account in terms of the credentials it uses on the network. ... hitting a SQL Server on the same machine as the web app. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: backing up to network share issue.
    ... I guess I was confused by your later text where I read it as if you stated that it would be the Agent account ... Tibor Karaszi, SQL Server MVP ... >> impersonation when it accesses the backup file on behalf of the SQL Server ... >>> As Tibor stated, this is not an SQL Server issue, it is a network ...
    (microsoft.public.sqlserver.msde)
  • Re: Unable to Backup on Network
    ... service accoutn from the 'Local System' account to a specific account. ... I like to log in to the SQL server console as the service account to test ... > The operating system on which my SQL Server 2000 is there is Windows 2000> Server while i want to take the backup on another computer on network which> also has same operating system. ...
    (microsoft.public.sqlserver.security)
  • Re: 18456 Login failed for user NT AUTHORITYSYSTEM
    ... > No, not using fulltext Searching. ... > problem and had ruled it out but had not though about tracing the account. ... >> system and is unable to connect to SQL server. ...
    (microsoft.public.sqlserver.server)
  • Re: Login via Anonymous Authentication via IIS
    ... "Dan Guzman" wrote: ... the network). ... given the login failed message references that account;-) ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)