Here are my instructions for setting up a dedicated Windows 2003 server at Crystaltech, since I am not using one anymore I thought I would publish it now.
These step by step instructions were written for me, I was never going to publish them, so I hope you can make sense of them. I wish I had something like this when I started with my new box. It took me a month to set it up and test out.
This is split up in to two parts, setting up the box and then setting up each site for Crystaltech hosting.
Dedicated Box Set Up ($75 for the work CT did and I did the rest):
- Coldfusion 8 installed (CT dedicated team)
- PHP installed (CT dedicated team) PHP Version 5.2.5
- SmarterMail (CT dedicated team)
- SmarterStats (CT dedicated team)
- SmarterTicket (CT dedicated team)
- Ports on Firewall lock down for my IP address (CT dedicated team)
- MySQL5 installed and configured by me with CT help
- Created a database
- Setup U-Serv from the article #582, loaded site in intenetpub and not wwwroot
- Loaded the new HeidiSQL, and then create user for me
- Changed some Coldfusion settings like debug and other items
- Setup a 95% processor alert for Sysmon
- Setup the CT monitor for each site
- Make the upload blog dir just “write” for that folders permissions
- Please go into SQL and uncheck “maintain connection” your SQL sessions may be causing this issue.
- Ok, In IIS click on Smartermail –> Properties Go to the ASP.NET tab. Change it from 1.1 to 2.0 and then say ok
- Added flv file ext to all sites
- Run dnsstuff tests
- Deactivate WP plugins on transfer
- Setup reverse dns in ctrl ctr
- uncheck: Enable Robust Exception Information
- added SPF record v=spf1 a mx ip4:67.199.xx ?all #798 article
- We have verified that port 443 is open you will need to go into IIS and on the Web Site Tab you should be able to set the SSL port to 443.
- Exported SSL pfx to dedicated box following the KB#241
- Copy LPICOM_6_0.dll to the %ROOT%/system32 directory (C:\WINNT\system32\).
- Register the LPICOM_6_0.dll. (regsvr32 c:\windows\system32\lpicom_6_0.dll)
- Backup wordpress folder is writable for db backup
- After about 3 weeks the SSL cert failed in both browsers, tech placed three new files on the server and fixed it, something to do with a Global cert. More info here: https://crystaltech.xrampsecurity.com/support.php?s=val
- CT turned off shadow copy because it eat up all my hard drive space
- Services: In properties (right click on MySql service, recovery tab) I now have it set to restart the service after Second failure and restart after 1 minute
- I changed the Folder from PHP 5.2.5 to just PHP and then added the Web Extensions and added .php to the IIS website extensions as well.
Setting up a New Site on the box (Takes me 2.5 hours per site)
WWWRoot Dir
- Create a new directory in wwwroot on the server.
CT Control panel DNS Reverse Zone Manager
- Check which IP is the next available in the IP block
FTP Serv-U Setup

- Lock down the directory just in case.
- Add a user with the domain name minus the extension
- Check boxes on the right hand side – except execute.
- Troubleshoot: if it does not work, CT may not have allowed the new IP addresses in the firewall after Comcast modem reset.
Dreamweaver:
- Upload all the files.

MySQL Setup
- WordPress make sure you deactivate the Quickstats before moving the database
- Upload the DB via FTP; or
- Setup a new DB – do this from the Server – permissions for the user issues

IIS Web Site Setup KB#586
- Run through the wizard and you will see it is stopped
- Make all the changes below
- Then start the site in pull down right click

Host Header Value – don’t use.




Computer Management Console
- KB 564 (don’t do NS1, NS2 Host A setup, skip steps 5 and 6)
- KB 566 add X to host and revise to * at bottom of article
- Add another host a record for email
- Add a TXT record: v=spf1 a mx ip4:67.199.xxx ?all
- http://www.michaelbrumm.com/spfwindowsdns/

CT Control Center
- KB 572 Reverse DNS Zones for mail
- www.dnsstuff.com to see if you have it right after 24 hours
Set up the DSN for the database in CF Admin


In CF Admin add a new DSN for the database.
Do not check “maintain connections” (default) because your sessions will die in 20 minutes and show an error for invalid session. You will get an error until you load the DB.
Firefox
- Type in the IP address to see if it is working, or on the box with the true URL
- (after GoDaddy) Try the actual domain name sometimes it is just a few minutes or 12 hours on Comcast. In the beginning if it does work right away you will see no IP address at the bottom of FF.
- Reboot because of TTL on local machine if mail is still not working after 12 hours
- ipconfig/flushdns
GoDaddy (do now because it takes awhile)
- Change over to NS1.x.com and NS2. x.com
- Reboot local machine to clear DNS.
- Cancel old shared host
Set up Stats:
- Log on with admin for the site ID for the main stats area
- Use full url for domain
- Log format iis W3cex format
- Check “Trim URL”
- Put in the default page extensions “default.cfm,index.php”
- c:\inetpub\wwwroot\x for export dir
- CT: “When you go through the Site Setup there is an option to browse IIS for the Site Folder. That is way easier than manually typing the location of the Website Log files. Use that Option when you setup additional sites on SmarterStats.”
- you have to visit the ip address at least once to set up the stats or you will get an error it can’t find the right folder to access them
Setup mail
- Technical / check Require SMTP Authentication
Tests
- http://www.checkdns.net/quickcheck.aspx
- http://www.rexswain.com/httpview.html
- http://uptime.netcraft.com/
- http://whois.domaintools.com/
Security Issues

- This was not checked (top box) http://technet.microsoft.com/en-us/library/cc787602.aspx so it did not pass Security Metrics test. This means you will not be able to surf the web on your box (you will see your own sites). But this kills the xml parsing for Google API to maps on the geocode.



