Pages using transcations not working

Our website hosted on your server is using MSSQL 2005 database. Some of the pages are using functions that use TransactionScope attribute for adding/modifying content in the database. Though the application is working fine locally but when moved to the DiscountASP.NET server is is throwing following error:



MInt.DataAccess.DBService::SqlDAL::ExecSPReturnParameters::Can't Execute Stored Procedure:rc_ins_tblUserRoleAssociation MInt.DataAccess.DBService::SqlDAL::OpenConnection::Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))



It appears that either MSDTC is not properly configured or we don't have proper permissions to use it on a remote database. Need help.</BLOCKQUOTE>

 

Unfortunately distributed transactions is not supported on our SQL servers.

 

We can't, because rollbacking or commiting of transactions is dependant upon the success or failure of an outgoing email which obviously happens out of the boundaries of sql server. So, transaction is required in .NET code and we have extensively used it at quite a few places.