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
New to ADSelfService Plus?
Related Articles
How to Connect to SDP MSP Database ?
1. In-Built POSTGRES (PGSQL) : Open a CMD prompt as an administrator and navigate to ManageEngine\ServiceDeskPlus-MSP\pgsql\bin and run the below command From SDP MSP build 10538 , please use the below method. psql -h localhost -U sdpadmin -p 65432 ...How to connect to external postgres(external DB)
1. From the postgres installed path navigate to bin folder and open a command prompt 2. Execute the command --> pg_ctl -D "C:\Program Files\PostgreSQL\10\data" start (Postgres server gets started) 3. Connect to DB using the command-->psql -U postgres ...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 ...The transaction log (Servicedesk_log.ldf) for database 'servicedesk' is full
There are two methods to fix this issue. Method 1 To fix this issue, we have to detach ServiceDesk database, after detaching we can delete the transaction log ( .LDF log) and attach the ServiceDesk database back. The important part in this process of ...