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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

Upgrade from SQL 2005 to SQL 2008 cause problems with MSDTC

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
 
We have recently upgraded our server from SQL Server 2005 to SQL Server 2008.  Previously we were running our asp.net application using MSDTC with no problems. Since we upgraded, we are encountering problems that seem to relate to Multiple Active Result Sets (MARS).  The error we receive is: "There is already an open DataReader associated with this Command which must be closed first" when we try and perform a save process.  To fix this problem we added MultipleActiveResultSets=True to the connection string.  We now get the error: "The transaction operation cannot be performed because there are pending requests working on this transaction." Within the transaction scope we save to a table and then load from the same table.  Our stack trace indicates this is where the first error occurs.  Again, this transaction worked using SQL Server 2005. If we do not use MSDTC by putting Enlist=false in the connection string, the request works. We are really stumped as to what to do.  We would prefer not to have to role back to SQL Server 2005 and would also prefer not to have to have sweeping code changes in our application.  We have test MSDTC by using DTC ping on our servers and it works. Your help is greatly needed and would be greatly appreciated. Regards, Steve and Nilesh


View Complete Post


More Related Resource Links

Upgrade from SQL 2005 to SQL 2008 cause problems with MSDTC

  
We have recently upgraded our server from SQL Server 2005 to SQL Server 2008.  Previously we were running our asp.net application using MSDTC with no problems. Since we upgraded, we are encountering problems that seem to relate to Multiple Active Result Sets (MARS).  The error we receive is: "There is already an open DataReader associated with this Command which must be closed first" when we try and perform a save process.  To fix this problem we added MultipleActiveResultSets=True to the connection string.  We now get the error: "The transaction operation cannot be performed because there are pending requests working on this transaction." Within the transaction scope we save to a table and then load from the same table.  Our stack trace indicates this is where the first error occurs.  Again, this transaction worked using SQL Server 2005. If we do not use MSDTC by putting Enlist=false in the connection string, the request works. We are really stumped as to what to do.  We would prefer not to have to role back to SQL Server 2005 and would also prefer not to have to have sweeping code changes in our application.  We have test MSDTC by using DTC ping on our servers and it works. Your help is greatly needed and would be greatly appreciated. Regards, Steve and Nilesh

Moving a Copy of SQL Report Server 2005 and Upgrade to 2008

  
Hello, We have SQL 2005 Report Server in a Windows 2003 64 bit server box. We want to create a copy of this report server database somewhere in the domain, so that we can access it for a different purpose. My question is, will there be any complications with this? I'm thinking about the encryption key that's needed to access the database. If we are successful with this, we might also want to upgrade to SQL 2008. Thanks for your help,   Elizabeth K.

Upgrade from SQL 2005 EXPRESS to SQL 2008 EXPRESS

  
Hello friends, I restored My database in SQL 2005 of size more than 4 GB but it creates problem when i save picture (image data) in database.i.e i can't save it.So i searched for that problem and came to know that SQL Express 2005 has database size limit of 4 GB. i upgraded it to SQL EXPRESS 2008 and restored it to there.Still it has the same prblem means i can't able to save data.. So what may be the problem. Thanks in advance. RAHUL PATEL. rahulpatel112@live.in

Problems installing SQL Server 2005 Integration Services for Server 2008 R2

  
I am trying to install Microsoft Forefont and i have got a tick on every requirement bar 1. I can't install SWL Server 2005 Integration Services Component. I am running windows Server 2008 R2. I have tried numerous steps such as going into to control panel and adding component but the Integration services is not appearing on the options. Is it actually possible to install 2005 integration services on server 2008 and if so how? Thanks

2005 Enterprise upgrade to 2008 Standard?

  
We are currently running 2005 Enterprise Edition. Is it possible to move the database to 2008 Standard Edition?  

upgrade sql 2005 to 2008 issue

  
i am trying to upgrade sql server 2005 Enterprise edition sp2 to Sql server 2008 R2 Data center Edition on a windows 2003 Enterprise edition SP2. Up gradation fails to give 'FeatureUpgradeMatrixCheck' error. any ideas ? i don't find much online. I would like to upgrade ::: [Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)     Enterprise Edition on Windows NT 5.2  ] to [Microsoft SQL Server 2008 R2 (RTM)   Data Center Edition ] possible ? thx, jason

SSRS in place upgrade from 2005 to 2008 issue

  

I did an inplace upgrade of SSRS 2005 to 2008 and now the reports are throwing the following error. The reports were all working fine and there is a datasource with the name 'Data Source Name' without the '_'.  Please help.

  • An error has occurred during report processing. (rsProcessingAborted)
    • The data source 'Data_Source_Name' cannot be found. (rsDataSourceNotFound)

Slow sql-server after upgrade from SQL-Server 2005 x64 standard to SQL-Server 2008 R2 x64 enterprise

  

We moved our databases to new hardware today (using copy database wizard)

 

The new hardware should be better than the old one.

We went from 28 GB ram to 128 GB.

We went from 16 cores to 32 cores (with even more cache etc.). We also moved from external SAN with 40 disks to intern disks (8 Samsung SS805 100gb ssd slc)

                             According to our own metrics we could get twice the IO using IO m

I have a SQL 2005 to 2008 upgrade that is failing

  

I have a SQL 2005 to 2008 upgrade that is failing.
I have tried:
- Reinstalling
- Repairing
- Slipstreaming SP1 in with install and repairing

I cannot find any good ideas on the web.  Any ideas would be appreciated. 

 

TITLE: Microsoft SQL Server 2008 Setup
------------------------------

The following error has occurred:

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.2531.0&EvtType=0xD15B4EB2%25400x4BDAF9BA%25401306%254024

------------------------------
BUTTONS:

OK
------------------------------

These services failed
Running post-windows installer configuration timing actions
Database engine services
SQL Server Replication
Full-Txt Search

 

Here is the LOG file for the Upgrade:
Overall summary:
  Final result:                

SSRS 2005 to 2008 upgrade: exporting to .PDF does not produce the same result

  

We have recently converted .rdl SSRS 2005 files to SSRS 2008 .rdl files. We do not have SSRS 2008 R2, we are working with the  first release. We are seeing issues when exporing a report to .pdf format:

1) when rendered in HTML, the function that displays page numbers (ie:page 1 of 2) for the report are correct. The standard function "Globals!TotalPages" is used to get the count of pages. We previewed a report in html in reports manager that had 1777 pages. when the report is exported to .pdf the last page displays page 1777 of 1816, even though there is no more pages beyond 1777.

2)When rendering the report in html a value is shown as "Caretaker1" but when exporting to adobe .pdf version 9.3, the same value is shown as "Caretaker2".

3)   One of our issues is

upgrade from SQl 2005 to SQl 2008

  

Hi there,

can i upgrade from sql 2005 to sql 2008 without any problems concerning database and replication, or should i remove sql 2005 and install fresh copy of sql 2008

Any recommandations?


Generate insert unicode script in sql 2005 to 2008 has problems

  

Dear

I have generated insert unicode script in sql 2005 the run insert script sql 2008 database has problems show ???????????? >

What should I do ?

Best regards






Upgrade SqlDatabase 2005 to SqlDatabase 2008 Error

  

i have sql database 2005 and the log file when i want to update My sql server to 2008 i found the problem with attach the old datebase file the error is :

Msg 3415, Level 16, State 3, Line 1
Database 'SMMS_test' cannot be upgraded because it is read-only or has read-only files. Make the database
 or files writeable, and rerun recovery. Msg 1813, Level 16, State 2, Line 1 Could not open new database 'SMMS_test'. CREATE DATABASE is aborted.

plz help me to solve this problem and i want to attach my old 2005 databases thank all pro

the code i used is :

USE [master]
GO
CREATE DATABASE [SMMS_test] ON 
( FILENAME = N'D:\Databases\SMMS_test.mdf' ),
( FILENAME = N'D:\Databases\SMMS_test_log.ldf' )
 FOR ATTACH
GO
i use windows vista and sql server 2008 enterprise my instance is windows\Authentication mode I'm admin and it is my local PC

any one can help me ??????????


Upgrade issue from SQL 2005 x64 to SQL 2008 x64

  

Hi,

I am facing an issue while upgrade from SQL server 2005 x64 to SQL server 2008 x64. After upgrade all the componets are not showing on Start menu program Files and while upgrade I am getting only 2 features to upgrade. Please see the attached images.

http://lh3.ggpht.com/_sXjLsZULhuI/TLQxA35TjfI/AAAAAAAAABA/lXdbTi6_doc/1.JPG

http://lh3.ggpht.com/_sXjLsZULhuI/TLQxBmzo5YI/AAAAAAAAABI/hHnwTa0nE2c/2.JPG

 I tried to upgrade SQL 9.00.1399.06 standard to 10.0.3798.0 standard version. Is there any known issue in upgrading 2005 to 2008 on 64 bit platform?

Any help will be greatly appreciated...

 

Regards,

Bineesh


Possible problems with this 2005/2008 configuration?

  

Hi -- My company is in the process of upgrading their SQL Server 2000 data warehouse to SQL Server 2008.  Note that my company currently uses the BI toolset from SQL Server 2005.  However, my company has no plans to upgrade the 2005 BI services that we currently use.  Will this configuration work? 

Back-end Database Engine: SQL Server 2008, SP-2
Back-end BI Services: SQL Server 2005, SP-3 (SSAS, SSIS, SSRS - each on their own server)
Front-end Client Tools: SQL Server 2008, SP-2 (SSMS, BIDS)

My concern is that I would, for example, develop an SSIS package on my laptop with the 2008 client toolset and it would work just fine.  But when the package is run in production on the SSIS box (that contains only the 2005 SSIS service), it might complain because it doesn't understand the 2008 package structure.  Or is the SSIS service smart enough to detect the version of the package and work as if nothing was wrong? 

Thanks in advance for your help.

 


How do I upgrade and overlay SQL Server 2005 Express with SQL Server 2008 R2

  

We are upgrading SQL server2005 Express to SQL Server 2008 R2.  We want to replace 2005 Express with 2008 R2 on existing system.  We have lots of questions about how to perform the upgrade safely and pull in our existing databases.  The existing database files are in C:\Program Files\Microsoft SQL Server\MSSQL.1.  Also, we'll want to use the existing instance name to avoid having to reconfigure all of the installed clients at our user's workstations.

Should we uninstall the 2005 Express version first?  Will that keep the existing databases on the system?

Or can we install 2008 R2 while the databases are live under the 2005 Express, or should we shut down 2005 Express first?

Will  2008 R2 use the same data folder or create a new one?  If it uses the same folder will it automatically recognize our existing databases?  If it creates a new one, I suppose we can use the migration Wizard.

 

Thanks for any help....

 


Linked server issue on test box, post upgrade 2005 to 2008 R2

  

In an effort to do some testing prior to upgrading our environment to 2008 R2, I made a test instance on our Dev box.  2005 instance, copied as many things as I could think of from various other instances.  Made a basic linked server to our main cluster, had a repeating job to email me results of a query across that link every few hours.

 

Everything was working fine until the upgrade finished.  It completed at ~7pm.  The email at 6PM came through fine (while the upgrade was in progress), the email at 8pm didn't come through.  Checked various things (DB mail was still working, tested fine).  It couldn't access the data across the linked server.  I tried deleting that link and remaking it.  Errors out.  Tried running the same scripts we use to create our standard linked servers, error out.  The only ones that I can set up and function are links to other instances on the same box.

I've looked around at other fixes for this error message and none seem to make any difference.  Log in with Domain cred's, log in with the sa account, no difference.  I can connect from other instances & servers back to this one, just not outbound from this one.  And it worked prior to the upgrade I applied to it.  All other instances on the box are 2005 as well.

Here is the message I ge

Categories: 
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