Monitoring and reporting for Veeam Backup & Replication, VMware vSphere and Microsoft Hyper-V
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 » Dec 11, 2019 5:13 pm

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
Product Manager
Posts: 7209
Liked: 747 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 » Dec 11, 2019 6:00 pm

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 » Dec 12, 2019 3:55 pm

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

thanks

Shestakov
Product Manager
Posts: 7209
Liked: 747 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 » Dec 12, 2019 3:59 pm

You can contact Veeam support even with community(free) product edition.

Vitaliy S.
Product Manager
Posts: 23403
Liked: 1663 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. » Dec 12, 2019 4:08 pm

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 » Dec 12, 2019 4:09 pm

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

thanks
augie

Vitaliy S.
Product Manager
Posts: 23403
Liked: 1663 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. » Dec 13, 2019 10:57 am

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.

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests