SQL Backup permission post 10.6 Upgrade.

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 ...
                      • 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 ...
                      • ServiceDeskPlus MSP Upgrade Instructions

                        Kindly follow the below instructions for the upgrade. 1. We highly recommend you do the upgrade in a test environment first. 2. Below is the upgrade path, kindly proceed with the upgrade based on your current version: 10500 >> 10538 >> 10600 >> 10611 ...
                      • 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 ...