Issues with Repair in SQLexpress 2005 SP2
Hi,
I am trying to do a silent repair of SQL express SP2 using setup.exe, unfortunately one of the shortcuts (SQL Management Studio Express) is not turning up. Here is the command which i have used for repair.
setup.exe /qn INSTANCENAME=MySQLServer REINSTALL=ALL REINSTALLMODE=OMUS
But when i go to the Add Remove programs and try doing repair, the shortcut is appearing back. Any thoughts on this..
Is it a better approach to repair the MSI (its in the setup folder) specific to that shortcut to get the shortcut back.
I am trying to do a silent repair of SQL express SP2 using setup.exe, unfortunately one of the shortcuts (SQL Management Studio Express) is not turning up. Here is the command which i have used for repair.
setup.exe /qn INSTANCENAME=MySQLServer REINSTALL=ALL REINSTALLMODE=OMUS
But when i go to the Add Remove programs and try doing repair, the shortcut is appearing back. Any thoughts on this..
Is it a better approach to repair the MSI (its in the setup folder) specific to that shortcut to get the shortcut back.
0 Comments
[ + ] Show comments
Answers (7)
Please log in to answer
Posted by:
kiptek
16 years ago
what is the "repair" entry in the registry? HKLM\Software\Microsoft\Windows\CurrentVersion\Uninstall\{ProductGUID}\ModifyPath
Posted by:
prathiappdeploy
16 years ago
MsiExec.exe /I{20608BFA-6068-48FE-A410-400F2A124C27}
FYI, I removed the entire folder of Mangement Express Studio and did a repair. I did observe that the files related to the Mangement express studio are also not coming back at the time of repair.
FYI, I removed the entire folder of Mangement Express Studio and did a repair. I did observe that the files related to the Mangement express studio are also not coming back at the time of repair.
Posted by:
AngelD
16 years ago
If the shortcut is re-installed from reparing through ARP and not from command line then enable the Windows Installer Logging policy (verbose logging), run each repair (ARP & command line) and compare the logs to pin down what the differences could be.
Posted by:
prathiappdeploy
16 years ago
One thing i observed is the files related to SQL Mangement Studio Express are also not getting repaired. A huge chunk is missing on Repair.
The modify path of Mangemnet Studio Express in the registry is pointing to
MsiExec.exe /I{20608BFA-6068-48FE-A410-400F2A124C27} in the registry.
I believe the repair is getting skipped as it is "/I".
So we are thinking of discarding this option for the users. Any thoughts..
The modify path of Mangemnet Studio Express in the registry is pointing to
MsiExec.exe /I{20608BFA-6068-48FE-A410-400F2A124C27} in the registry.
I believe the repair is getting skipped as it is "/I".
So we are thinking of discarding this option for the users. Any thoughts..
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.