Problems encountered during installation of Microsoft SQL Server Desktop Engine (1)

After reading this book Beginning C # Databases for a few days, I feel that it has been well written and is very suitable for beginners. The examples in this book use the SQL database, but for convenience, the Code has always been adapted to ACCESS databases. In order to improve your own level, we will download the MSDE and install it for study as described in the book.
After decompression, double-click setup.exe and a dialog box pops up: "To ensure security, you must use a strong SA password. Use the SAPWD switch to provide the same password. For more information, see the README file. The installer will exit immediately ." Depressed, doesn't the book seem to have written such a thing? What's going on? But fortunately, Bill asked me to read the README file, so let's take a look. The following is an introduction to the README file:

========================================================

You can specify the Desktop Engine Setup.exe parameter in the following two locations:

Run Setup.exe at the command prompt.
In the. ini file specified by the/settings switch .. The ini file is a text file, such as a file created using Notepad and saved using the extension. ini .. The first line in the ini file is [Options]. You can then specify the parameter. A parameter occupies a row.
Important if you use the. ini file during installation, do not store security creden。 in this file.

The following example shows how to specify parameters at the command prompt:

Setup SAPWD = "AStrongPassword" INSTANCENAME = "InstanceName" TARGETDIR = "C:/MyInstanceFolder"

To use the. ini file to run the installer using the same parameters, use Notepad to create a file named MyParameters. ini. The content of the file is as follows:

[Options]
INSTANCENAME = "InstanceName"
TARGETDIR = "C:/MyInstanceFolder"
Then, when running the installer, use the/settings switch to point to the. ini file:

Setup/settings "MyParameters. ini" SAPWD = "AStrongPassword"

========================================================
In the command prompt line, type "Setup sapwd =" chengbo "instancename =" study "and press enter to start installation. However, the installation is complete without any prompts, there is no MSDE shortcut in the Start menu, and there is no SQL Server Service Manager in the lower right corner. It is estimated that the installation was not successful and I do not know what is going on.

It's not too early tonight. I will try again later.