Roles required for SQL user
The recommended login account for creating the database requires SQL authentication and it should have the following roles enabled:
* dbcreator
* Public
* Sysadmin
If you do not want to provide Sysadmin role to the user, db_creator and Public roles are enough. db_creator is required because we may need to create new tables during the upgrade.
New to ADSelfService Plus?
Related Articles
SQL Backup permission post 10.6 Upgrade.
Error on the logs: [20:00:50:193]|[04-25-2022]|[com.adventnet.taskengine.backup.DbBackupTask]|[INFO]|[124]: BackupStatus updated in DB :: <BackupStatus backup_id=1806 backupType="FULL_BACKUP" ...Remote read only access to database for Postgres customers
Use case: Frequently customers want to connect some reporting / dashboard application like PowerBI or Tableau with our Postgres database server. By default, the bundled Postgres is configured to only listen to the local machine. We can configure to ...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 ...Unknown user and technicians permission
The requests that are not having a Site set means (Not associated to any site),, those requests are raised by Unknown users or Unregistered users or these users are NOT created in the application. These requests will be viewed only by certain ...Unable to start the application due to Pgsql privilege issue
ISSUE: Application does not start via both services and command prompt. ERROR TRACE: Serverout: [16:26:36:443]|[05-10-2023]|[com.adventnet.db.adapter.postgres.PostgresDBAdapter]|[SEVERE]|[27]: Exception occurred while obtaining mode of the database| ...