September 27, 2008 at 3:49 am
Hello,
I'll try to explain scenario (sorry my poor english):
We installed sql 2005 standard on a 2003 cluster(two nodes). After installation we tried to create a partition table on the cluster instance already created (PRESQL17\PRESQL17) but we saw that partitioning requires enterprise edition.
So we tried to upgrade that installation with the statement(documented on msdn):
start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=PRESQL17 UPGRADE=SQL_Engine SKUUPGRADE=1 /qb
But, this had a mistake: the instance wasn't PRESQL17 but PRESQL17\PRESQL17. So the upgrade fails.
Then, we have a instance PRESQL17\PRESQL17 (original installed instance) and another instance (created by upgrade statment?) ESPRESQL17.
Finally I removed PRESQL17 instance, BUT PRESQL17\PRESQL17 WONNT TO BE REMOVED: installer(add/remove programs) returns an error telling GROUP property is not defined. We also tried to remove instance with:
start /wait setup.exe /qB VS=PRESQL17 INSTANCENAME=PRESQL17\PRESQL17 REMOVE=ALL ADMINPASSWORD=XXXXXXX GROUP="SQL" IP="XXXXXXXX ADDNODE="preclussql16,preclussql17"
but this wont remove anything (nothing is displayed on step wich sould show components to be removed).
We also tried to install again the PRESQL17\PRESQL17 instance but it fails telling that that instance exits 🙁
So anybody have an idea ?t??? (please, an idea that not require reinstall OS)
September 27, 2008 at 5:05 am
I think you should use :
start /wait setup.exe /qB VS=PRESQL17 INSTANCENAME=PRESQL17 REMOVE=ALL ADMINPASSWORD=XXXXXXX GROUP="SQL" IP="XXXXXXXX
Be carefull with remove all !
If this is the only instance on the box, it's ok, if not it will also remove client components !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 27, 2008 at 5:46 am
First of all thanx a lot...
Already tested, but anyway does'nt works. At last, i check the registry and i found one suspicius key: instance was pointing to MSSQL.2 but the installed instance is on MSSQL.1. I changed the value and remove dsql server 2005 component and the instance succesfully.
Now I'm reinstalling enterprise edition. I hope the installation wont fail for touching in the registry but after hours of seaching I haven't found nothing but this "workaround"...
Anyway I tell you if I intall succesfully....
September 27, 2008 at 10:07 am
I succesfully installed Enterprise Version! so workaround worked fine. Anyway I think touching registry is the worst method to fix anything....
Anyway lot of thanks!!!
September 28, 2008 at 1:23 pm
Strange having your reg pointers messed up :crazy:
I haven't seen that issue ...
I'm glad you managed to fix it and got to do the thing you intended to.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply