upgrade 9.5 SQL connection problem

Monitoring and reporting for Veeam Backup & Replication, VMware vSphere and Microsoft Hyper-V

upgrade 9.5 SQL connection problem

Veeam Logoby allankjaer » Tue Nov 29, 2016 9:05 pm

I was upgrading Veeam ONE from 9.0 update 1 to 9.5, and encountered a problem that the upgrade wizard could not connect to the SQL server (using the default SQL Express 2012 SP3.)

After some troubleshooting I found that I had disabled SSLv3 and TLS 1.0 on the server.

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Server]
"Enabled"=dword:00000000

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 3.0\Server]
"Enabled"=dword:00000000

I change the 2 values to: dword:00000001

Rebooted and upgraded without problem, not sure if it needs SSLv3 or TLS 1.0.
allankjaer
Influencer
 
Posts: 10
Liked: never
Joined: Wed Apr 09, 2014 9:11 am
Full Name: Allan Kjaer

Re: upgrade 9.5 SQL connection problem

Veeam Logoby Shestakov » Tue Nov 29, 2016 10:12 pm

Hello Allan,
We will try to reproduce and confirm the issue.
Thank you for sharing the information with us!
Shestakov
Veeam Software
 
Posts: 4863
Liked: 396 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: upgrade 9.5 SQL connection problem

Veeam Logoby Shestakov » Wed Nov 30, 2016 5:31 pm

Allan, could you contact Veeam support to provide logs for investigation?
Thanks
Shestakov
Veeam Software
 
Posts: 4863
Liked: 396 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: upgrade 9.5 SQL connection problem

Veeam Logoby allankjaer » Wed Nov 30, 2016 6:20 pm

Sorry. This was in a test environment, that is deleted now.

I only checked/edited the settings in the production environment, before upgrading. without problems.
allankjaer
Influencer
 
Posts: 10
Liked: never
Joined: Wed Apr 09, 2014 9:11 am
Full Name: Allan Kjaer

Re: upgrade 9.5 SQL connection problem

Veeam Logoby Vitaliy S. » Wed Nov 30, 2016 8:29 pm 1 person likes this post

This change should not be required. For future readers > if you face the same issue, please let our support team review the logs.
Vitaliy S.
Veeam Software
 
Posts: 19570
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: upgrade 9.5 SQL connection problem

Veeam Logoby zander » Mon Dec 12, 2016 9:48 am

Veeam ONE service account requiremens were changed in v9.5:
https://helpcenter.veeam.com/docs/one/d ... tml?ver=95
or the easiest way is to provide sysadmin role on SQL server for ONE service account during upgrade.
zander
Veeam Software
 
Posts: 2
Liked: 1 time
Joined: Mon Apr 06, 2015 2:21 pm
Full Name: Alexander Shmatov


Return to Veeam ONE



Who is online

Users browsing this forum: No registered users and 7 guests