Microsoft SQL Server 2000 Desktop Engine MSDE
July 13, 2005 | In DeveloperInstallation
Unlike most Microsoft applications, you cannot double click the MSDE setup.exe file to install. Doing so will start the Windows Installer, but the install may error out and fail. Instead, change to a command prompt, and run setup with the appropriate switches.
If you want MSDE to run in mixed mode, accepting both SQL and Windows security, then the switch “SECURITYMODE=SQL” is required. When running in mixed mode, a blank sa password is not allowed, the switch “SAPWD=”AStrongPassword” must be included.
Optionally, an instance name can be specified using INSTANCENAME=”InstanceName.” If omitted, a default SQL instance is created. If MSDE should accept connections from other machines on the network, there is a switch for enabling or disabling network protocols. “DISABLENETWORKPROTOCOLS=n”, with a value of either 1 for No, or 0 for yes. Default data and target directories can be specified using DATADIR=”data_folder_path” and TARGETDIR=”executable_folder_path”. A typical install may look like:
setup sapwd="myPWD" DISABLENETWORKPROTOCOLS=0 securitymode=sql
