Not a developer? Go to MovableType.com

MovableType.org
MT5 Documentation
Home / MT5 Documentation / Movable Type 5 Advanced

Using Dynamic Publishing on MS SQL Server 2012

The following configuration changes must be made if you want to use dynamic publishing with MS SQL Server 2012 (SQL Server).

Prerequisites

  • PHP must be version 5.3.6 or higher.
  • Microsoft SQL Server 2012 Native Client must be installed on the server.
  • Microsoft Drivers 3.0 for PHP for SQL Server must be installed on the server.

Necessary Settings for Using the SQL Server with PHP

Any necessary Microsoft drivers must first be installed.

  1. Download Microsoft Drivers 3.0 for PHP for SQL Server from the official download page.
  2. Unzip the file to your desired location.
  3. The unzipped file should include several PHP Non-thread-safe and Thread-safe files.
  4. Copy the PHP installation directory "ext" and paste it into the target file. (An example target file might be "php_sqlsrv_53_nts.dll")
  5. Configuring php.ini
    Edit the following lines in php.ini
cgi.force_redirect = 0
extension=php_sqlsrv_53_nts.dll  <= Enter the name of the previously installed DLL
mssql.textlimit = 2147483647
mssql.textsize = 2147483647
mssql.datetimeconvert = Off
mssql.secure_connection = On

Dynamic publishing is now set up for MS SQL Server 2012. To use dyanimc publishing with Movable Type Advanced, you will also need to make several configuration changes from the MTA dashboard.

Back