Previously working job now failing

Application issues
1

I’ve been using SQLBackupAndFTP successfully for months to create a daily backup of a single database on a shared web host.

In the last few weeks, my daily job is failing, with the message:

VIEW SERVER STATE permission was denied on object 'server', database 'master'.
The user does not have permission to perform this action.

My webhost swears up and down that they have never given this permission to users on a shared web host and that they haven’t changed anything on their end.

I’m currently on version of 12.7.35 of SQLBackupAndFTP. Did the standard behavior of a SQLServer backup job change recently to use this permission?

2

Hello Shecky,

Thank you for your message.

The issue is caused by missing permissions. Please grant the user VIEW SERVER STATE (or higher). Without these rights, the backup cannot run successfully.

This requirement may appear after the update because the scripting logic was revised.

3

Rolling back to the previous version (12.7.30) worked!
Is it safe to say that all future versions will need the permission to VIEW SERVER STATE?

4

Hello Shecky,

Yes, starting from the recent versions this permission will be required.

We’ve updated the scripting procedure — more objects are now included in the backup, and the app uses more features from Microsoft libraries.

Because of this, additional security permissions are needed in order to check the server state.

5

Hi Oleg,

I have hit the same issue as Shecky. In my case the server is shared hosting so I can’t grant the user VIEW SERVER STATE.

Is there any way around this by changing any settings in SQLBackupAndFTP?

Alternatively where can I download version 12.7.30?

SQLBackupAndFTP is great but I’m worried this recent update will make the software useless for my scenario :frowning:

6

Hi Jo,

Thank you for your message!

Please contact our support via SQL Server Backup Support - SQLBackupAndFTP