after v9 U2 install: Backup Service does not start

Availability for the Always-On Enterprise

after v9 U2 install: Backup Service does not start

Veeam Logoby hirratas » Mon Aug 08, 2016 8:51 am

Case 01873743

Hi
this morning I read Gostevs Mail and decided to install v9 Update 2.
After the installation the Backup Service fails to start (error 1053).

Anyone else experienced this issue?

My SQL Server and db is up and I can see in SQL Logs that the Logon user of the Backupservice logons successfully.

I restarted the B&R Server and the SQL Server without success.

Thanks

[EDIT] Click here for solution
hirratas
Influencer
 
Posts: 20
Liked: 1 time
Joined: Fri Feb 10, 2012 7:56 am

Re: after v9 U2 install: Backup Service does not start

Veeam Logoby kawiMTF » Mon Aug 08, 2016 8:57 am

Hi,

What says the eventlog of the server?

Did you check the user account used on the Backup Service? Usually its installed / started with [DOMAIN\administrator].

Did you use a another account, perhaps a service account? Did you try to change the user which starts this service?
Best regards,
Karl

-----------------------
Veeam Platinum Partner
Veeam Vanguard / VMCE v9 / VMTSP v9 / VMSP v9
vExpert / VCA6-DVC / VCA5-DVC / VCA5-Cloud
MCP / MCSA 2012
Personal blog: https://www.driftar.ch
Twitter: @widmerkarl
kawiMTF
Veeam Vanguard
 
Posts: 116
Liked: 20 times
Joined: Tue Jan 06, 2015 10:03 am
Location: Switzerland
Full Name: Karl Widmer

Re: after v9 U2 install: Backup Service does not start

Veeam Logoby hirratas » Mon Aug 08, 2016 9:01 am

application event log / event id 0:

Code: Select all
Der Dienst kann nicht gestartet werden. Veeam.Backup.DBCreator.DatabaseException: Failed to deploy database. Alter failed for Database 'Veeam'.
   bei Veeam.Backup.DBCreator.BackupDatabaseDeployer.Deploy()
   bei Veeam.Backup.DBManager.SqlRetryableInitializer.Init()
   bei Veeam.Backup.Service.CVbServiceImpl..ctor(CVbEnvironment env, CTerminationMediator terminator)
   bei Veeam.Backup.Service.CVeeamBackupSvc.OnStart(String[] args)
   bei System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)


Service account is the same (correct one) as prior the update. I also resaved it to make sure.
As I said the account successfully logs on to the SQL Server.
Sorry for the bad English.
hirratas
Influencer
 
Posts: 20
Liked: 1 time
Joined: Fri Feb 10, 2012 7:56 am

Re: after v9 U2 install: Backup Service does not start

Veeam Logoby kawiMTF » Mon Aug 08, 2016 9:10 am

No problems with the english, i'm also not a native english speaking person ;-)

I found a blog post which describes exactly your problem:
http://www.webbosworld.co.uk/?p=632#prettyPhoto

He is working with the PSTools from SysInternals and deleted the VeeamEndPoint instance.

Then he did a repair install of Veeam Backup & Replicaiton.
Best regards,
Karl

-----------------------
Veeam Platinum Partner
Veeam Vanguard / VMCE v9 / VMTSP v9 / VMSP v9
vExpert / VCA6-DVC / VCA5-DVC / VCA5-Cloud
MCP / MCSA 2012
Personal blog: https://www.driftar.ch
Twitter: @widmerkarl
kawiMTF
Veeam Vanguard
 
Posts: 116
Liked: 20 times
Joined: Tue Jan 06, 2015 10:03 am
Location: Switzerland
Full Name: Karl Widmer

Re: after v9 U2 install: Backup Service does not start

Veeam Logoby hirratas » Mon Aug 08, 2016 9:27 am

Thanks a lot.

I will wait for a reply from Veeam Support.
I do not want to do something wrong.
If Support does not come up with a solution I will try this.

Anyway I will update this thread with the outcome.
hirratas
Influencer
 
Posts: 20
Liked: 1 time
Joined: Fri Feb 10, 2012 7:56 am

Re: after v9 U2 install: Backup Service does not start

Veeam Logoby kawiMTF » Mon Aug 08, 2016 9:38 am

No problem, we are all trying to help.

Thanks for keeping us posted.
Best regards,
Karl

-----------------------
Veeam Platinum Partner
Veeam Vanguard / VMCE v9 / VMTSP v9 / VMSP v9
vExpert / VCA6-DVC / VCA5-DVC / VCA5-Cloud
MCP / MCSA 2012
Personal blog: https://www.driftar.ch
Twitter: @widmerkarl
kawiMTF
Veeam Vanguard
 
Posts: 116
Liked: 20 times
Joined: Tue Jan 06, 2015 10:03 am
Location: Switzerland
Full Name: Karl Widmer

Re: after v9 U2 install: Backup Service does not start

Veeam Logoby hirratas » Tue Aug 09, 2016 10:51 am 1 person likes this post

Veeam Support gave me a call half an hour after the appointment and gave the User for "Veeam Backup Service" sysadmin rights on the SQL Server instance. He did not even asked me if he could give the user sysadmin rights.
I asked the Support if this is neccessary and explained that SQL sysadmin rights were not neccessary since Veeam v6, and that the user just has db_owner permissions on the db.

He told me that it is neccessary that this user has sysadmin rights on the sql instance and did not explain anything further.
The service then started fine.
I removed the sysadmin rights again because it does not comply with our regulations, and restarted the Veeam Server and the service is running. Maybe after Upgrade 2 some operations needed to take place and more permissions were neccessary for a short time. Not concinved from Veeam Support.

According this sysadmin rights are not neccessary: https://helpcenter.veeam.com/backup/vsp ... sions.html
Microsoft SQL Server
The account used to run Veeam Backup Service requires db_datareader and db_datawriter roles as well as permissions to execute stored procedures for the configuration database on the Microsoft SQL Server. Alternatively, you can assign db_owner role for this database to the service account.
hirratas
Influencer
 
Posts: 20
Liked: 1 time
Joined: Fri Feb 10, 2012 7:56 am

Re: after v9 U2 install: Backup Service does not start

Veeam Logoby Sistemi.informativi » Wed Aug 10, 2016 6:43 am

Thank you

I got the same exact problem after i upgrade from Veeam B&R9u1 to u2, I add the sysadmin rights to the Veeam SQL login user and solve the problem.
Sistemi.informativi
Novice
 
Posts: 5
Liked: never
Joined: Thu Dec 10, 2015 10:34 am

Re: after v9 U2 install: Backup Service does not start

Veeam Logoby hirratas » Wed Aug 10, 2016 8:11 am

Good thing with It problems is that you are not the only one with it :D
hirratas
Influencer
 
Posts: 20
Liked: 1 time
Joined: Fri Feb 10, 2012 7:56 am

Re: after v9 U2 install: Backup Service does not start

Veeam Logoby Gostev » Wed Aug 10, 2016 12:30 pm

We will investigate.
Gostev
Veeam Software
 
Posts: 21396
Liked: 2350 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: after v9 U2 install: Backup Service does not start

Veeam Logoby Gostev » Wed Aug 10, 2016 1:13 pm 1 person likes this post

Confirmed: upgrade requires db_owner, after that you can drop account permissions back to "db_datareader and db_datawriter roles as well as permissions to execute stored procedures".
Gostev
Veeam Software
 
Posts: 21396
Liked: 2350 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: after v9 U2 install: Backup Service does not start

Veeam Logoby chattingh » Thu Aug 11, 2016 11:22 pm

We have experienced the same issue. After installing v9 update 2, the Veeam Backup Service will not start.

In our case, the Veeam Service Account was already db_owner. To fix I had to temporarily grant the Veeam Service Account sysadmin rights on the SQL server to get the service to start. Once that was done, the sysadmin rights were removed and the Veeam Backup Service starts & stops fine.
chattingh
Service Provider
 
Posts: 48
Liked: 2 times
Joined: Fri Jan 22, 2016 12:45 am
Full Name: Carl Hattingh

Re: after v9 U2 install: Backup Service does not start

Veeam Logoby Gostev » Fri Aug 12, 2016 12:23 pm

We can't confirm this one. QC has just completed an additional round of testing, and they could not reproduce any upgrades problems with Veeam Service Accounts not having sysadmin rights on the SQL Server. All upgrades completed successfully with db_owner privilege alone during their tests.

Could it be that some other issue was preventing the Veeam Backup Service from starting in your case, and it was not granting sysadmin that fixed it?
Gostev
Veeam Software
 
Posts: 21396
Liked: 2350 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: after v9 U2 install: Backup Service does not start

Veeam Logoby chattingh » Fri Aug 12, 2016 1:07 pm

That is very interesting Gostev.
It happened across two installs, although same SQL server. This was the error logged in the application event log every time we tried to start the service unsuccessfully:
Service cannot be started. Veeam.Backup.DBCreator.DatabaseException: Failed to deploy database. Alter failed for Database .....

SQL 2014 Exp installed separately, not as bundled with Veeam if that helps at all.
chattingh
Service Provider
 
Posts: 48
Liked: 2 times
Joined: Fri Jan 22, 2016 12:45 am
Full Name: Carl Hattingh

Re: after v9 U2 install: Backup Service does not start

Veeam Logoby Gostev » Fri Aug 12, 2016 2:39 pm 1 person likes this post

Yes, they have tested with SQL Server 2014 as well. If you have time, please send setup logs to support and we will investigate. Thanks!
Gostev
Veeam Software
 
Posts: 21396
Liked: 2350 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Next

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Vitaliy S. and 63 guests