SqlConnection.open() throws TransactionException 0xe0434f4d

Question

Code works fine when connecting to a sql server 2005 dbase. but when connecting to a sql server 2008 dbase it fails.

scenario: Webservice first connects to 2008 dbase fine. Then during a call in a COM+ object, the connect fails.

Recently upgraded projects to use VS2008 and upgraded to Sql Server 2008.

using (TransactionScope transactionScope = new TransactionScope(TransactionScopeOption.Required, transactionTimeOut))
{     
   using (SqlConnection sqlConnection = new SqlConnection(DataConnection))
   {
      try
      {
 String command = "my_StoredProcedure";

 using (SqlCommand sqlCommand = new SqlCommand(command, sqlConnection))
 {
             sqlConnection.Open();  //- exception is throw right after this call in the COM+ object.

Any Ideas out there?

Answer 1

It looks like you are missing handling a SQLException

http://blogs.msdn.com/tess/archive/2006/04/27/584927.aspx