Manually configuring Microsoft SQL Server 2012

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

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 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 Programs > Microsoft SQL Server 2012 > 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 2012. To determine if 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.
   3. Type the following command and then click Execute.:

      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 2012 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. Open SQL Server Management Studio (Start > Programs > Microsoft SQL Server 2012 > 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, enter maxdb76
   4. For the maxdb76 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.
   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 2012 > SQL Server Management Studio)
   2. From the SQL Server Configuration Manager navigation pane, click Databases.
   3. Right-click the maxdb76 database and select New Query.
   4. Enter the following script 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. Click Execute.
   6. Enter the following script to change the database owner to maximo.

      sp_changedbowner MAXIMO
      go

   7. Click Execute.