Sqlconnection does not support parallel transactions

Question

I want to run two transactions simultaneously. So i gave MultipleActiveResultSet = false in the connection string as specified in an MSDN article. But after modifying the connection string i get "Target machine actively refused". I'm working with WCF.

Any ideas in this?

Thank you.

Answer 1

I was under the impression that MARS only really applies to the special case of getting multiple forward-only read-only resultsets on a single connection, but that regular operations have to have their own connections.