Can 2 installation of MSDE coexist on one PC ?

[JacquesT]

Hi All,

We have 2 apps that use MSDE 2000. One app uses MSDE 2000 SP4 and is already
installed on the workstation. If I install, on the same machine, a second
app using MSDE 2000 SP3 then the first app stops working. I was able to run
a conflict detection tool (from Altiris) that gave me the result file
that I could send you (104 Kb). The tools scans two installation packages,
created on a newly
installed computer and shows potential conflicts between the 2 apps.

I`d like to know what can I do to make these apps coexist?

Here are a few lines from the conflict result file (too big to post):


Rip 1 = C:\temp\FDT1000.exe
Rip 2 = C:\temp\GMobile.exe

******************** REGISTRY CONFLICTS **********************

Data mismatch:
Rip 1: $Local
Machine$\SOFTWARE\Classes\Installer\Products\5B84B90E141EA724BAC03D06157222A4\ProductName
ProductName
Data: Microsoft SQL Server Desktop Engine (FDT)
Rip 2: $Local
Machine$\SOFTWARE\Classes\Installer\Products\5B84B90E141EA724BAC03D06157222A4\ProductName
ProductName
Data: Microsoft SQL Server Desktop Engine

Data mismatch:
Rip 1: $Local
Machine$\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\02CA8A3CB02419F4A928F297F0961F5F\5B84B90E141EA724BAC03D06157222A4
5B84B90E141EA724BAC03D06157222A4
Data: $Program Files$\MSDEMSSQL$FDT\Binn\Resources\1033\sqlevn70.rll
Rip 2: $Local
Machine$\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\02CA8A3CB02419F4A928F297F0961F5F\5B84B90E141EA724BAC03D06157222A4
5B84B90E141EA724BAC03D06157222A4
Data: $Program Files$\Microsoft SQL
Server\MSSQL\Binn\Resources\1033\sqlevn70.rll

Data mismatch:
Rip 1: $Current User$\SessionInformation\ProgramCount
ProgramCount
Data: 0x2 (2)
Rip 2: $Current User$\SessionInformation\ProgramCount
ProgramCount
Data: 0x1 (1)

******************** FILE SYSTEM CONFLICTS ********************

Folder Conflict:
Rip 1: $Program Files$\Microsoft SQL Server\80\COM\sqlresld.DLL Tuesday,
May 08, 2001, 22:37
Rip 2: $Program Files$\Microsoft SQL Server\80\Tools\Binn\sqlresld.DLL
Tuesday, December 17, 2002, 17:25

Folder Conflict:
Rip 1: $Program Files$\Microsoft SQL Server\80\COM\sqlresld.DLL Tuesday,
May 08, 2001, 22:37
Rip 2: $Program Files$\Microsoft SQL Server\MSSQL\Binn\sqlresld.dll
Tuesday, December 17, 2002, 17:25

Version Conflict:
Rip 1: $Program Files$\Microsoft SQL Server\80\COM\sqlresld.DLL
Size: 29184 Bytes
Modified Time: Tuesday, May 08, 2001, 22:37
Rip 2: $Program Files$\Microsoft SQL Server\80\COM\sqlresld.DLL
Size: 29248 Bytes
Modified Time: Tuesday, December 17, 2002, 17:25

[Andrea Montanari]

hi,

Post by JacquesT
Hi All,
We have 2 apps that use MSDE 2000. One app uses MSDE 2000 SP4 and is
already installed on the workstation. If I install, on the same
machine, a second app using MSDE 2000 SP3 then the first app stops
working. I was able to run a conflict detection tool (from Altiris)
that gave me the result file that I could send you (104 Kb). The tools
scans two installation
packages, created on a newly
installed computer and shows potential conflicts between the 2 apps.
I`d like to know what can I do to make these apps coexist?
Rip 1 = C:\temp\FDT1000.exe
Rip 2 = C:\temp\GMobile.exe
******************** REGISTRY CONFLICTS **********************
Rip 1: $Local
Machine$\SOFTWARE\Classes\Installer\Products\5B84B90E141EA724BAC03D06157222A4\ProductName
ProductName
Data: Microsoft SQL Server Desktop Engine (FDT)
Rip 2: $Local
Machine$\SOFTWARE\Classes\Installer\Products\5B84B90E141EA724BAC03D06157222A4\ProductName
ProductName
Data: Microsoft SQL Server Desktop Engine
Rip 1: $Local
Machine$\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\02CA8A3CB02419F4A928F297F0961F5F\5B84B90E141EA724BAC03D06157222A4
5B84B90E141EA724BAC03D06157222A4
Data: $Program Files$\MSDEMSSQL$FDT\Binn\Resources\1033\sqlevn70.rll
Rip 2: $Local
Machine$\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\02CA8A3CB02419F4A928F297F0961F5F\5B84B90E141EA724BAC03D06157222A4
5B84B90E141EA724BAC03D06157222A4
Data: $Program Files$\Microsoft SQL
Server\MSSQL\Binn\Resources\1033\sqlevn70.rll
Rip 1: $Current User$\SessionInformation\ProgramCount
ProgramCount
Data: 0x2 (2)
Rip 2: $Current User$\SessionInformation\ProgramCount
ProgramCount
Data: 0x1 (1)
******************** FILE SYSTEM CONFLICTS ********************
Rip 1: $Program Files$\Microsoft SQL Server\80\COM\sqlresld.DLL
Tuesday, May 08, 2001, 22:37
Rip 2: $Program Files$\Microsoft SQL
Server\80\Tools\Binn\sqlresld.DLL Tuesday, December 17, 2002, 17:25
Rip 1: $Program Files$\Microsoft SQL Server\80\COM\sqlresld.DLL
Tuesday, May 08, 2001, 22:37
Rip 2: $Program Files$\Microsoft SQL Server\MSSQL\Binn\sqlresld.dll
Tuesday, December 17, 2002, 17:25
Rip 1: $Program Files$\Microsoft SQL Server\80\COM\sqlresld.DLL
Size: 29184 Bytes
Modified Time: Tuesday, May 08, 2001, 22:37
Rip 2: $Program Files$\Microsoft SQL Server\80\COM\sqlresld.DLL
Size: 29248 Bytes
Modified Time: Tuesday, December 17, 2002, 17:25

techincally, up to 16 instances of SQL Server 2000/MSDE 2000 can be
installed on the same machine, at different service pack level, so the
answer is "yes".. only one of them can be the "default" instance where all
the other must be "named instance".. default instances are reacheable
referring to the computer name hosting SQL Server, where named instances are
known as ComputerName\InstanceName..

a note about the conflicts.. each installation of SQL Server/MSDE requires
both a private set of binaries, that are installed in the instance's
specific folder (so that you can have MSDE RTM + MSDE sp1 + MSDE sp2+ MSDE
sp3 + MSDE sp4 and so on) and a "shared" set of them, that always are
installed in \Program Files\Mocprosoft SQL Server\80\ folder... in this
case, the highest service pack wins, so that, after installing MSDE sp4, a
successive installation of another MSDE instance at sp3 level only installs
the "private" part of the binaries..
regards

[JacquesT]

Andrea,

Thank you for your help!

Best regards,

Post by Andrea Montanari
hi,

Post by JacquesT
Hi All,
We have 2 apps that use MSDE 2000. One app uses MSDE 2000 SP4 and is
already installed on the workstation. If I install, on the same
machine, a second app using MSDE 2000 SP3 then the first app stops
working. I was able to run a conflict detection tool (from Altiris)
that gave me the result file that I could send you (104 Kb). The tools
scans two installation
packages, created on a newly
installed computer and shows potential conflicts between the 2 apps.
I`d like to know what can I do to make these apps coexist?
Rip 1 = C:\temp\FDT1000.exe
Rip 2 = C:\temp\GMobile.exe
******************** REGISTRY CONFLICTS **********************
Rip 1: $Local
Machine$\SOFTWARE\Classes\Installer\Products\5B84B90E141EA724BAC03D06157222A4\ProductName
ProductName
Data: Microsoft SQL Server Desktop Engine (FDT)
Rip 2: $Local
Machine$\SOFTWARE\Classes\Installer\Products\5B84B90E141EA724BAC03D06157222A4\ProductName
ProductName
Data: Microsoft SQL Server Desktop Engine
Rip 1: $Local
Machine$\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\02CA8A3CB02419F4A928F297F0961F5F\5B84B90E141EA724BAC03D06157222A4
5B84B90E141EA724BAC03D06157222A4
Data: $Program Files$\MSDEMSSQL$FDT\Binn\Resources\1033\sqlevn70.rll
Rip 2: $Local
Machine$\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\02CA8A3CB02419F4A928F297F0961F5F\5B84B90E141EA724BAC03D06157222A4
5B84B90E141EA724BAC03D06157222A4
Data: $Program Files$\Microsoft SQL
Server\MSSQL\Binn\Resources\1033\sqlevn70.rll
Rip 1: $Current User$\SessionInformation\ProgramCount
ProgramCount
Data: 0x2 (2)
Rip 2: $Current User$\SessionInformation\ProgramCount
ProgramCount
Data: 0x1 (1)
******************** FILE SYSTEM CONFLICTS ********************
Rip 1: $Program Files$\Microsoft SQL Server\80\COM\sqlresld.DLL
Tuesday, May 08, 2001, 22:37
Rip 2: $Program Files$\Microsoft SQL
Server\80\Tools\Binn\sqlresld.DLL Tuesday, December 17, 2002, 17:25
Rip 1: $Program Files$\Microsoft SQL Server\80\COM\sqlresld.DLL
Tuesday, May 08, 2001, 22:37
Rip 2: $Program Files$\Microsoft SQL Server\MSSQL\Binn\sqlresld.dll
Tuesday, December 17, 2002, 17:25
Rip 1: $Program Files$\Microsoft SQL Server\80\COM\sqlresld.DLL
Size: 29184 Bytes
Modified Time: Tuesday, May 08, 2001, 22:37
Rip 2: $Program Files$\Microsoft SQL Server\80\COM\sqlresld.DLL
Size: 29248 Bytes
Modified Time: Tuesday, December 17, 2002, 17:25

techincally, up to 16 instances of SQL Server 2000/MSDE 2000 can be
installed on the same machine, at different service pack level, so the
answer is "yes".. only one of them can be the "default" instance where all
the other must be "named instance".. default instances are reacheable
referring to the computer name hosting SQL Server, where named instances
are known as ComputerName\InstanceName..
a note about the conflicts.. each installation of SQL Server/MSDE requires
both a private set of binaries, that are installed in the instance's
specific folder (so that you can have MSDE RTM + MSDE sp1 + MSDE sp2+ MSDE
sp3 + MSDE sp4 and so on) and a "shared" set of them, that always are
installed in \Program Files\Mocprosoft SQL Server\80\ folder... in this
case, the highest service pack wins, so that, after installing MSDE sp4, a
successive installation of another MSDE instance at sp3 level only
installs the "private" part of the binaries..
regards
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply