SQL Server Performance

windows service

Discussion in 'SQL Server 2005 General DBA Questions' started by rotsey, Oct 25, 2007.

  1. rotsey New Member

    Hi,I have a windows service that does some distributed transcationacross 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 tothe 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 andeverything be greart????
    Malcolm
    rotsey, Oct 25, 2007
    #2

  2. techbabu303 New Member

    It would work if the DB's have enabled Mixed mode or windows authentication.
    Cheers
    Sat
    techbabu303, Oct 26, 2007
    #3

  3. satya Moderator

    As long as the permission for that user is setup properly it should work, distributed transactions means MSDTC would be involved and make sure the SQL Server services account has relevant privileges on both the instances.
    satya, Nov 1, 2007
    #4

Share This Page