Microsoft KB Archive/280352

= How To Install SQL Server CE from the Command Line and Generate a Log File =

Article ID: 280352

Article Last Modified on 2/22/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Windows CE Edition

-



This article was previously published under Q280352



SUMMARY
This article describes how to install SQL Server CE from the command line and generate a Windows Installer log file.

The SQL Server 2000 Windows CE Edition Web download file, SSCE_Setup.exe, provides an integrated setup of Windows CE Data Access 3.1 and SQL Server 2000 Windows CE Edition Development and Server Tools.

You can also call the Windows Installer executable file (Msiexec.exe) to install SQL Server CE and the Windows CE Data Access 3.1 distribution manually. Doing so allows you to create a verbose log file (by using the /L*V switch) for troubleshooting purposes.



MORE INFORMATION
To install SQL Server CE and Windows Data Access 3.1 from the command line, follow these steps:

 Run SSCE_Setup.exe to extract the run-time files. Do not make a selection when the setup prompts you to choose whether to install the Development or Server tools or the temporary folder the files are stored in will be deleted. If you are installing to a Microsoft Windows NT computer, use Windows Explorer to navigate to the C:\Temp folder. If you are installing to a Microsoft Windows 2000 computer, navigate to the C:\Documents and Settings\ \Local Settings\Temp folder. Locate the new temporary folder inside \Temp, which contains the following *.msi files:

 Copy this folder and all its contents to a different location on your hard drive. Cancel the integrated SSCE_Setup distribution. Open a command prompt and navigate to the the newly copied folder that contains your extracted setup files.  Call the Windows Installer executable file (Msiexec.exe) to install the Windows CE Data Access 3.1 distribution as follows:

msiexec /I adoce31.msi /L*V c:\adoinstall.log

NOTE: The preceding example assumes that you want the install log to be placed in the root of your C: drive. You may place the install log anywhere you want. </li>  After the Data Access components have finished installing, you can verify that the setup completed successfully by reviewing the log file. You should see the following at the end of the log: <pre class="fixed_text">Action ended 8:57:37: INSTALL. Returned Value 1. ... MSI (c) (E7:F3): Product: Windows CE Data Access 3.1 -- Installation operation completed successfully. </li>  Next, call the Windows Installer to install SQL Server CE:

msiexec /I SSCESetup.msi /L*V c:\SSCESetup.log

NOTE: You may place the SSCESetup.log file anywhere you want on your file system. </li>  Verify that SQL Server CE was installed correctly by locating the following text at the end of the SSCESetup log file: <pre class="fixed_text">Action ended 9:07:24: INSTALL. Return value 1. ... MSI (c) (05:F1): Product: Microsoft SQL Server 2000 Windows CE Edition -- Installation operation completed successfully. </li></ol>

<div class="references_section">