Binaryworld - How to install MSDE ... [ SQL Server -> Installation ]

To install MSDE first extract files to a folder e.g. c:\sql2ksp3 then run folloing command on command prompt
c:\>cd sql2ksp3

You can specify installation option either in command line itself or specify in setup.ini

[1] Specifying parameters in command line

For example the following command line will install new MSDE instance "TestMSDE1" in SQL Authentication mode and sa password=MySaPassword. Specify DISABLENETWORKPROTOCOLS=0 if you want to allow MSDE to accepts remote connections. This will generate log file at c:\Msde.txt.

If You dont specify INSTANCENAME then setup will create default instance and if you specify some name then its a new instance with specified name. You can accss named sql server instance using servername\instancename so on my machine i can access this new instance using MYMACHINENAME\TestMSDE1. Default instance can be access by just machine name.

Click here to copy the following block

setup.exe INSTANCENAME="TestMSDE1" SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 SAPWD="MySaPassword" /L*v "c:\Msde.txt"

[2] Specifying parameters in Setup.ini

You can modify Setup.ini file located in the same folder of MSDE to specify various configuration parameters. Here is an example

Click here to copy the following block

[Options]
SAPWD=MypSaPassword
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0

For more option check the MSDE Setup Readme.html

Note: When you install MSDE then it first checks for any exising SQL Server installation and if you already have any previous installation then you must specify INSTANCENAME otherwise you may get "Invalid Instance Name" error. When you get this error make sure that you dont have any previous SQL Server folders under Program Files. If you had some problem in uninstall and you cant think anything else then just rename the previous "Micrsoft SQL Server" folder in Programm Files or just delete if its not very critical. This is only required to install Default Insance.