Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We are tring to use an application that uses transactions.

  • The machine running the code is on a stand alone Windows 2003 Server machine.
  • The database server is a Windows 2003 Server with SQL Server 2005 on a domain machine on a different network.

It works when we install the application on a machine in the same domain.

I have tried going into the Component Services and marking "Allow Inbound Connections" and "No Authentication Required".

I can see that the transaction appears in the MSDTC list on both computers, but the transaction gets aborted.

Any Ideas what the problem could be?

share|improve this question
    
Do you receive any sort of an error message from SQL Server? –  Ed Leighton-Dick Jan 21 '10 at 15:11

1 Answer 1

I'm not sure how MSDTC handles this but you could try using passthrough authentication. Set up a local user\password on the application server that matches either a local user\password on the SQL server or a domain user\password in the SQL server's domain. Configure the application to run under this user's context and see what happens.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.