Database Configurations

 

SupportCenter Plus supports MY SQL database, by default. To switch over to SQL database you need to configure SQL server to establish connection and start the server.

 

Configuring MS SQL Server

  1. Go to <SupportCenter>\bin directory from the command prompt. Execute the changeDBServer.bat [changeDBServer.sh  for Linux] file.

  2. This opens the Database Setup Wizard page. Fill in the following details to configure sql server.

  1. Check the availability of connection by clicking the Test button. A pop up window showing 'Connection Established' message appears.

  2. Click OK to proceed.

  3. Click Save button to save the SQL server settings.

 

Configuring MY SQL Server

If you are using a remote MY SQL server and do not wish to use the in-built server then,

  1. Select Server Type as MY SQL server. This opens the database wizard page.

  2. Specify the Host Name, Port, User Name & Password.

  3. Click Test button and check the availability of the connection.

  4. Once the connection is established, Save the details and start the server.  

 

Non UI users
 

Run the changeDBServer.bat under command prompt by passing parameter like given below

>changeDBServer.bat --console


It will get the DB Server necessary information from the console.

 

 

Troubleshooting Tips

 

MY SQL Connection Resolution

Verify the following,

  MS SQL Connection Resolution

If a connection is refused and an exception is thrown by SQL Server as 'Unable to connect the server' then the reason for this could be,

SupportCenterPlus - Customer Support Management Software

Copyright © 2011, ZOHO Corp. All Rights Reserved.
ManageEngine