Showing posts with label database application. Show all posts
Showing posts with label database application. Show all posts

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