MSDE Setup

To setup MSDE

1. Run in your MSDE setup folder. securitymode=sql specifiy that people can access database using window authentication and also SQL authentication. disablenetworkprotocols=0 enable network access. sapwd is the password of login name sa.

2. Open TCP port in windows firewall. It is done in control panel windows firewall and add port in the exception tab page. The default prot number for MSDE is 1433

3. Download and install MSDE SP4. It is done by running the following command in the MSDE SP4 folder