.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Regarding "Cannot access disposed Object name:Transaction" DTC error in SQL server 2008

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server

Hi all,

I have upgraded  my Sql server 2005 to Sql server 2008 in window 2003 server (SP 2 standard edition) . After upgrading  iam getting above mentioned MSDTC issue when try to make an distributed transaction with Sql server 2008 in my .Net application .

Note: No issues with SQL server 2005...

Please give me an solution

View Complete Post

More Related Resource Links

Error upgrading SQL Server 2008


i was normally using VS2005 and SQL server 2005...

i upgraded to SQL Server 2008... and then...

i could not build my project anymore... because of this error:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Source Error: 

Server 2008 R2 -> Failed to decrypt using provider 'RsaProtectedConfigurationProvider'. Error mess


So I am using the aspnet_regiis.exe tool to encrypt sections of the web.config in my asp.net applications and services.  I have done this for years successfully on Windows Server 2003 (IIS 6).  However I just moved some apps over to Windows Server 2008 R2 (with IIS 7.5) and I am now receiving the following error at runtime:

"Server was unable to process request. ---> Failed to decrypt using provider 'RsaProtectedConfigurationProvider'. Error message from the provider: Bad Data."

Now I am quite familiar with this process and am stumped at what I have missed this time around.  I have done ALL of the following which typically suffices for the process on the server. PLEASE READ ALL AND DO NOT PROVIDE RESPONSES OR LINKS FOR THINGS I HAVE ALREADY DONE Thanks!!  Wink

  1. Imported the keys to the server using aspnet_regiis -pi  Result: Success
  2. Given FULL permission (using -full switch) using aspnet_regiis -pa to ALL of the following accounts  Result: Success
    1. [SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

      Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

SQL Server Network Interfaces Error 26 - while failing over SQL Server 2008 R2

Before I explain the issue I am facing, I would like to say that I did read the post at  http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx but in my case the problem is transient (lasts for approximately two minutes after a failover) so items 1-3 in the list of troubleshooting steps do not seem to make sense. As to 4 and 5, the named instances use non-default ports (2433 and 3433 respectively), so I do not know how to tailor the PortQry command for that. I tried  portqry.exe -n ServerA,2433-p UDP -e 1434 and  portqry.exe -n ServerA,2433 -p UDP -e 2434 and it failed both times with a "Failed to resolve name to IP address" while the server was up and serving database requests The same thing happened when I tried it with the failover server as well. ***The issue I am facing*** I am using Enterprise Library 4.1 to connect to a SQL Server 2008 R2 database with a mirror. My connection string itself is as below (with dummy values for all fields): "Data Source=ServerA;Failover Partner=ServerB;Initial Catalog=DBName;User ID=uid;Password=pwd;Connect Timeout=5" Sample .NET code is as below (with modifications to instantiate all variables locally to provide context): SqlDatabase db = new SqlDatabase(ConnectionString); SqlConnection cn = (SqlConnection)db

SQL Server 2008 installation fails There was an error generating the XML document. Error code 0x84B

My system config: window XP - SP3 4 GB RAM, I have VS2008 with SP1, VS2010 Ultimate installed First when I tried to install SQL 2008 R2 Dev edition I got an error saying vs2008 SP1 was not installed, infact I had the SP1 installed in my m/c.  I did reinstalled the SP1 and tried to install SQL again. while in the final installation process I got the error  "Setup has encountered the following error: There was an error generating the XML document. Error code 0x84B10001." I uninstall the SQL server again to remove the files which were created from Unsuccessful installation I removed the register entry as suggested by this forum. reinstalled but no chance, I have tried all the option which I can get know in web. Please help me. here is the log files details  Exception type: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException 2010-08-26 14:54:53 Slp:     Message: 2010-08-26 14:54:53 Slp:         There was an error generating the XML document. 2010-08-26 14:54:53 Slp:     Stack: 2010-08-26 14:54:53 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.SerializeObject(String rootPath, Object objectToSerialize, Boolean saveToCache) 2010-08-26 14:54:53 Slp:   &nb

error while installing sql server 2008 r2 on win7

what can i do? i had .net framework 3.5 sp1 details is: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Configuration.ConfigurationErrorsException: An error occurred creating the configuration section handler for userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings: Could not load file or assembly 'System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. (C:\Users\seven\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\\user.config line 5) ---> System.IO.FileNotFoundException: Could not load file or assembly 'System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. File name: 'System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089'    at System.Configuration.TypeUtil.GetTypeWithReflectionPermission(IInternalConfigHost host, String typeString, Boolean throwOnError)    at System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.Init(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord)    at System.Configuration.RuntimeC

BootstrapExtension.ExecuteWorkflowAction error while installing SQL Server 2008 R2

After installing Visual Studio 2010, I found that I could no longer open SQL Management Studio.  I could not even uninstall them because the uninstall was dying.   So I manually removed sql server from my system and now I am trying to install SQL Server 2008 R2 Express. However, the install is failing silently.  Here is the Detail_LandingPage log file:   2010-08-27 13:42:44 Slp: Log provider 'Microsoft.SqlServer.Chainer.Infrastructure.LogProviderFile' has been registered 2010-08-27 13:42:44 Slp: Log provider 'Microsoft.SqlServer.Chainer.Infrastructure.LogProviderStatus' has been registered 2010-08-27 13:42:44 Slp: Reading XML resource 'Microsoft.SQL.Chainer.PackageData.Package.xml' 2010-08-27 13:42:44 Slp: Reading schema resource 'Microsoft.SQL.Chainer.Package.Package.xsd' 2010-08-27 13:42:44 Slp: Document 'Microsoft.SQL.Chainer.PackageData.Package.xml' validated with schema 'Microsoft.SQL.Chainer.Package.Package.xsd' has been successfuly loaded into datastore path '/Datastore/Package' 2010-08-27 13:42:49 Slp: ---------------------------------------------------------------------- 2010-08-27 13:42:49 Slp: Running Action: ReadProductXML 2010-08-27 13:42:49 Slp: Reading XML resource 'Microsoft.SQL.Chainer.Product.Product.xml' 2010-08-27 13:42:49 Slp: Reading schema resource 'Microsoft.SQL.Chainer.Product.Product.xsd' 2010-08-27 13:42:49 Slp:

report viewer error / visual web developer 2008 / sql server 2008 / report viewer add on / win7 x64

hi, i decided to export my local site to iis today, the process wasn't smooth.   anyway. i was able to access my site, the db tables are working as i am able to create new records and retrieve them. my main problem now is with the report object. i've tried the work around found here : http://support.microsoft.com/kb/2002980.. it helped sort of. i used to have only a big page of error before i did the work around, now i am able to see half of the report (the report interface) but the contents, the field are filled with 404 errors. any idea how i can fix this??                  

SQL Server 2008 64-bit installation error 0x84B20001

Hello, I'm trying to install SQL server 64-bit and I'm getting the following error: SQL server 2008 setup100.exe and setuppatch.exe cannot be run in this mode. If tou are running setup100.exe, start setup.exe instead. I can't find setup.exe for the 64-bit installation. What can I do? Thanks.    

Error Editing Step in Job (SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64))

Hello I am working on SQL Server 2008 migration project. We have SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) on WS 2008 R2 Standard. 1) I am getting error when i try to change a step in job. The error information is given below. -- TITLE: Microsoft SQL Server Management Studio ------------------------------   Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)   ------------------------------ ADDITIONAL INFORMATION:   Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS) -- Any idea why i am getting this error. It goes away when i close SSMS and re-open SSMS. Comes back again later on. Thank You for the help V

Best practice for user defined error messages in SQL Server 2005/2008 --Need help

My requirement is to setup a standard practice for our team in handling DB erros and also  user defined messages. We are handling exceptions using Raiseerror method with in Try and Catch blocks.  For user defined message, we are using Sp_addmessage to add our application specific error/warning messages with error codess>80000.  Ex: 80001 | Company name already exists. please check. Here is the sample code ********************************************************************* CREATE PROCEDURE [dbo].[usp_CompanyProfile_insert]  -- Add the parameters for the stored procedure here  (@company_name VARCHAR(50),  @company_code VARCHAR(3),  @user_id INT  ) AS BEGIN  -- SET NOCOUNT ON added to prevent extra result sets from  -- interfering with SELECT statements.  SET NOCOUNT ON;  BEGIN TRY -- Begin Try Block      -- Validate company name   IF EXISTS (SELECT company_id FROM companyprofile WHERE company_name = @company_name)    RAISERROR(90021, 16, 1)      INSERT INTO companyprofile (company_name,       company_code,       createdby)   VALUES(@company_name,     @company_code,     @user_id)    END TRY  -- End Try Block &

SQL Server 2008 Internal error at ExecuteSqlCmd

On a version of SQL Server 2008 with Service Pack 1 applied (on Windows Server 2003), I am finding that when trying to run a bulk number of jobs using the sqlcmd command, one of the jobs will randomly fail to run with the following error thrown in the command window: Sqlcmd: Error: Internal error at ExecuteSqlCmd (Reason: Unspecified error). I've found that each time the batch of jobs is run, a different one will fail to run each time.  It seems to be completely random which one will fall over, but you can guarantee that at least one will fall over each time. I've tried numerous websites to find an answer and no luck so far.  There is a hotfix which has been released for this exact same problem (http://support.microsoft.com/kb/2121407/) but this is only for R2 and so cannot be applied to my installation and we're not in a position to move to R2 as yet. Is there a fix available for non R2 users for this?

Error connecting to Remote report server database in SQL Server 2008 R2 DataCenter Edition

I am trying to configure my report server installed on Server A to point to a reporting services DB on Server B. I am able provide the name and test the connection. However, when i click next on the configuration wizard after providing the Server A name I am receiving the below error: The feature: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services I have SQL Server 2008 R2 DataCenter Edition on both the servers.    

Location Error on Install on Virtual Server - SQL Server 2008 R2

I'm trying to install SQL Server 2008 R2 on a Xen Server running Server 2008 R2. I get the following error.   The disc has been used to successfully install on other machines in my office. The virtual machine location settings are also all United States English. Any thoughts?

SQL Server 2008 Installtion Error : A network error ... SQLE86D.tmp.msi

Hi all, I'm trying to install SQL server 2008 on a Windows Server 2008 SP2 64bit , but I'm facing this error message: "A network error occured while attempting to read from the file E:\9c......\x64\setup\x64\SQLE86D.tmp.msi" Have anyone faced the same message before? Regards, Waleed

SQL Server 2008 Express Setup failure: Unknown Property Error

I am trying to install SQL server 2008 on windows 7 but it returns the following error when almost done with installation: TITLE: SQL Server Setup failure. ------------------------------ SQL Server Setup has encountered the following error: Unknown property. . ------------------------------ BUTTONS: OK ------------------------------   Can someone please assist me with this, I have tried for more than a week to go around it. I have also searched online for solutions but in vain. Looking into the log files, I see these: 2010-09-05 21:04:41 Slp: Running Action: Install_SqlBrowser_Cpu32_Action 2010-09-05 21:04:41 Slp: Target package: "C:\Softwares\Database and Management\SQLEXPRADV_x86_ENU\x86\setup\sqlbrowser.msi" 2010-09-05 21:04:46 Slp: InstallPackage: MsiInstallProduct returned the result code 0. 2010-09-05 21:04:46 Slp: RunMsiCore succeeded. 2010-09-05 21:04:46 Slp: Checkpoint: INSTALL_SQLBROWSER_CPU32_ACTION 2010-09-05 21:04:46 Slp: Completed Action: Install_SqlBrowser_Cpu32_Action, returned True 2010-09-05 21:04:46 Slp: ---------------------------------------------------------------------- 2010-09-05 21:04:46 Slp: Running Action: Install_SqlSqmShared_Cpu32_Action 2010-09-05 21:04:47 Slp: Error: Action "Install_SqlSqmShared_Cpu32_Action" threw an exception during execution. 2010-09-05 21:04:47 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExec

Error installing SQL Server 2008 R2 on a Windows 7 Ultimate 32 machine

HI all, I'm installing the Developer edition of MS SQL Server 2008 R2 (downloaded today) on a Windows 7 Ultimate 32bit virtual machine (using VMWare Workstation 6.5).  Yesterday I had tried MS SQL Server 2008 R0 with the same results.  Both give an error about 30% into the installation process: "An error occurred during the installation of assembly 'VSLangProj80,Version="",PublicKeyToken="b03f5f7f11d50a3a",Culture="neutral",FileVersion="8.0.50727.1826"' When I click the OK button, the install rolls that last bit back and then continues.  Unfortunatly I didn't take a screenshot of the main install window, just the error window. Any ideas what this error means?  The install yesterday seemed to work, but I'm not through the R2 install yet.  The R0 install also failed to install the documentation for some reason (I left it running during the night) Note that I have VS2010 (original release plus downloaded updates) installed and then just some small stuff like Snagit and Skype on this VM.  I updated Windows 7 completely before I started installing R2 so it is completely up to date as of midnight! Best regards, Arnor BaldvinssonArnor Baldvinsson
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend