Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 MSDE (2000)
 Creating an msi package for MSDE

Author  Topic 

izaltsman
A custom title

1139 Posts

Posted - 2002-10-16 : 14:21:25
Hi All!

I am working on an application that will use MSDE as a back end... I want to create a windows installer package (an .msi file) that installs only the required components of MSDE (i.e. I don't need replication and DMO). I found this article (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_8yeq.asp), which tells me what merge modules I need to include in the install package, but it doesn't walk through the details of package creation process . I have tried editing sample.msi package with the tools from Win installer SDK as suggested in the article, but I can't figure out what entries I have to remove from the msi. I would be very grateful if someone could shed some light on how to create an msi package for MSDE installation, or on how to create installer packages in general.

izaltsman
A custom title

1139 Posts

Posted - 2002-10-17 : 17:49:05
Well, I ended up going a different route -- instead of editing the sample msi's I built an msi from scratch, using Visual Studio Installer. Appears to be working quite well for me.

Go to Top of Page

izaltsman
A custom title

1139 Posts

Posted - 2002-11-05 : 14:48:23
OK, now I am back with a twist on the original problem. I need my custom Windows Installer package to install a named instance of MSDE. Everything I've tried so far installs a default instance. Does anyone know what I could do to the msi package in order to install a named instance?

Go to Top of Page

izaltsman
A custom title

1139 Posts

Posted - 2002-11-05 : 16:08:45
OK, got an answer (thanks to digital_pilot of SQL.ru).
All I had to do was to add a row into a Property table with the property = 'SqlInstanceName' and value = 'mycoolinstance'

Go to Top of Page
   

- Advertisement -