SureBackup - SQL ver

[williamlaw]

Hi All,

I have created a SureBackup job to verify SQL server, but encountered failure for SQL verification with below error.

Info [SC] OpenSCManager FAILED 5:Access is denied.

How can I solve it ?

Thanks

[Vitaliy S.]

Usually, this issue is shown when your account does not have enough privileges to perform the operation. What verification steps have you enabled and what account are you using?

[Egor Yakovlev]

Hi William.
Veeam connects to SQL Database using Veeam service account(by default it is SYSTEM) and I am 99% positive that Veeam Server SYSTEM account is not on the list of SQL DB Users right now.
- it is best to use special service account for Veeam services
- make sure said service account has "Public" role and mapping to DB access. That should do the trick and solve your error.
- as a last resort, you can also use custom SQL.Checker script with attributes - edit Application Group - SQL - Scripts - Edit - > pick one from "C:\Program Files\Veeam\Backup and Replication\Backup\Veeam.Backup.SqlChecker.vbs %log_path% %vm_ip%\INSTANCENAME sql_user sql_password". However note that SQL-checker user password will be in plain text here.
/Hope that helps!

[williamlaw]

Usually, this issue is shown when your account does not have enough privileges to perform the operation. What verification steps have you enabled and what account are you using?

I am trying to verify SQL server and domain administrator has been used

[Vitaliy S.]

Try using a local admin on that machine instead, as based on the thread referenced above there could be issues with UAC.

[williamlaw]

I have tried to use local admin but still failure

[Egor Yakovlev]

- make sure permissions are set correctly on production SQL server
- make sure to back it up at least once after permissions change, because in the backup you might still have same un-configured SQL that will reject any account you feed into Application Group
/Cheers!

[williamlaw]

Hi Egor,

As checked, doamin admin & local admin already added to production SQL server before this encountered this issue.

[williamlaw]

Error code changed to "2" — Veeam Backup & Replication is unable to connect to Microsoft SQL Server

[Vitaliy S.]

Hi William, if you've checked everything and still have a permission issue, then please contact our support team so that they could quickly nail down the issue.