Other configuration

i2 TextChart provides a few ways to modify its behavior so that it works better in your environment. For example, you can adjust the amount of memory available to the extraction process, and change the way TextChart authenticates with the database.

Memory configuration

You can change the size of the JVM heap by editing the configuration file at C:\Program Files\TextChart\RosokaServiceCore.l4j.ini.

To adjust memory allocation, which defaults to 4 GB, change:

-Xms4g
-Xmx4g

to:

-Xms<GB_OF_RAM_TO_ALLOCATE>g
-Xmx<GB_OF_RAM_TO_ALLOCATE>g

For example, to set it to 8 GB, the two lines would be:

-Xms8g
-Xmx8g

Database configuration (SQL Server Express 2014+)

Setting mixed authentication

  1. Open SQL Server Management Studio Express.

  2. Choose Windows Authentication from the Authentication drop-down list.

  3. Click Connect to open the Microsoft SQL Server Management Studio Express window.

  4. Right-click the SQL instance and choose Properties to open the Server Properties window.

  5. Click Security on the left side.

  6. Choose SQL Server and Windows Authentication Mode on the right side.

  7. Click OK to close the Server Properties window.

  8. Right-click the SQL instance and choose Restart.

  9. Click Yes to restart the SQL server.

Enabling the 'sa' user

  1. Open SQL Server Management Studio.

  2. Choose Windows Authentication from the Authentication drop-down list.

  3. Click Connect to open the Microsoft SQL Server Management Studio window.

  4. Expand Security and then expand Logins.

  5. Right-click sa, and click Properties.

  6. Click Status, and then select Login Enabled.

    Note: You might need to set a password for this account as well.

  7. Right-click to refresh.

Changing TCP and port settings

  1. From the Start menu, right-click My Computer, and then choose Manage.

  2. In Computer Management, expand Services and Applications > SQL Server Configuration Manager > Server Network Configuration > Protocols for InstanceName, and then select the protocol that you want to configure.

  3. Select the instance for your installation. By default, this is Protocols for SQLEXPRESS.

  4. Change the Named Pipes protocol option to Enabled. You do not need to change the default Pipe Name setting.

  5. Click OK.

  6. Change the TCP/IP protocol option to Enabled.

  7. Under TCP/IP Properties, select the IP Addresses tab and scroll down to IPAll.

  8. Set TCP Port to 1433, and remove any value from Dynamic Port.

  9. Click Apply. You will be prompted to restart SQL Server.

  10. Restart the server for the changes to take effect.