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.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
what is the "repair" entry in the registry? HKLM\Software\Microsoft\Windows\CurrentVersion\Uninstall\{ProductGUID}\ModifyPath
Answered 10/29/2008 by: kiptek
Second Degree Green Belt

Please log in to comment
0
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.
Answered 10/29/2008 by: prathiappdeploy
Senior Yellow Belt

Please log in to comment
0
What happens if you add "A" to the INSTALLMODE property?
Answered 10/29/2008 by: AngelD
Red Belt

Please log in to comment
0
Will give it a try..
Answered 10/29/2008 by: prathiappdeploy
Senior Yellow Belt

Please log in to comment
0
Didnt help.
Answered 10/29/2008 by: prathiappdeploy
Senior Yellow Belt

Please log in to comment
0
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.
Answered 10/29/2008 by: AngelD
Red Belt

Please log in to comment
0
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..
Answered 10/30/2008 by: prathiappdeploy
Senior Yellow Belt

Please log in to comment
Answer this question or Comment on this question for clarity