This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: Problem installing SQLExpress on XP SP3 as prerequisite
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
May 06, 2009
09:37 AM
Problem installing SQLExpress on XP SP3 as prerequisite
Hello
I do have an MSI Installscript project. I am installing the SQL Express 2005 as a prerequisite and that was working fine upto now, as I tried to install the application on a WinXP3.
It seems that the SQL Express 2005 tries to install an older version of the MSXML6 library as the one provided by the SP3 of XP.
The knowledge base of Microsoft explains that in order to install SQL Express on XP SP3, one needs to download Windows Installer CleanUp utility in order to uninstall MSXML 6.0 Service Pack 2 before installing SQL Express.
How do I integrate that in the MSI Installscript project? Is there anyway to have a prerequisite to uninstall the MSXML6 SP2, which has to run before the database installation?
Any help is welcome.
I do have an MSI Installscript project. I am installing the SQL Express 2005 as a prerequisite and that was working fine upto now, as I tried to install the application on a WinXP3.
It seems that the SQL Express 2005 tries to install an older version of the MSXML6 library as the one provided by the SP3 of XP.
The knowledge base of Microsoft explains that in order to install SQL Express on XP SP3, one needs to download Windows Installer CleanUp utility in order to uninstall MSXML 6.0 Service Pack 2 before installing SQL Express.
How do I integrate that in the MSI Installscript project? Is there anyway to have a prerequisite to uninstall the MSXML6 SP2, which has to run before the database installation?
Any help is welcome.
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Jul 16, 2009
07:19 AM
Hi,
a short way to avoid this is to use a SQL 2005 Express server with the same localisation as your OS.
E.g.: WinXP Pro SP3 German - SQL 2005 Expr German => works 🙂
WinXP Pro SP3 German - SQL 2005 Expr English => BAM! 😞
Greetings,
Gøran
a short way to avoid this is to use a SQL 2005 Express server with the same localisation as your OS.
E.g.: WinXP Pro SP3 German - SQL 2005 Expr German => works 🙂
WinXP Pro SP3 German - SQL 2005 Expr English => BAM! 😞
Greetings,
Gøran
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Apr 30, 2010
01:21 PM
Hi tcom
I've come across this problem too. We have customers with older versions of our product in which SQLExpress SP2 was installed. Because they’re running on a XP SP2 box, when SQLExpress SP3 tried to upgrade the previous installation it would explode and in a few cases it’s reported that this cause the blue screen of death.
See http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/68f6527f-7109-44f2-bd05-538339e2f76b
This bug in a Microsoft problem, but I wonder if the short term solution is to just test the target system and if the OS is XP SP2 just stop the installation of SQLExpress and tell the end user the install SP3. Since this redistributable runs as a prerequisite then I would guess adding another condition to the SQLExpress would to the trick. The problem I’m having is that I haven’t found one registry entry that is reliable for testing what OS and SP the installer is running on.
Or is there a way to add some kind of conditional statement to conditions, so if condition X is true try condition Y?
I've come across this problem too. We have customers with older versions of our product in which SQLExpress SP2 was installed. Because they’re running on a XP SP2 box, when SQLExpress SP3 tried to upgrade the previous installation it would explode and in a few cases it’s reported that this cause the blue screen of death.
See http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/68f6527f-7109-44f2-bd05-538339e2f76b
This bug in a Microsoft problem, but I wonder if the short term solution is to just test the target system and if the OS is XP SP2 just stop the installation of SQLExpress and tell the end user the install SP3. Since this redistributable runs as a prerequisite then I would guess adding another condition to the SQLExpress would to the trick. The problem I’m having is that I haven’t found one registry entry that is reliable for testing what OS and SP the installer is running on.
Or is there a way to add some kind of conditional statement to conditions, so if condition X is true try condition Y?