Veeam – Error when launching the console – SQL server is not available 2


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:

DatabaseUnavailable

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!

Print Friendly, PDF & Email

Related Post

It's only fair to share...Tweet about this on TwitterShare on LinkedInEmail this to someone

Leave a comment

Your email address will not be published. Required fields are marked *

2 thoughts on “Veeam – Error when launching the console – SQL server is not available

  • merlijn

    Thank you. This was the problem i was having. I didn’t know there was a back-up account. I logged in with the domain administrator and it didn’t work. So after reading this I checked the AD and found there was a back-up administrator as well.

    After logging in with the back-up administrator everything went good!

  • Andrea

    Hi, i have a enviroment Server 2008 (physical machine), in my physical machine, i have heper-v manager, here there are 5 virtual machines, i have installed veeam rel. 8 on my physical machine, in this machine i haven’t SQL Server, but veeam installed the services of SQL Server 2012, i started the backup for a virual-machine, it arrives near the end, when suddenly i get the message you reported, i have controlled the user, it result Administrator Local, it is the same of Veeam. How can i resolve this problem, the my physical machine is not in domain controller, is a simple physical machine “server 2008”

    Thanks