Veeam Backup 6 and 6.5 Cannot complete login due to an incorrect user name or password

After a clean install of Veeam 6.5 and connecting to a vCenter server, the backups repeatedly failed and I kept getting the following error:

“Cannot complete login due to an incorrect user name or password”

If you do a bit of googling as I did, you may believe this to be due to a duplicate entry on the dbo.Hosts table in the Veeam DB (not so in my case).  If this is the case, the following solution seems to have worked for a lot of people.

1. Backup your Veeam DB

2. Open SQL Server Management Studio (I did this from a different server that already had it installed)

3.Connect to the SQL Express instance, in my case: SERVERNAME\VEEAMSQL2008R2

4. Expand Databases, VeeamBackup, Tables and locate the dbo.Hosts table

5. Right click and choose ‘edit top 200 rows’

6. Search out any duplicates (in my case there was one entry for each ESX host, one for the vCenter server and one for ‘This Server’ so no duplicates)

7. You may see a duplicate entry that relates to a previous version of VMware, if so right click the row and delete it.

8. Restart the Veeam Backup Services.

Read on for the solution that worked for me!

The organisation I did the install for requires the use of a seperate AD account for services, with their own secure passwords.  This is normally some kind of headroll that has a mix of uppercase, lowercase, numbers and special characters.  In this case, I changed the password to remove the special characters, changed the password for the service accounts, and deleted the backup jobs and the vCenter Server connection and recreated them with the correct passwords (I had no backup history to worry about) and hey presto – the backups now work! :)

About these ads

4 Responses to Veeam Backup 6 and 6.5 Cannot complete login due to an incorrect user name or password

  1. […] 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 […]

  2. This web site really has all of the information I wanted about this subject and
    didn’t know who to ask.

  3. Lula says:

    thank you, this solved my problem!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: