Configuring Microsoft SQL Server

To configure Microsoft SQL Server for Maximo® Manage, 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.

See the following guidelines for configuring the database:

If the original database was created in a version earlier than Microsoft SQL Server 2019, set the compatibility level to the older version to maintain the execution plan.

Set the transactions isolation level by using the following commands:

ALTER DATABASE MyDatabase  
        SET ALLOW_SNAPSHOT_ISOLATION ON  

        ALTER DATABASE MyDatabase  
        SET READ_COMMITTED_SNAPSHOT ON

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.

Procedure

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.
Verify that you enabled the Full-text Search setting during the installation of Microsoft SQL Server.
Create a Microsoft SQL Server database.
1. In 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) field to 500 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 Maximo Manage in a specific language, choose the default collation for the database.
  For example, to deploy the application in English, select Latin1_General_100_CI_AS_KS_SC_UTF8.
  Starting from Maximo Application Suite 9.0, Maximo Manage supports a Microsoft SQL Server database that uses Unicode. You must select a collation that has UTF8 in its name. Microsoft SQL Server supports multiple languages in the same database in instances where the chosen languages support the same Microsoft SQL Server collation. For example, English and French can be installed because both languages 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.
Create the Maximo user for Microsoft SQL Server.
1. In Microsoft SQL Server Management Studio, from the SQL Server Configuration Manager navigation, click Databases.
2. Right-click the maxdb80 database and select New Query
3. 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.
4. Enter the following command to change the database owner to MAXIMO.
```
sp_changedbowner MAXIMO
go
```

What to do next

Gather the following information for your database:

The host and hostname.
The port.
The database name.
The username and password for the database user. These values are created as part of configuring the database.
The table space, index space, and schema values. These values are created as part of configuring the database.