During this time, the project of the hand is close to the end. It has been unless otherwise not paying attention to the problem, but it refers to the unique engineering installation package, and there is a database instance on lack of the operating environment. Installation and database data installation recovery. Here first, the experience of packaging the MSDE into the installer is shared, then let's talk nonsense.
When your project is basically completed, when you are ready to publish, making a user using a simple automatic installation package to become another problem after the encoding is completed, whether the engineering development is full, from the installation, the user should have a The initial experience.
Let's briefly introduce how to add Microsoft SQL Server 2000 DeskTop Engine (MSDE) to add Microsoft SQL Server 2000 DeskTop Engine (MSDE). MSM:
1. First you need to download the MSDE2000 SP3 installation package. You can download from the link below, url: http://www.microsoft.com/sql/downloads/2000/sp3.asp
2. Download, you can install or use zip to decompress the local hard drive, you will see: MSI, MSM, Setup These 3 directory and SETUP, where Dongdong in the MSM folder is the MSDE2000 you want to introduce this article. Merger modules.
3. Add a installation project in your project (assuming to MySetup1, the path is C: / MySetup1), add the project output, select the output file (Content File ", select the output file (CONTENT FILES) Two.
4. Add a merge module, select Browse, specify to your MSDE MSM folder, select all files under MSM and MSM / 1033 (Repl.MSM, REPL_RES.MSM, DMO_RES.MSM, and DMO. MSM can be not selected), open.
5. Set SearchPath in the properties of the installation project, specify the path where your MSM is located (you need to add two: Path / MSM and PATH / MSM / 1033).
6. Set other properties about the installer, we don't mention it, this is to compile your installation project. When compiling, you can see your packaging project MySetup.msi in C: / MySetup1 / Debug / .
7. This is the project to make a decline. Here we need to modify the laying installation package so that it can automatically install an instance of MSDE after installed the program (assuming instance name: MyServer). Now we need to use a tool ORCA for MS, download address: http://support.microsoft.com/default.aspx? Scid = kb; EN-US; 255905 After installing ORCA, you can use this tool to our MySetup1 .msi makes it modified.
8. Use ORCA to open the installation package file MySetup.msi, find the Property Table, add row to fill in the protropETanceName, and fill in the instance name MyServer in the Value. See: http://support.microsoft.com/?i = 810826 and http://support.microsoft.com/default.aspx?scid=kb;n-us; 281983
9. All the properties of the password, I have no success, it is SQLSAPWD, this parameter is used with SqlSecurityMode, but I have not set success, the password is always empty, I don't know what is! 10. Select Installexecutesequence this table, find the setPropsqlmsdeInstalled this action, modify 206 is 102; find RemoveexistingProducts, modify 1525 to 6601. Save, exit!
At this time, run your installation package on the machine without the SQL environment. After the program is installed, the MSDE's Myserver instance is automatically installed, and the instance of SQL Server is automatically launched after the machine is restarted.
"About the engineering band database package (2) - Automatically install custom MSDE instance"
