Check the amount of RAM allocated to the SQL Server.

For a single-server topology, no more than 2 GB of the system RAM should be allocated to Microsoft SQL.

Connect to the Server

Login to SQL is managed via the Microsoft SQL Server Management Studio.

A login screen is displayed that allows you so specify the Tealeaf server name and click Connect.

If after you click Connect, you are not connected to the database, contact the database administrator. The database administrator can provide you with the information needed to authenticate with the database.

Configure SQL Server Consumption

The following instructions are a guideline. Consult your Microsoft SQL Server documentation or articles from the MSDN for specific instructions.

1. From the SQL Server Management Studio, right-click on the top most entry and select Properties.

   Confirmation that the instance of SQL Server isn’t set up to consume more than 50% of the server’s RAM is required.

   Note: If you do not configure the server consumption rate, SQL Server consumes all of the allocated server memory.
2. Modify the Maximum Server Memory to be half of the System RAM available to the system per the available System Memory.
3. Click OK
   Note: This does not automatically change the memory allocations. These must be applied by executing the script. To have the script appear, select the script icon in the upper left corner. This script is shown once you click OK.
4. Click Execute.

   The messages generated by running the SQL Script indicate that the changes have been applied to the database are displayed.

The following instructions are a guideline. Consult your Microsoft SQL Server documentation or articles from the MSDN for specific instructions.

1. From the SQL Server Management Studio, right-click on the top most entry and select Properties.
2. In the navigation pane, click Security.

   The security configuration information for the server is displayed in the viewing area.

3. Make sure the radio button for SQL Server And Windows Authentication Mode is selected.
   Note: If any other parameter is set, contact the database administrator to confirm that modifying the authentication mode is allowed.
4. Close the SQL Server Management Studio.

The following instructions are a guideline. Consult your Microsoft SQL Server documentation or articles from the MSDN for specific instructions.

• Open the SQL Server Configuration Manager from the start menu.
• Expand the SQL Server Network Configuration tab.
• Make sure that TCP/IP is enabled.
• Highlight Protocols.
• For MSSQLSERVER and ensure that TCP/IP is Enabled. If TCP/IP is not enabled, right-click on TCP/IP and change the setting to Enabled.

Ensure that the TCP DYNAMIC PORTS is not enabled.

If the database has been configured with dynamic ports, contact is needed with the local database administrator to have them disabled.