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

Mobile Phone Information

*#06# to get IMEI code
*#0000# to get firmware version
default PIN code of Smartone is 1234
default PIN code of People is 8888 (not sure)

Install Php + MySQL + PhpMyAdmin on XP with IIS

1) Install Php 5.2.3
-> window installer version
-> choice web server: iis4isapi
-> choice extensions:
- GD2
- Multi-Byte String (mbstring, for PhpMyAdmin)
- Mcrypt
- MSSQL
- MySQL
- Zip


2) Test Php
-> create a php file with following content
<?php phpinfo(); ?>
-> work!


3) Install MySQL 5.0.41
-> setup.exe version


4) Config Php
-> edit config file: php.ini
-> uncomment following lines for extensions:
extension = php_mbstring.dll
extension = php_mysql.dll
-> update following paths to support session: (PhpMyAdmin requires session support)
upload_tmp_dir="C:\PROGRA~1\PHP\upload"
session.save_path="C:\PROGRA~1\PHP\session"
-> add IUSR_ with edit permission for above folders
-> restart computer

* to stop iis: net stop iisadmin (it will stop all iis related service)
* to start www service: net start w3svc
* to start ftp service: net start msftpsvc
* to start smtp service: net start smtpsvc


5) Install PhpMyAdmin 2.10.2
-> create a folder named phpmyadmin under web folder
-> unzip to phpmyadmin folder


6) Test PhpMyAdmin
-> browse http://localhost/phpmyadmin/scripts/setup.php
-> work!