Cannot connect to remote server (linked server) through TST


My TST db and test DB are in one sql server and I am trying to connect to the remote sql server though TST stored proc. And its failed with error

LE DB provider "SQLNCLI10" for linked server "SomeDB" returned message "The transaction manager has disabled its support for remote/network transactions.".

If I run the same stored proc indepenedantly form the server , it works fine. But no through TST. Does TST supports remote execution? Please reply!!


SQLSCT wrote Jan 17, 2013 at 9:21 PM

I just want to mention that 'select statemens't to remote server works fine through TST. But wont let me to execute 'Delete statements' and this is kind of important to execute my test scenarios. But same delete works fine through a non TST stored proc. So its not a user access issue for sure.

wrote Feb 14, 2013 at 2:57 AM