mO SharemO Share

How To: Check if the web SQL Server database is accessible

It is very necessary to check the accessibility of Web DB  for data exchange to work. This article describes how to check if the Web SQL Server database is accessible.

Step-by-step guide

  1. Click on the Retail Management tab in the GINESYS Web tile of the GINESYS Launchpad. 

  2. In the Utilities tab, go to Configure > Web Database. 

  3. In the List of Web Database, select any web database configuration. 

    IMPORTANT

    Note: Only Web databases with a future activation date can be edited.

  4. Check that the following fields have appropriate values: 

    1. Date – Date at which the web database will be activated 

    2. Host - should have the name of the SQL Server 

    3. Port - should fill up automatically 

    4. Username - should have username 

    5. Password - should have the password set for the particular user 

    6. Database - should have the name of the database you wish to connect to. 
       

  5. Click on Test Connection. 

     
     

  6. A message will show :

    1. Test connection successful if the web database is accessible. 

    2. Test connection failed if the web database is not accessible.

        

 

Â