Windows 10 Update disabled Veeam B&R V9 U1

VMware specific discussions

Windows 10 Update disabled Veeam B&R V9 U1

Veeam Logoby russ_2012 » Tue Aug 16, 2016 3:58 pm 1 person likes this post

This issue is partially resolved with a workaround, uninstalling the affecting Windows update

tl;dr Windows 10 Update KB3172729-Security Update broke Veeam. Uninstalling update fixed Veeam. Did I do this right? Is there a better method or workaround. Or even a running Veeam guide on Windows 10

System:
Windows 10 1511 (November Release), its a Dell desktop
Veeam B&R Version 9 U1 (I know U2 was just released, its scheduled for install after this server's monthly backup at the end of the month)
Veeam backs up a ESXi 5.1 host to a Synology NAS.


The backup job is set to perform on weekdays, last successful backup was Friday as normal. I installed the Windows updates on Sunday, at that time I could access Veeam.
On Tuesday it was noticed that Monday's backup was not performed. Looking into Veeam it could seen that the job was not even attempted nor were there any errors. A reboot of the server was performed.

To start Veeam, the service named "SQL Server Agent (VEEAMSQL2008R2)" has to be started then this service automatically starts the service "SQL Server (VEEAMSQL2008R2)". Normally there are no issues but this
time when I started the Agent service it would start the SQL Server but after I refreshed the Services page the service SQL Server Agent would be not running nor could I access the Veeam interface.
I figured that it was most likely one of the Windows updates installed on Sunday.
KB3176493-Cumulative Update
KB3172729-Security Update for Windows 10 1511
KB890830-Monthly Windows Malicious Tool Removal
KB3174060-Security Update for Adobe Flash Player
I proceeded to uninstall the updates one by one moving down the list, rebooting after each uninstall. Uninstalling the first one, KB3176493, did not resolve the issue.
Uninstalling KB3172729 did resolve the issue. I was then able to start SQL Server Agent and have it stay running. I then accessed Veeam and retried the backup and it worked, or more literly its currently running.

Did I do this right? Is there a official workaround or semi official workaround to allow me to install the affecting update?
Or even a guide to running Veeam on Windows 10? I read on Microsoft that SQL 2008 R2 is not supported on Windows 10 but this computer is the only thing available we have right now.

Appreciate the help
russ_2012
Lurker
 
Posts: 2
Liked: 1 time
Joined: Fri Jul 29, 2016 5:33 pm

Re: Windows 10 Update disabled Veeam B&R V9 U1

Veeam Logoby Gostev » Tue Aug 16, 2016 8:12 pm

Are you using SQL Express?
Gostev
Veeam Software
 
Posts: 21390
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Windows 10 Update disabled Veeam B&R V9 U1

Veeam Logoby ccatlett1984 » Wed Aug 17, 2016 7:31 pm

if your using express, you should upgrade to sql express 2012 at least I'd go to sql 2014, also be sure to install both the latest service pack and cumulative update.
ccatlett1984
Enthusiast
 
Posts: 83
Liked: 9 times
Joined: Thu Oct 31, 2013 5:11 pm
Full Name: Chris Catlett

Re: Windows 10 Update disabled Veeam B&R V9 U1

Veeam Logoby russ_2012 » Thu Aug 25, 2016 9:04 pm

Sorry for the delay.

No we are not using express. We are using the sql that comes with Veeam, sql 2008 r2.
russ_2012
Lurker
 
Posts: 2
Liked: 1 time
Joined: Fri Jul 29, 2016 5:33 pm

Re: Windows 10 Update disabled Veeam B&R V9 U1

Veeam Logoby Pat490 » Fri Aug 26, 2016 8:27 am 1 person likes this post

as far as i know... what comes with Veeam... is SQL Express!
Pat490
Expert
 
Posts: 135
Liked: 24 times
Joined: Tue Apr 28, 2015 7:18 am
Location: Germany
Full Name: Patrick

Re: Windows 10 Update disabled Veeam B&R V9 U1

Veeam Logoby v.Eremin » Fri Aug 26, 2016 9:51 am

And MS doesn't support running SQL 2008 R2 on Windows 10 OS, so, can you update your SQL installation and see whether it fixes the issue? Thanks.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Windows 10 Update disabled Veeam B&R V9 U1

Veeam Logoby pbarrette » Mon Aug 29, 2016 4:15 pm 1 person likes this post

Also note that you have your service dependencies backwards:
The "SQL Server Agent" service is dependent upon the "SQL Server" service.

Which means that SQL Agent will not run unless SQL Server is running first. This is because the SQL Agent service relies on the [MSDB] database, which isn't available unless the SQL Server is running.

Also note that you're using SQL Server Express. This means that the "SQL Server Agent" service should be disabled, since a (free) SQL Express license doesn't support using the "SQL Agent" service. So, with the SQL Express that comes with Veeam, you will never be able to make the "SQL Server Agent (VEEAMSQL2008R2)" service run.

In short, there's no problem. The "SQL Server Agent (VEEAMSQL2008R2)" service will not ever run and that's by design.
pbarrette
Novice
 
Posts: 4
Liked: 6 times
Joined: Wed Dec 23, 2015 7:02 pm
Full Name: Peter Barrette


Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 6 guests