Manually configuring Microsoft SQL Server for use with Maximo® Asset Management.

You can manually configure Microsoft SQL Server for use with Maximo® Asset Management.

Before you begin

Because Microsoft SQL Server does not support UTF-8, Maximo Asset Management does not have multilingual support when deployed with Microsoft SQL Server.

Microsoft SQL Server Database Collation settings must be set to the following options:

• Dictionary order
• Case-insensitive
• For use with 1252 Character set

About this task

To configure an existing Microsoft SQL Server for use with Maximo Asset Management, perform the following steps before starting the Maximo Asset Management installation program:

Procedure

1. Configure the listener port.
   If The default instance of the Microsoft SQL Server Database Engine listens on TCP port 1433. Named instances of the Microsoft SQL ServerDatabase Engine and Microsoft SQL Server Compact Edition are configured for dynamic ports, which means they select any available port when the service starts. When connecting 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 Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager
   2. From the Microsoft SQL Server Configuration Manager navigation pane, 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 Asset Management 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 pane, click 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 2008. To determine if Full-text Search is installed on your existing Microsoft SQL Server database, perform the following steps:
   1. Open SQL Server Management Studio, select SQL Server Authentication as the authentication type, and enter the credentials for thesa user ID, and then click Connect.
   2. Click New Query.
   3. Type the following command:

      select FULLTEXTSERVICEPROPERTY ( 'IsFulltextInstalled' )

      If you did not install Full-text Search (the resulting value is zero), you must do so at this time. To install Full-text Search, insert theMicrosoft SQL Server 2008 product media into the system and start the installation wizard. Navigate through the wizard and enable the Full-Text Search option located 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. Open SQL Server Management Studio (Start > Programs > Microsoft SQL Server 2008 > SQL Server Management Studio)
   2. Right-click the Databases folder from the navigation tree , and select New Database.
   3. In the Database name entry field, specify a unique database name (for example maxdb75)
   4. For the maxdb75 Logical Name, change the Initial Size (MB) attribute to 500 (MB), and also set the value of the Autogrowth field to By 1MB, unrestricted growth.
   5. If you prefer, modify the log settings to accommodate your production environment.
   6. Click OK.
4. Create the Maximo User for Microsoft SQL Server.
   1. Open Microsoft SQL Server Management Studio (Start > Programs > Microsoft SQL Server 2008 > SQL Server Management Studio)
   2. Click New Query.
   3. Select the Maximo Asset Management database (maxdb75) from the Available Databases menu,
   4. Enter the following script to create the Maximo database user MAXIMO with a password of MAXIMO.

      sp_addlogin MAXIMO,MAXIMO
      go

      This value is case-sensitive.
   5. Click Execute.
   6. Enter the following script to change the database owner to maximo.

      sp_changedbowner MAXIMO
      go

   7. Click Execute.

What to do next

If you add additional logical names to the database and set their file group to a value other than PRIMARY, you must complete the following steps after you set up the database and create the Maximo user:

1. Run the Maximo Asset Management installation program and choose the Do not run the configuration step now option.
2. Add the following property to the install_home\etc\install.properties file:

   Database.SQL.DataFilegroupName=<your logical name>

3. Run the configuration steps outside of the Maximo Asset Management installation program by using the taskrunner utility, located in theinstall_home\scripts directory.

Complete these additional steps only if you added additional logical names to the database and set their file group to a value other than PRIMARY.