How to connect to the AssetExplorer database?

How to connect to the AssetExplorer database?

To find the database connected to your installation, open Command Prompt with elevated permission, navigate to [AE-Home]\bin directory and invoke the batch file 'changeDBServer.bat'. [AE-Home] is Drive:\ManageEngine\AssetExplorer\ directory.




For MSSQL database









Connect to the query analyzer of the SQL server and execute the queries.















For PGSQL database 












Open command prompt on the application server and connect to the folder ManageEngine\AssetExplorer\pgsql\bin> and use the command
psql.exe -U postgres -p 65433 -d assetexplorer -h 127.0.0.1









For  MYSQL database












Open command prompt on the application server, connect to the folder ManageEngine\assetexplorer\mysql\bin> and use the command
mysql.exe -u root -P 33376 assetexplorer



      • Related Articles

      • How to connect to the ServiceDesk database?

        Open command prompt on the server and change the directory to MangeEngine\ServiceDesk\bin, invoke the batch file 'changeDBServer.bat' For MSSQL database  Connect to the query analyzer of the SQL server and execute the queries. For PostgreSQL database ...
      • How to change the database from MySQL/PostgreSQL to MSSQL

        The steps mentioned below are applicable only if you migrate the DB from PgSQL to MSSQL. This means that the application server is going to remain the same. The data alone is going to be transferred to MSSQL DB from the existing PgSQL DB.    For ...
      • Failed to start the database

        For the error "Failed to start the database", Check what database being used and, execute changeDBServer.bat. For Pgsql,  Start PGSQL from the command link, execute StartDB.bat 65432 under C:\Manageengine\ServiceDesk\bin 65432 is the default port ...
      • How to install SSL certificate in AssetExplorer

        SSL Installation Do you have a Wildcard or a Multi-domain certificate already running in your other servers and want to reinstall in on AssetExplorer server ?, then click here to find how to export SSL certificate using MMC.  Do you already have a ...
      • How to migrate ServiceDesk Plus / AssetExplorer to 64 bit installation from 32 bit installation

        The steps mentioned below requires you to be on the version 12 Build 12007 (For ServiceDesk Plus) or version 6.9 Build 6950 (For AssetExplorer) or above. If you are on any build lower than 12007/6950, then you will have to upgrade the application to ...