Database Configuration

 

By default AssetExplorer supports PgSQL database. To switch over to MS SQL/SQL database you need to configure the respective server. To establish connection and start the server.

 

 

Configuring PgSQL Server

  1. Execute the changeDBServer.bat [ changeDBServer.sh  for Linux] file presented under the ServiceDesk Home. This opens the Database Setup Wizard page. Fill in the details of the form to configure PgSQL server.

  2. To check the availability of connection press the Test button. A pop up window pops up showing 'Connection Established' message.

  3. Click OK to proceed.

  4. Click Save button to save the PgSQL server settings.

 

Configuring MYSQL Server

  1. If you are using a remote MySql server and do not want to use the inbuilt server then,

  2. Select Server Type as MySql server. This opens the database wizard page.

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

  4. Once the Connection is Established, Save the details and start the server.  

 

 

Configuring SQL Server

  1. Execute the changeDBServer.bat [ changeDBServer.sh  for Linux] file presented under the ServiceDesk Home. This opens the Database Setup Wizard page. Fill in the details of the form to configure sql server.

  2. To check the availability of connection press the Test button. A pop up window pops up showing 'Connection Established' message.

  3. Click OK to proceed.

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

 

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 there could be following reasons why this could happen such as,

 

AssetExplorer - Asset Management Software

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