Accessing DB from windows service

Hi,

I have a windows service that does some distributed transcation
across 2 servers. One DB is SQL 2005 express and the other is SQL 2005.

My question is I have created a domain user account and I am
logging the service in as that account. Then I am adding permission to
the user acccount to both DB's.
If I use integrated security in my connection strings to the
DB's will they login as the domain user account and
everything be greart????

Malcolm






.

Relevant Pages

  • Windows service
    ... I have a windows service that does some distributed transcation ... across 2 servers. ... One DB is SQL 2005 express and the other is SQL 2005. ... My question is I have created a domain user account and I am ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Accessing DB from windows service
    ... If the both servers are in the same domain, ... I have a windows service that does some distributed transcation ... One DB is SQL 2005 express and the other is SQL 2005. ... My question is I have created a domain user account and I am ...
    (microsoft.public.sqlserver.security)
  • Re: Windows service
    ... Bela Istok ... I have a windows service that does some distributed transcation ... One DB is SQL 2005 express and the other is SQL 2005. ... My question is I have created a domain user account and I am ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Windows service
    ... across 2 servers. ... One DB is SQL 2005 express and the other is SQL 2005. ... My question is I have created a domain user account and I am ... If I use integrated security in my connection strings to the ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Domain or Local User Account for Laptop SQL 2008 Services
    ... I think I'd like to use a Domain User Account for the SQL 2008 services, but if I do this, will SQL Server function properly when I'm not connected to my network? ... SQL Server will try to connect to your domain controller for establishing authentication at startup if you configured your SQL Server service to a domain user account. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)