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


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

Upgrade issue from SQL 2005 x64 to SQL 2008 x64

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :Sql Server
 

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




View Complete Post


More Related Resource Links

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)

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

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

Issue in SMO DB transfer from SQL 2005 EE to SQL 2008 EE SP1

  
Hi All, I am transferring DB from SQL Server 2005 EE to SQL 2008 EE SP1 using SQL Server SMO. I am using the TransferData method of Transfer object. I am facing a problem where it creates the DB on 2008 instance but does not create any table, view and procedures. This is not getting reproduced every time. The error that caught in code reads below:   ERROR : errorCode=-1073548784 description=Executing the query "CREATE TABLE [dbo].[table1]( [ParamKe..." failed with the following error: "The log for database 'sadb20052008' is not available. Check the event log for related error messages. Resolve any errors and restart the database.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. helpFile= helpContext=0 idofInterfaceWithError={C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C} For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.   I checked the SQL Server logs and it is reading as below. I enabled the deadlock logging by setting the SQL Server service startup parameters to -T1204, -T1205, -T3605 and found the log as given below. How can I debug it to find the root cause and resolve it?   2010-04-06 16:50:28.31 spid7s Deadlock encountered .... Printing deadlock information 201

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

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

IO queuing issue after migration from 2005 to 2008

  
Hi,   Are there any functional changes to the number of outstanding IOs to a LUN from 2005 to SQL 2008? 2008 seems to have a limit of 128 outstanding IOs to a DB volume where SQL 2005 does not. I am struggling to find any SQL tuning parameters that would impact how the db can read/write to disk? Help/comments appreciated.    

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

SQL 2008 Reporting Services Report Parameter and Analysis Services issue after upgrade

  
I have upgraded my SQL 2000 database and analysis server and SQL 2005 reporting services server to a new instance of SQL 2008 running database engine, analysis services and reporting services.

The analysis services database migrated successfully and I have got the database into a state where it processes fine but I am having the following problems.

- My Reports show in reporting services but the drop down list parameters are all empty.
If I change the parameter in report builder to use the display name instead of the uniquename then the drop down list populates and works until I select a value that contains a space character and then it reports a problem with the dataset used by the report.

Query for the dataset used to populate my parameter.
with member [Measures].[GroupUniqueName] as '[Site].CurrentMember.UniqueName' member [Measures].[GroupDisplayName] as'[Site].CurrentMember.Name' select { [Measures].[GroupUniqueName], [Measures].[GroupDisplayName] } on columns, { [Site].[Group].members } on rows FROM [Invoice Reporting]

Query used by the report, filtering on the selected parameter value from the drop

Issue when migrating Reporting service reports from SQL Server 2005 to SQL Server 2008

  

Hi Friends,

We are migrating reporting service reports from SQL server 2005 to SQL Server 2008 and facing below login issue.

We got a virtual machine with 2003 server and got SQL Server 2008 installed with reporting service.

I was able to publish my 2005 reports using VS 2005 easily.


1) But when I try to run the reports I am getting below errors at my website home page.

The permissions granted to user 'DomainName\MachineName' are insufficient for performing this operation. (rsAccessDenied)

I could not get why there is no user name in above error and how it says machine name does not have permissioin?

There should be at least some user id mentioned as per me.

What could be the reason of above error?

2) Also when I try to run reports using Reports website (i.e. http://server/Reports URL), I get below errro in executing the reports.

"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'ReportSource'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

Here the question is how it is picking up Anonymous logon. I thought it might be using Network Sevice acct to access reports.

What should I be doing to resolve above errors?

3) Also one more point about the s

Issue when migrating Reporting service reports from SQL Server 2005 to SQL Server 2008

  

Hi Friends,

We are migrating reporting service reports from SQL server 2005 to SQL Server 2008 and facing below login issue.

We got a virtual machine with 2003 server and got SQL Server 2008 installed with reporting service.

I was able to publish my 2005 reports using VS 2005 easily.


1) But when I try to run the reports I am getting below errors at my website home page.

The permissions granted to user 'DomainName\MachineName' are insufficient for performing this operation. (rsAccessDenied)

I could not get why there is no user name in above error and how it says machine name does not have permissioin?

There should be at least some user id mentioned as per me.

What could be the reason of above error?

2) Also when I try to run reports using Reports website (i.e. http://server/Reports URL), I get below errro in executing the reports.

"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'ReportSource'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

Here the question is how it is picking up Anonymous logon. I thought it might be using Network Sevice acct to access reports.

What should I be doing to resolve above errors?

Migration Issue to 2005 & 2008

  

Hello:

Back in 2002, I wrote a program which utilized SQL-DMO to build "If Exists/Drop" and "Create" Scripts for me, and it's worked great until I migrated to 2005 then immediately to 2008.  I've briefly read up on switching to SMO and I'm going have to learn SMO unless someone knows of a tool that can create these scripts for me.  Does anyone know if SQL has a new tool for this or maybe a third party software.  I'm so busy with our flagship product, that it would really be terrible if I had to learn SMO right now and rewrite a script creator.

Thanks so much in advance.

Frank


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

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