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" backup_folder="D:\ManageEngine\ServiceDeskPlus-MSP\backup\backup_mssql_10600_database_04_25_2022_20_00" backup_zipname="FullBackup_20220425200000_mssql_10600_ScheduledBackup_part_1.ezip" backup_starttime="2022-04-25 20:00:00.819" backup_endtime="1970-01-01 03:59:59.999" backup_status="BACKUP_PROCESS_FAILED" dataFileCount="0" lastDataFileName="null" lastDataFileModifiedTime="-1" fileNames="null"/>|
[20:00:50:193]|[04-25-2022]|[SYSERR]|[INFO]|[124]: com.adventnet.db.adapter.BackupRestoreException: B0BP09: Problem while executing command.|
[20:00:50:193]|[04-25-2022]|[SYSERR]|[INFO]|[124]: Caused by: java.sql.SQLException: CREATE DATABASE permission denied in database 'master'.|
Root Cause :
1) Looks like the account used in ServiceDesk plus to connect to SQL DB does not have the CREATE DATABASE permission.
2) Please make sure the account used in SQL DB has
a) DBcreator
b) Sysadmin
c) Public
roles given.
Once the roles are updated you can try the backup
3) In case you want to know the account name on the ServiceDesk plus server open the command prompt as admin and navigate
Drive/ManageEngine/ServiceDesk/bin > ChangeDBserver.bat
Here you will notice the account used so that you can check the roles and permissions and update accordingly.
This permission alert will be shown when the upgrade is perfomed to 10.6.
New to ADSelfService Plus?
Related Articles
Scheduled Backup failure due to permission issue in pgsql folder
Error Traces: [com.adventnet.db.adapter.BackupRestoreUtil]|[WARNING]|[250]: pg_basebackup: could not get write-ahead log end position from server: ERROR: could not open file "./pg_hba.conf_3may23.bkp": Permission denied| ...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 ...Alternative for Full Backup - Trimmed backup
Applicable till 8.1 version (Till 8121 builds) Nowadays the database size is huge in various users instance. It is because the indexing related files, archived files, file attachments are folder are huge in size. Due to which either our application ...10.5 Linux Upgrade failure and solutions
Traces in logs : 1. java.lang.Exception: InitPgsqlScript exited with value :: 1 at com.adventnet.persistence.PostgresPreProcessor.executeInitPgsqlScript(PostgresPreProcessor.java:1733) 2. PGSQL Permission related errors. 3. SDP MSP installed as root ...Upgrade Failed -> Reverting steps
This article covers 2 areas : a) Analysis stage b) Reversion steps (rollback) a) Analysis stage Please send the below files to our support for analysis: 1. Zip the complete log folder present under <servicedesk plus msp home>/server/default or from ...