Follow instructions provided by Microsoft and any standards set by your organization. Movable Type will initialize the database and create the necessary tables and indices.

Before you install Movable Type, collect the following information about the database:

• Name
• User name
• Password
• Server host name: localhost, server name, or server IP address
• SQL Server character set: Shift_JIS or ISO-8859-1
• Port number (if not the default: 1433)

If SQL Server is configured to use Windows integrated authentication (recommended), you do not need to provide a user name and password to access the database.

If SQL Server is configured to use Mixed Authentication mode, you must provide the user name and password when you set up Movable Type to use the SQL Server database.

Using SQL Server with Movable Type Dynamic Publishing

Dynamic publishing is a Movable Type option that displays page components directly from the database--instead of generating HTML pages in advance. For a complete description of Dynamic publishing and instructions on how to set up Movable Type to use it, see XXX.

Dynamic publishing requires that you install PHP on your Web server. If you are using SQL Server, you must also install a newer version of the file ntwdblib.dll than is provided with PHP on your database server.

You can get the newer version of ntwdblib.dll from Microsoft SQL Server 2000 if you have it, or request it from Six Apart.

To use the correct protocol from PHP to SQL Server add the following settings to the database server's registry:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo]
   "DSQUERY"="DBNETLIB"

Add the following settings to the Web server's php.ini file:

cgi.force_redirect = 0
extension=php_mssql.dll
mssql.textlimit = 2147483647
mssql.textsize = 2147483647
mssql.datetimeconvert = Off
mssql.secure_connection = On