Re: Windows service

"Rotsey" <malcolm_smith@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:eTBOup3FIHA.3768@xxxxxxxxxxxxxxxxxxxxxxx
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????

Yes, this should work, and in fact it is the recommended way to configure security for such a setup.

.

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)
  • Accessing DB from 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.sqlserver.security)
  • 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
    ... Yes you should do that with NT Integrated security if the account being used on ... the running machine is established on SQL 2005 server and SQL 2005 express. ... My question is I have created a domain user account and I am ...
    (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)