Configuring Microsoft SQL Server

To configure Microsoft SQL Server for Maximo® Health, you create table spaces, create a database user, and configure database settings.

Before you begin

For information about configuring Microsoft SQL Server, review the Microsoft SQL Server product documentation.

For information about supported database versions, you can generate a Software Product Compatibility Report. Search for IBM® Maximo Application Suite and select the suite version to generate the report. Check for the supported database versions in the Supported Software tab of the report.

About this task

Use the READ COMMITTED isolation level. For more information, see the Reducing locking article on IBM Support.

Procedure

  1. Configure the listener port.

    The default instance of the Microsoft SQL Server Database Engine listens on TCP port 1433. Named instances of the Microsoft SQL Server Database Engine and Microsoft SQL Server Compact Edition are configured for dynamic ports, which means they select any available port when the service starts. When you connect to a named instance across a firewall, configure the Database Engine to listen on a specific port to open this port in the firewall.

    1. Open Microsoft SQL Server Configuration Manager.
    2. From the Microsoft SQL Server Configuration Manager navigation, expand SQL Server Network Configuration > Protocols for <instance name> and then double-click TCP/IP.
    3. In the TCP/IP Properties dialog box, click the IP Addresses tab.
    4. For each IP address listed, ensure that the TCP Dynamic Ports field is blank.
      If the TCP Dynamic Ports field contains a value of 0, that IP address is using dynamic ports. Since Maximo Health requires Microsoft SQL Server to listen on a static port, this field must be blank.
    5. For each IP address listed, enter 1433 for the TCP Port field.
    6. Click OK.
    7. From the SQL Server Configuration Manager navigation, select SQL Server Services.
    8. Right-click SQL Server (<instance name>) and then click Restart to stop and restart Microsoft SQL Server.
    9. Verify the Microsoft SQL Server instance is running, and then close SQL Server Configuration Manager.
  2. Verify that you enabled the Full-text Search setting during the installation of Microsoft SQL Server.
    To determine whether Full-text Search is installed on your existing Microsoft SQL Server database, complete the following steps:
    1. Open SQL Server Management Studio, select SQL Server Authentication as the authentication type, and enter the credentials for the sa user ID, and then click Connect.
    2. Click New Query and enter the following command: 
      select FULLTEXTSERVICEPROPERTY ( 'IsFulltextInstalled' )

      If you did not install Full-text Search (the resulting value is zero), you must do so now. To install Full-text Search, insert the Microsoft SQL Server product media into the system and start the installation wizard. Navigate through the wizard and enable the Full-Text Search option that is on the Custom portion of the Setup Type dialog box. To finish the installation process, restart the server.

  3. Create a Microsoft SQL Server database.
    1. From Microsoft SQL Server Management Studio, select New Database from the databases folder.
    2. Specify a unique database name.
      For example, enter maxdb80
    3. For the maxdb80 Logical Name, change the Initial Size (MB) attribute to 500 (MB), and also set the value of the Autogrowth / Maxsize field to By 1 MB, Unlimited.
    4. Optional: Modify the log settings to accommodate your production environment.
    5. To deploy in a specific language, choose the default collation for the database.
      For example, to deploy the application in English, select Latin1_General_CI_AI.
      Although does not support a Microsoft SQL Server database using Unicode, it is possible to deploy in multiple languages if the chosen languages support the same Microsoft SQL Servercollation. For example, English and French can be installed because both support the same Microsoft SQL Server collation. However, English and Japanese cannot be installed together because they have different Microsoft SQL Server collations.

      For more information, review the Microsoft SQL Server Collation and Unicode support documentation.

  4. Create the Maximo user for Microsoft SQL Server.
    1. Open Microsoft SQL Server Management Studio.
    2. From the SQL Server Configuration Manager navigation, click Databases.
    3. Right-click the maxdb80 database and select New Query.
    4. Enter the following command to create the Maximo database user MAXIMO with a password that adheres to the password policy of the system. 
      sp_addlogin MAXIMO,password
go
      This value is case-sensitive.
    5. Enter the following command to change the database owner to MAXIMO. 
      sp_changedbowner MAXIMO
go