Upgrade SQL 2005 Standard to 2005 Enterprise Edition Cluster?

SQL Server 2005 Standard Edition can be upgraded to SQL 2005 Enterprise edition. Please refer support upgraded paths at http://technet.microsoft.com/en-us/library/ms143393(SQL.90).aspx

Follow the instructions mentioned in the MSDN article http://msdn.microsoft.com/en-us/library/ms144259(SQL.90).aspx#skuupgrade to upgrade SQL 2005 Standard Edition to SQL 2005 Enterprise Edition.

To put it simply, Launch SQL 2005 Enterprise edition setup.exe from command prompt using setup.exe SKUUPGRADE=1

For additional information and screenshots, Refer Page 61 from SQL 2005 Failover Cluster whitepaper http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&displaylang=en Though this whitepaper is about SQL 2000 to SQL 2005 upgrade, steps almost remain the same

Edition upgrade must be launched from active node and once upgrade is completed, please apply SP3 from active node.

Known Issues to note before planning to migrate/upgrade to SQL 2005 64-bit on Windows 2003 64-bit server (EM64 or x64, IA64)

This post is now migrated to a below Link. Please update your bookmarks incase you are accessing this page from your bookmarks.
New link has updated document with more precise known issues.
Please click on link below to access the new document.
http://www.sqlserverdba.co.cc/2009/03/sql-server-32bit-to-64-bit-migration.html

Thanks!

SQL 2000 SP4 Upgradation Error - Error running script: sp3_serv_uni.sql (1)

First of all, I want to let you know that when you are upgrading SQL Server 2000 to SP4, make sure that you are Stopping and Changing startup type to Manual for below Services

1. MSSQL$Instance
2. Windows Management Instrumentation
3. Microsoft Search
4. SQLAgent$Instance

If you perform the above steps then you will never face issue while upgradation.

Incase you get below error "Error running script: sp3_serv_uni.sql (1)" then solution is to rename dbmslpcn.dll in C:\Windows\system32 and run setup so that dll will be created automatically.