PDA

View Full Version : SQL Server 2005 Problem/Question



NewsArchive
12-31-2007, 02:58 AM
Frequently when i install a SQL 2005 instance using setup builder, the setup
fails, not giving me a reason why it failed. I have learned that what i need
to do i uninstall "Microsoft SQL Server Setup Support Files" From add/remove
programs in order to get it to work.

This will happen if SQL 2005 has been previously installed, even if its a
different instance than the one i am installing.

Is there a fix for this? I know that i must uninstall the setup files, but
my customers wont.

TIA

Tim Morrison

NewsArchive
12-31-2007, 02:59 AM
Tim,

What fails is the Microsoft SQL 2005 redistributable. What you could try to
do is to detect (from your installation script) if the SQL 2005 instance is
already there. If this is the case, display a message box and ask the user
to uninstall the SQL Server Support files.

What do you think?

Friedrich

--
Friedrich Linder
Lindersoft
www.lindersoft.com
+1.954.252.3910

"point. click. ship" - that's SetupBuilder 6.7
Create Windows Vista ready installations in minutes

-- Official Comodo Code Signing and SSL Certificate Partner

NewsArchive
12-31-2007, 02:59 AM
How do i check for the existance of a specific SQL 2005 Instance?

TIA

Tim

NewsArchive
12-31-2007, 02:59 AM
Tim,

>
> How do i check for the existance of a specific SQL 2005 Instance?
>

The information should be in the SQL 2005 manual.

But you posted that it works if the customer uninstalls "Microsoft SQL
Server Setup Support Files" from add/remove programs. So what you can do is
to check from your script if this is in the registry. The Add/Remove panel
entries can be found at HKLM\Software\Microsoft\CurrentVersion\Uninstall

And if the "UninstallString" is provided, you can even ask the user (from
your install program) whether to automatically start the "Microsoft SQL
Server Setup Support Files" uninstall process.

Does this help?

Friedrich

--
Friedrich Linder
Lindersoft
www.lindersoft.com
+1.954.252.3910

"point. click. ship" - that's SetupBuilder 6.7
Create Windows Vista ready installations in minutes

-- Official Comodo Code Signing and SSL Certificate Partner

NewsArchive
01-02-2008, 12:17 PM
Hi Friedrich,

I'd like to implement this, but am having trouble finding
HKLM\Software\Microsoft\CurrentVersion\Uninstall; see attached.

Greg Fasolt

NewsArchive
01-02-2008, 12:18 PM
Hi Greg,

Friedrich's brain is quicker than his typing. It should be:
HKLM\Software\Microsoft\Windows\CurrentVersion\Uni nstall

Best Regards,
Geoff Spillane
Data Down Under

NewsArchive
01-02-2008, 12:19 PM
Thanks, Geoff.

Greg Fasolt

NewsArchive
01-02-2008, 12:20 PM
Oops! You are so right ;-)

Friedrich