Basic MSDE 2000 Install parameters
This is more for personal reference than anything, but it seems that everytime I install the MSDE I need to go and look up which command line switches I have to use, so I’m putting here to help anyone else out, as well as myself.
This is a very basic configuration that installs the MSDE on the local machine, with an admin password, mixed security mode, and allows network access.
setup.exe SAPWD=myPassword SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0
The network access part is the one I always forget………….
Anonymous said,
Wrote on June 18, 2005 @ 3:58 am
You could also put all those settings in a setup.ini and just install by:
setup.exe /settings setup.ini
Of course I wouldn’t suggest you keep the password in there, which then means you would be back to:
setup.exe /settings setup.ini SAPWD=myPassword
Anyways, I guess what I am getting at is that I have the same problem and have created a setup.ini file that I keep the settings in now and of course I keep a copy of http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_84xl.asp in a folder too!!