Re: Windows service

No have not tried it yet

I am trying to save me some pain by asking :-)


"Bela Istok" <bela_i@xxxxxxxxxxx> wrote in message
news:628546CA-6EF9-4119-9ED0-29A155A04731@xxxxxxxxxxxxxxxx
I guest is OK,do you try that?

Regards

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

  • 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)
  • 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: 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)
  • Re: Connection to SQL Server CE Windows Service via C# - Error 250
    ... This is probably 3rd time I am hereing to a case the encryption related ... In SQL CE v3.1 case, can you try using Crypto API under the same credentials ... specific to your database or if it's really the password itself. ... connect to it via the windows service under the Local Service ...
    (microsoft.public.sqlserver.ce)