Windows Service Login Failed when accessing SQL.

From: Evan Camilleri (evan_at_holistic.com.mt.nospam)
Date: 11/02/04 

Date: Tue, 2 Nov 2004 18:30:51 +0100

Windows Service Login Failed when accessing SQL.

I have a problem for a Windows Service to login on an SQL server (different
machine) - neither Windows Authentication nor SQL Authentication worked.
LOGIN FAILED FOR USER sa (for example).

If SQL Server is on the same PC of the Windows Service the connection works
OK.

The same code works in a Windows Form using same user and authentication
methods to the SQL Server on a different machine.

Thanks for any help!

Evan Camilleri

Relevant Pages

  • Windows Service Login Failed when accessing SQL.
    ... I have a problem for a Windows Service to login on an SQL server (different ... machine) - neither Windows Authentication nor SQL Authentication worked. ... Evan Camilleri ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Windows Services GUI
    ... Open a form from a Windows Service ... SQL Server has a number of Windows Services that run, ... have multiple custom commands defined. ... Remoting Server, in which case you call a method to have it perform some ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... > The windows service executes on a workstation. ... > SQL Server 2000 executes on a server different from the workstation through ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Roll your own xtranet msde replication - Whats really required
    ... sql server functionality had been overlooked ... > where the remote clients cannot advertise their own services -- therefore ... > it help to split this into steps such that a client posts that it has data, ... >> are assimilated by the remote windows service, ...
    (microsoft.public.sqlserver.msde)
  • SQL Server 2000 Memory Usage.
    ... I am monitoring the memory usage for the Windows Service, ... I am observing that the memory usage for Windows Service and DLLHOST ... In case of SQL Server the memory usage keeps on increasing. ... keeps on increasing memory as long as there is free memory. ...
    (microsoft.public.dotnet.framework.performance)