Veeam v6.5 (database issue)

Today I came across a problem with Veeam v6.5. I had recently upgraded it from either v6.0 or v6.1 and since the upgrade all of the jobs had failed with the error message “cannot complete login due to an incorrect username or password”.

image

I knew that the username and password hadn’t changed recently but just to be certain I re-entered them into Veeam and removed and re-added the VM to the backup job but both of these efforts proved fruitless. After a quick Google I discovered that this was a common problem when upgrading to v6.5, for some reason the SQL database that Veeam uses get duplicated in the hosts.db table. I found this website and followed the numbered points, and with a bit of trial and error managed to get Veeam working again. Here is what I did…

 

    1. Backup Veeam database.
    2. Stop Veeam services.
    3. In SQL Management Studio try to delete the duplicates that you think are causing the problem.

Screen shot of the original table…

image

  1. I originally deleted all rows apart from 3, 5, 8 & 10.
  2. Restarted SQL instance & started Veeam services.
  3. Then re-tried one of the backup jobs, but got this error…image
  4. So I stopped Veeam services, and restored database from the backup made in stage 1.
  5. Re-deleted the rows but this time kept the row with the fe66f766… host ID too…image
  6. Restarted SQL instance & started Veeam services .
  7. Then re-tried one of the backup jobs, but got this error…image
  8. So stopped Veeam services, and restored database from the backup made in stage 1.
  9. Re-deleted the rows but this time kept the row with the 831d14e8… host ID (and 545b0af0… because that looked very similar too).
  10. Restarted SQL instance & started Veeam services.
  11. Then re-tried one of the backup jobs, and it worked!!

image

Screen shot of hosts.db table afterwards…

image