/build/static/layout/Breadcrumb_cap_w.png

Software Deployment Question


Issues with Repair in SQLexpress 2005 SP2

10/29/2008 3773 views
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


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

All 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

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

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

0
Will give it a try..
Answered 10/29/2008 by: prathiappdeploy
Senior Yellow Belt

0
Didnt help.
Answered 10/29/2008 by: prathiappdeploy
Senior Yellow Belt

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

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

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ