Re: Accessing DB from windows service
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Sun, 28 Oct 2007 10:14:21 +0200
Hi
If the both servers are in the same domain, so it should be OK
"Rotsey" <malcolm_smith@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:eYJThp3FIHA.4584@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
.
- References:
- Accessing DB from windows service
- From: Rotsey
- Accessing DB from windows service
- Prev by Date: Re: SQL Server 2000 Update Trigger
- Next by Date: Re: sa account locked out
- Previous by thread: Accessing DB from windows service
- Next by thread: RE: Generating scripts for existing permissions
- Index(es):
Relevant Pages
|
|
