Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-15 : 07:57:47
|
| Domw001 writes "I am in a DR senario and I am having trouble rebuilding the system databases on my SQL 2005 cluster. I run the following string: start /wait setup.exe /qn VS=Vname INSTANCENAME=instname REINSTALL=SQL_Engine REBUILDDATABASE=1 ADMINPASSWORD=password SQLACCOUNT=domain\acct SQLPASSWORD=password AGTACCOUNT=domain\acct AGTPASSWORD=password REINSTALLMODE=vomus The setup fails with the following error: Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Microsoft Windows Server 2003 family, Service Pack 1 (Build 3790) Time : Wed Dec 13 15:41:44 2006 CLUSTERSVR1 : To install Microsoft SQL Server 2005, COM+ should work. CLUSTERSVR1 : To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter. CLUSTERSVR1 : To install Microsoft SQL Server 2005, COM+ should work. CLUSTERSVR1 : To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter. Machine : CLUSTERSVR1 Product : Microsoft SQL Server 2005 Product Version : 9.00.1399.06 Install : Failed Error Number : 5897 SQL 2005 was originally installed in May '06 as RTM. SP1 applied in September '06. I have the original RTM install disk but obviously SP1 is causing rebuild to fail. The SKUUPGRADE option failed because I cannot upgrade to a lower level version.I dont want to uninstall/reinstall SQL. Is there a way round this?D. " |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-12-15 : 12:36:15
|
| you install from the add/remove programs cpanel item instead. It will then prompt you to point at the install media.-ec |
 |
|
|
|
|
|
Clustered SQL 2005 System Database Rebuild Fails Due to SP1