Sunday, December 30, 2007

Install MSDE 2000

1) Install MSDE 2000
setup sapwd= securitymode=sql disablenetprotocols=0

2) Enable TCP/IP connection
-> Start SQL Server Network Utililty
Start > Run > SVRNETCN
-> Enable TCP/IP

3) Add exception to fireware for TCP port
-> default TCP port: 1433

4) Register SQL server in Enterprise Manager