Skip to Content
0

Upgrade SQL Server 2000 to 2005

Feb 12 at 01:51 PM

62

avatar image
Former Member

Dear All,

I would like to upgrade SQL server 2000 on Windows 2003 x64 to SQL server 2005 but could not proceed because of the following error during the upgrade process.

"your upgrade is blocked because of edition upgrade rules"

Does anyone have tip to bypas this or easy upgrade strategy ?

Regards, Hardon

lxp32.png (49.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Luis Darui
Feb 12 at 07:56 PM
0

SAP does not support SQL Server 2005 as a target anymore as SQL Server 2005 support by Microsoft has ended. Windows Server 2003 support period has ended as well.

Consider your upgrade scenario by using SQL Server 2008 instead.

Check SAP Note https://launchpad.support.sap.com/#/notes/2297283

(check full details in the thread)

Show 4 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Dear Luis,

Thanks for your answer.

I am upgrading R/3 enterprise to ECC 6 including unicode conversion. My destination is SQL 2012

Now I started upgrading SQL 2000 to SQL 2008 R/2 and got the following message.

There are no features selected for upgrade sql 2008 r2

Example :

http://www.sqlcoffee.com/troubleshooting093.htm

Regards,

REd

0
Former Member

Got the following error while upgradin from SQL 2000 to SQL 2008 R/2

sql-2008-erro.jpg (80.5 kB)
0

You can't upgrade 32-bit to 64-bit or vice-versa.

For SQL Server 2008 R2 SAP only supports the 64-bit version. There are certain restrictions with the source x upgrade versions as well, please check the following page:

https://msdn.microsoft.com/en-us/library/ms143393(v=sql.105).aspx

You probably needs to install a new instance on a supported environment and copy the database. Check the following SAP Notes:
151603 - Copying an SQL Server database
1783528 - Migration path to Win2012/MSSQL2012 or MSSQL2014 for 4.6C and 6.20/6.40

0
Former Member

Dear Luis,

Thanks for tip

Now I am going to install new SQL 2008 R/2 on Windows 2012 and migrate( exptort, including unicode coversion) the database.

After this upgrade to ECC 6.

Regards,

Red.

0