This is a really short post about a problem which is actually not a problem. Today I’ve worked at a customer site where the Veeam Backup & Replication (v7.0) database was located on a remote SQL server.
When I was logged in as local Administrator, I always was prompted with the following error message when launching the console:
The next step was to check the Veeam registry values which seemed to be fine:
HKEY_LOCAL_MACHINE\SOFTWARE\VeeaM\Veeam Backup and Replication\SqlDatabaseName
HKEY_LOCAL_MACHINE\SOFTWARE\VeeaM\Veeam Backup and Replication\SqlInstanceName
HKEY_LOCAL_MACHINE\SOFTWARE\VeeaM\Veeam Backup and Replication\SqlServerName
Then I saw that the user configured to start the Veeam services was a Active Directory service account which actually had proper privileges on the remote DB. After checking the application event log on the SQL server I realized that every time I’ve tried to launch the console, the local Administrator of the backup server attempted to log in which of course got denied.
After logging in (on the backup server) with the service account the console started as usual. So it seems that the console opens a SQL connection to retrieve all the configuration information and since this happens within the corresponding context of the logged in user, the account requires proper privileges on the Veeam DB.
I hope this helps you to save some time!