Not a developer? Go to MovableType.com

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

Using MS SQL Server 2012 with SQL Server Authentication

This document will explain how to set up a MS SQL Server 2012 (SQL Server) using SQL Server Authentication.

For more information on SQL Server set-up, please refer to this document.

Creating a SQL Server 2012 Database

  1. Right click "Database" and choose "New Database".
  2. From the "New Database" creation screen, go to "General" to set the following:
    • Database Name: mta
    • Owner Name:
  3. From the "New Database" creation screen, go to "Options" and set the following:
    • Collation: select the appropriate collation option from the list
    • Recovery Model: Complete
    • Compatibility Levels: SQL Server 2012 (100)
  4. Click the "OK" button to finish

Registering a New Login

  • To create a new login, go to "Security" ? "Login" ? "New Login".

    ????????????

  • Change the authentication method from "Windows Integrated Authentication" to "SQL Server Authentication".
  • Set the "Login Name" to "Melody" and the "Password" to "Nelson". You will need to enter the password twice, once to confirm.
  • Un-check the box next to "Enforce password policy".
  • Select "Mapped to certificate" and set db_owner as the owner of the "Melody" database.
  • Click the "OK" button to finish.

Testing the Database Connection

We will use Management Studio to try connecting to the database we just created.

  1. Open the database connection screen in Management Studio

    Make sure the "Authentication" method is set to "SQL Server Authentication".

    • Authentication: SQL Server Authentication
    • Login Name: Melody
    • Password: Nelson
  2. Click the "Connect" button.

    You will know if the connection was completed successfully as you will gain access to the database on a system level.

    Confirm through the "security" option that only two users, "Melody" and the default testing user "sa", have connection access at this point.

Configuring the Database through mt-wizard.cgi

Change the database settings to those pictured in the screenshot below.

mt-config.cgi database settings

#======== DATABASE SETTINGS ========

ObjectDriver UMSSQLServer
Database mta
DBHost localhost
ODBCDriver SQL Server Native Client 10.0
DBUser Melody
DBpassword Nelson

The database should now be accessible via SQL Server Authentication.

Back