Monitoring and reporting for Veeam Data Platform
Post Reply
TheFlash
Novice
Posts: 3
Liked: never
Joined: Dec 11, 2019 5:07 pm
Contact:

veeam one help failed to connect to SQL server

Post by TheFlash »

Hi
we recently moved off SQL express and on to a SQL server
we reinstalled and veeam created the DB but we are getting the following error
can someone point me in to the right direction on what permissions are needed
error "Failed to connect to SQL server. web identity user does not have rights to connect"

all i can find is this and our DBA says he granted these permissions
Public role (default permissions)
CREATE ANY DATABASE permissions
db_owner role on the Veeam ONE database
db_datareader permissions on the master database
public, db_datareader, SQLAgentUserRole permissions on the msdb database
[For Always-On Availability Groups] VIEW SERVER STATE permissions

thanks
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: veeam one help failed to connect to SQL server

Post by Shestakov »

Hi and welcome to the community.
Please provide a support case number as required by forum's rules when posting about technical error.
By the way, have you checked database connection settings? You can also test if Veeam ONE Server can connect to the database with the provided setting and permissions there.
Thanks
TheFlash
Novice
Posts: 3
Liked: never
Joined: Dec 11, 2019 5:07 pm
Contact:

Re: veeam one help failed to connect to SQL server

Post by TheFlash »

Hi
i dont have a case # i am using the free version
we might purchase thats why we are testing it

thanks
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: veeam one help failed to connect to SQL server

Post by Shestakov »

You can contact Veeam support even with community(free) product edition.
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: veeam one help failed to connect to SQL server

Post by Vitaliy S. »

Check out the web identity tab in the support tool Nikita has referenced above. Should help, here is the KB to help: https://www.veeam.com/kb1599
TheFlash
Novice
Posts: 3
Liked: never
Joined: Dec 11, 2019 5:07 pm
Contact:

Re: veeam one help failed to connect to SQL server

Post by TheFlash »

yes i hit that tab and changed the user restarted and rebooted but still get the same error

thanks
augie
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: veeam one help failed to connect to SQL server

Post by Vitaliy S. »

The procedure does work, verify that you've followed all the steps once again and then contact our support team. They might be able to help you if their current load allows that.
phiaramos
Enthusiast
Posts: 34
Liked: never
Joined: Nov 14, 2019 2:02 am
Full Name: Phia Ramos
Contact:

Re: veeam one help failed to connect to SQL server

Post by phiaramos »

Hi, I'm experiencing the same error on our deployment of Veeam ONE. This is the 1st time to install Veeam ONE but on different server as the VBR. I'm trying to connect the SQL server instance of VBR to Veeam ONE, and keeps getting error of Failed to connect to SQL server "..."
I also noticed that Veeam ONE and VBR server have same Windows computer name but different IP add, seems that the client cloned this 2 VMs, is it related to the issue? What are your inputs? Thank you!
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: veeam one help failed to connect to SQL server

Post by Vitaliy S. »

Hi Phia,

Cloning could be the issue, however, have you tried using SQL Management Studio just to connect to this instance from the remote machine?

Thanks!
phiaramos
Enthusiast
Posts: 34
Liked: never
Joined: Nov 14, 2019 2:02 am
Full Name: Phia Ramos
Contact:

[MERGED] Veeam ONE failed to connect to SQL Server "..".

Post by phiaramos »

Hi, we are trying to install Veeam ONE, this is a separate VM to VBR server. Unfortunately on the SQL setup part, when I'm trying to connect to the existing instance used on VBR, it always fails. May I ask for your inputs regarding with this matter. Also, it seems that Veeam ONE is a cloned VM of VBR, it has the same computer name but different IP address, does it affect the experienced issue? Thank you!
Mildur
Product Manager
Posts: 8549
Liked: 2223 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: Veeam ONE failed to connect to SQL Server "..".

Post by Mildur » 1 person likes this post

Hi Phia

Please make sure to use unique hostnames for each machine. You cannot use the same hostname for a second machine.

Cloning the vbr server is not really a good choice. You don‘t need a cloned vbr server for running veeam One on the machine. And cloning a vbr server leads to issues with the installationid for some licenses.

I recommend to install a new windows vm with a unique hostname.

If that not works, please open a support case with veeam, that‘s a requirement (Forum Rule Nr. 1) here in the R&D forums before posting a technical issue.
Thanks
Product Management Analyst @ Veeam Software
Post Reply

Who is online

Users browsing this forum: No registered users and 10 guests