Solved

SQL server upgrade to 2008 r2

Posted on 2010-11-22
6
924 Views
Last Modified: 2012-05-10
After upgrading from sql 2005 standard to 2008 r2, the version number of the database engine still reads 9.0.3080. the BIDs seemed to upgrade, and the 2005 SSIS packages went through the upgrade process. Now the sql jobs can't run the packages because they appear to be a more recent version than SQL???? We've tried to run a repair, but the version number still reflects sql 2005. Any ideas?
0
Comment
Question by:KSUF
  • 3
  • 2
6 Comments
 
LVL 13

Expert Comment

by:Wizilling
ID: 34193476
have you been selecting the database engine component when upgrading.
also check nt event logs, sql server event logs for errors.
also check C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log for the summaryxxx.txt files
0
 
LVL 10

Expert Comment

by:TAB8
ID: 34214906
Re-Run the upgrade if it is still seen as version 9.0.3080 the upgrade wizard should still let you run the upgrade
0
 

Author Comment

by:KSUF
ID: 34222955
Never could get the database engine to upgrade so I uninstalled all sql and tried to reinstall, but it still thinks there is an installation using the default instance. I think I may have to rebuild this server from scratch.
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 10

Accepted Solution

by:
TAB8 earned 500 total points
ID: 34223036
You could remove the registry entries and then you could reinstall
http://www.windowsitpro.com/article/permissions/how-can-i-completely-uninstall-sql-server-.aspx
0
 

Author Comment

by:KSUF
ID: 34230052
I tried removing keys under local machine software microsoft sql server and mssqlserver but still there was some remnant of the default instance. I gave up and rebuilt the server. Thanks for your help.
0
 

Author Closing Comment

by:KSUF
ID: 34230103
I didn't have a chance to try this...had already started rebuilding...thanks anyway.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question