WordPress

Installation

With Microsoft SQL

Installing WordPress to use MS SQL is not recommended. It is possible, but its a bit of a bodge and you may encounter problems at a later date. You can install MySQL on Windows, and this is a preferred route to take if possible.

You'll need to have a working installation of PHP completed on your webserver 1st

1. Create a new blank database on your MS SQL server with a user
2. Install the Microsoft Drivers 3.0 for PHP for SQL Server
   • http://www.microsoft.com/en-us/download/confirmation.aspx?id=20098
   • Make sure that the sqlsvr extension is being loaded by PHP (you may need to restart IIS). Create a single PHP page with the content below.
3. Copy WordPress into the web root
4. Download and install the WP Db Abstraction plugin so that WordPress can access MS SQL
   • http://wordpress.org/plugins/wordpress-database-abstraction/installation/

<?php
phpinfo()
?>

Configuration

Pretty Permalinks

The WordPress documentation recommends editing your site's .htaccess file in order to set-up pretty looking permalinks . However, where possible Apache advise against using a .htaccess file as it can impact a site's performance . To do so, update your site's config file as follows...

RewriteEngine On

RewriteRule ^index\.php$ - [L]
RewriteCond %{DOCUMENT_ROOT}%{REQUEST_FILENAME} !-f
RewriteCond %{DOCUMENT_ROOT}%{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]

Add the above to the config for the site (not within a <Directory /> subsection for example). In order to stop Apache looking for an .htaccess file to process, ensure AllowOverride is disabled, for example...

<Directory />
    AllowOverride None

</Directory>

Send Emails via SMTP Server

If you need to configure your WordPress install to use an SMTP server then there is no way to achieve this via the existing admin console (there are Plugins that do this though).

Out of the box WordPress will try to use PHP's mail function, which will either try to use sendmail (on Unix) or an external MTA (on Windows). To send emails via an external SMTP server use the procedure below.

Be aware that changes made may be overwritten by software upgrades, and line numbers etc will change. Procedure below was created using WordPress v3.6, will update when necessary for subsequent releases

1. Update /wp-includes/pluggable.php to use SMTP
   1. Find the line $phpmailer->isMail();
      • In vi use /$phpmailer->isMail(); to find, should be around line 400
   2. Update it to $phpmailer->isSMTP();
   3. To update the From name in email update $from_name = at around line 320
   4. To update the From email address in email update $from_email = at around line 335
2. Update /wp-includes/class-phpmailer.php to configure the SMTP server connection settings
   1. Find the line public $Host = ;, should be around line 225, and update with MTA hosts
      • EG public $Host = 'mail.domain.com;mail2.domain.com';
   2. If you need to use a secure connection set public $SMTPSecure to ssl or tls as appropriate
   3. If you need to authenticate with the server set the following...
      • public $SMTPAuth = true;
      • EG public $Username = 'blog-email-account';
      • EG public $Password = 'blog-email-ac-password';
      • EG public $SMTPSecure = 'tls'; (if required, could also be ssl)

It's a bit of a pain to test, but if you've got comment notifications turned on, create a comment that needs approval and see if you get an approval request.

The above was based on http://maisonbisson.com/blog/post/12939/using-wordpress-with-external-smtp-server/