-
- Enthusiast
- Posts: 56
- Liked: 3 times
- Joined: Feb 10, 2012 7:56 am
- Contact:
after v9 U2 install: Backup Service does not start
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
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
-
- Expert
- Posts: 122
- Liked: 29 times
- Joined: Jan 06, 2015 10:03 am
- Full Name: Karl Widmer
- Location: Switzerland
- Contact:
Re: after v9 U2 install: Backup Service does not start
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?
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?
Karl Widmer
IT System Engineer
vExpert 2017-2024
VMware VCP-DCV 2023 / VCA6-DCV / VCA5-DCV / VCA5-Cloud / VMUG Leader
Former Veeam Vanguard / VMCE v9 / VMTSP v9 / VMSP v9
Personal blog: https://www.driftar.ch
Twitter: @widmerkarl
IT System Engineer
vExpert 2017-2024
VMware VCP-DCV 2023 / VCA6-DCV / VCA5-DCV / VCA5-Cloud / VMUG Leader
Former Veeam Vanguard / VMCE v9 / VMTSP v9 / VMSP v9
Personal blog: https://www.driftar.ch
Twitter: @widmerkarl
-
- Enthusiast
- Posts: 56
- Liked: 3 times
- Joined: Feb 10, 2012 7:56 am
- Contact:
Re: after v9 U2 install: Backup Service does not start
application event log / event id 0:
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.
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)
As I said the account successfully logs on to the SQL Server.
Sorry for the bad English.
-
- Expert
- Posts: 122
- Liked: 29 times
- Joined: Jan 06, 2015 10:03 am
- Full Name: Karl Widmer
- Location: Switzerland
- Contact:
Re: after v9 U2 install: Backup Service does not start
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.
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.
Karl Widmer
IT System Engineer
vExpert 2017-2024
VMware VCP-DCV 2023 / VCA6-DCV / VCA5-DCV / VCA5-Cloud / VMUG Leader
Former Veeam Vanguard / VMCE v9 / VMTSP v9 / VMSP v9
Personal blog: https://www.driftar.ch
Twitter: @widmerkarl
IT System Engineer
vExpert 2017-2024
VMware VCP-DCV 2023 / VCA6-DCV / VCA5-DCV / VCA5-Cloud / VMUG Leader
Former Veeam Vanguard / VMCE v9 / VMTSP v9 / VMSP v9
Personal blog: https://www.driftar.ch
Twitter: @widmerkarl
-
- Enthusiast
- Posts: 56
- Liked: 3 times
- Joined: Feb 10, 2012 7:56 am
- Contact:
Re: after v9 U2 install: Backup Service does not start
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.
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.
-
- Expert
- Posts: 122
- Liked: 29 times
- Joined: Jan 06, 2015 10:03 am
- Full Name: Karl Widmer
- Location: Switzerland
- Contact:
Re: after v9 U2 install: Backup Service does not start
No problem, we are all trying to help.
Thanks for keeping us posted.
Thanks for keeping us posted.
Karl Widmer
IT System Engineer
vExpert 2017-2024
VMware VCP-DCV 2023 / VCA6-DCV / VCA5-DCV / VCA5-Cloud / VMUG Leader
Former Veeam Vanguard / VMCE v9 / VMTSP v9 / VMSP v9
Personal blog: https://www.driftar.ch
Twitter: @widmerkarl
IT System Engineer
vExpert 2017-2024
VMware VCP-DCV 2023 / VCA6-DCV / VCA5-DCV / VCA5-Cloud / VMUG Leader
Former Veeam Vanguard / VMCE v9 / VMTSP v9 / VMSP v9
Personal blog: https://www.driftar.ch
Twitter: @widmerkarl
-
- Enthusiast
- Posts: 56
- Liked: 3 times
- Joined: Feb 10, 2012 7:56 am
- Contact:
Re: after v9 U2 install: Backup Service does not start
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.
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.
-
- Novice
- Posts: 5
- Liked: never
- Joined: Dec 10, 2015 10:34 am
- Contact:
Re: after v9 U2 install: Backup Service does not start
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.
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.
-
- Enthusiast
- Posts: 56
- Liked: 3 times
- Joined: Feb 10, 2012 7:56 am
- Contact:
Re: after v9 U2 install: Backup Service does not start
Good thing with It problems is that you are not the only one with it
-
- Chief Product Officer
- Posts: 31814
- Liked: 7302 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: after v9 U2 install: Backup Service does not start
We will investigate.
-
- Chief Product Officer
- Posts: 31814
- Liked: 7302 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: after v9 U2 install: Backup Service does not start
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".
-
- Enthusiast
- Posts: 57
- Liked: 3 times
- Joined: Jan 22, 2016 12:45 am
- Full Name: Carl Hattingh
- Contact:
Re: after v9 U2 install: Backup Service does not start
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.
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.
-
- Chief Product Officer
- Posts: 31814
- Liked: 7302 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: after v9 U2 install: Backup Service does not start
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?
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?
-
- Enthusiast
- Posts: 57
- Liked: 3 times
- Joined: Jan 22, 2016 12:45 am
- Full Name: Carl Hattingh
- Contact:
Re: after v9 U2 install: Backup Service does not start
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:
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:
SQL 2014 Exp installed separately, not as bundled with Veeam if that helps at all.Service cannot be started. Veeam.Backup.DBCreator.DatabaseException: Failed to deploy database. Alter failed for Database .....
-
- Chief Product Officer
- Posts: 31814
- Liked: 7302 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: after v9 U2 install: Backup Service does not start
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!
-
- Veteran
- Posts: 465
- Liked: 136 times
- Joined: Jul 16, 2015 1:31 pm
- Full Name: Marc K
- Contact:
Re: after v9 U2 install: Backup Service does not start
The same thing occurred with me. Both VeeamEnterpriseManagerSvc and VeeamBackupSvc would not start until I granted sysadmin rights. The user already had db_owner access to both databases and dbcreator rights on the server. This is also with SQL Server 2014. After starting the services the first time, I was able to remove sysadmin rights.
Thanks to this thread, I am up and running.
Thanks to this thread, I am up and running.
-
- Veteran
- Posts: 635
- Liked: 174 times
- Joined: Jun 18, 2012 8:58 pm
- Full Name: Alan Bolte
- Contact:
Re: after v9 U2 install: Backup Service does not start
What service pack and cumulative update are you all running? I'm wondering if the problem might be with some specific version.
-
- Enthusiast
- Posts: 57
- Liked: 3 times
- Joined: Jan 22, 2016 12:45 am
- Full Name: Carl Hattingh
- Contact:
Re: after v9 U2 install: Backup Service does not start
Hi Gostev, I have PM'ed you a link to the setup logs. I have taken them from C:\ProgamData\Veeam\Setup\Temp. Let me know if there are others you require.
-
- Veteran
- Posts: 465
- Liked: 136 times
- Joined: Jul 16, 2015 1:31 pm
- Full Name: Marc K
- Contact:
Re: after v9 U2 install: Backup Service does not start
Ours is SQL Server 2014 SP1 CU6 12.0.4449. And Veeam was 9.0 Update 1 with hotfix 68457.alanbolte wrote:What service pack and cumulative update are you all running? I'm wondering if the problem might be with some specific version.
-
- Veteran
- Posts: 942
- Liked: 53 times
- Joined: Nov 05, 2009 12:24 pm
- Location: Sydney, NSW
- Contact:
Re: after v9 U2 install: Backup Service does not start
OK, so in this case, We shall elevate the SQL Server service account privillege to sysadmin role first before applying the VBR 9.0 Update 2 upgrade ?
--
/* Veeam software enthusiast user & supporter ! */
/* Veeam software enthusiast user & supporter ! */
-
- VP, Product Management
- Posts: 27377
- Liked: 2800 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: after v9 U2 install: Backup Service does not start
Shouldn't be required according to the posts on the previous page, but to be on the safe side you can temporarily do it as a part of the upgrade procedure.
-
- Chief Product Officer
- Posts: 31814
- Liked: 7302 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: after v9 U2 install: Backup Service does not start
OK, we've found the real cause: db_owner on Veeam configuration database is indeed sufficient, it is another permission elsewhere that is lacking.
The failing query is required to obtain some information regarding Veeam configuration database from SQL Server, and this information resides in the system table. But depending on SQL Server version, accounts may not have a privilege to view system table content by default.
So instead of granting sysadmin role, you can simply grant Veeam service account the required rights:
@chattingh your case is actually very different (another operation fails) and support needs additional logs to investigate it.
Code: Select all
VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’
So instead of granting sysadmin role, you can simply grant Veeam service account the required rights:
Code: Select all
GRANT VIEW SERVER STATE TO "DOMAIN\ACCOUNT"
-
- Veteran
- Posts: 465
- Liked: 136 times
- Joined: Jul 16, 2015 1:31 pm
- Full Name: Marc K
- Contact:
Re: after v9 U2 install: Backup Service does not start
That makes sense. Granting admin rights often satisfies the immediate need, but is usually overbroad and doesn't address the actual cause of the problem.
-
- Service Provider
- Posts: 22
- Liked: 3 times
- Joined: Nov 20, 2012 3:00 am
- Full Name: Daniel P
- Contact:
Re: after v9 U2 install: Backup Service does not start
I upgraded as well from 9.0 Update1 to Update2 and experience the exact same log. Setting the Windows Service account used for SQL to have sysadmin rights allowed the service to start. This was following a reboot post upgrade. The services failed to start during the upgrade (Backup and Enterprise Manager) and prompted to start them manually. Glad to send any logs to whomever that may be of use. I will go ahead and fix the permissions as suggested.
Thanks all!
Thanks all!
-
- Novice
- Posts: 3
- Liked: never
- Joined: Aug 25, 2016 1:26 am
- Full Name: Raju George
- Contact:
Re: after v9 U2 install: Backup Service does not start
Hi guys,
im having the same issue, once update 2 is installed, im not even able to open the console , i get the below message
Failed to connect to Veeam Backup and Replication server : No connection could be made because the target machine actively refused it 127.0.0.1:9392
Also please advise how i can " temporarily grant the Veeam Service Account sysadmin rights on the SQL server to get the service to start "
Appreciate your help, im pretty nice to Veeam
Thanks
Raj
im having the same issue, once update 2 is installed, im not even able to open the console , i get the below message
Failed to connect to Veeam Backup and Replication server : No connection could be made because the target machine actively refused it 127.0.0.1:9392
Also please advise how i can " temporarily grant the Veeam Service Account sysadmin rights on the SQL server to get the service to start "
Appreciate your help, im pretty nice to Veeam
Thanks
Raj
-
- Lurker
- Posts: 2
- Liked: never
- Joined: Dec 09, 2011 3:15 pm
- Full Name: Jean-Philippe M.
- Location: France
- Contact:
Re: after v9 U2 install: Backup Service does not start
Hi,
I got the same issue here. Server has been upgraded from v8 update 2 to v9 (success) then to v9 update 2 (failed).
SQL server is a 2014 version and the service account is dbo on VeeamBackup.
Log file shows:
It seems that VIEW SERVER STATE is needed. I gave sysadmin rights to the service account (OMG !!!) and reinstalled update 2. It worked.
The veeam database maintenance needs more than "simple" dbo rights.
When the upgrade is over, sysadmin rights are no longer needed. I think, it should be fixed. In real life, sysadmin rights are never given to a service account.
I got the same issue here. Server has been upgraded from v8 update 2 to v9 (success) then to v9 update 2 (failed).
SQL server is a 2014 version and the service account is dbo on VeeamBackup.
Log file shows:
Code: Select all
[29.08.2016 13:30:59] <04> Info [DB|ERROR] Alter failed for Database 'VeeamBackup'. (Microsoft.SqlServer.Management.Smo.FailedOperationException)
[29.08.2016 13:30:59] <04> Info [DB|ERROR] à Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImpl()
[29.08.2016 13:30:59] <04> Info [DB|ERROR] à Microsoft.SqlServer.Management.Smo.Database.Alter(TerminationClause terminationClause)
[29.08.2016 13:30:59] <04> Info [DB|ERROR] à Veeam.Backup.DBCreator.DatabaseNamedOptions.Set()
[29.08.2016 13:30:59] <04> Info [DB|ERROR] à Veeam.Backup.DBCreator.BackupDatabaseDeployer.Deploy()
[29.08.2016 13:30:59] <04> Info [DB|ERROR] An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Management.Common.ExecutionFailureException)
[29.08.2016 13:30:59] <04> Info [DB|ERROR] à Microsoft.SqlServer.Management.Smo.Database.IsDatabaseEncryptionKeyPresent()
[29.08.2016 13:30:59] <04> Info [DB|ERROR] à Microsoft.SqlServer.Management.Smo.Database.ScriptAlter(StringCollection alterQuery, ScriptingPreferences sp)
[29.08.2016 13:30:59] <04> Info [DB|ERROR] à Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImplWorker()
[29.08.2016 13:30:59] <04> Info [DB|ERROR] à Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImpl()
[29.08.2016 13:30:59] <04> Info [DB|ERROR] L'autorisation VIEW SERVER STATE a été refusée sur l'objet 'server', base de données 'master'.
[29.08.2016 13:30:59] <04> Info [DB|ERROR] L'utilisateur n'est pas autorisé à effectuer cette action. (System.Data.SqlClient.SqlException)
[29.08.2016 13:30:59] <04> Info [DB|ERROR] à Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
[29.08.2016 13:30:59] <04> Info [DB|ERROR] à Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand)
[29.08.2016 13:30:59] <04> Error An error occurred during the connect to sql server. Failed to deploy database. Alter failed for Database 'VeeamBackup'.
The veeam database maintenance needs more than "simple" dbo rights.
When the upgrade is over, sysadmin rights are no longer needed. I think, it should be fixed. In real life, sysadmin rights are never given to a service account.
Jean-Philippe M.
France
France
-
- Veeam Software
- Posts: 21139
- Liked: 2141 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: after v9 U2 install: Backup Service does not start
Above you can find instructions on how to grant Veeam service account the required rights without giving it sysadmin role.
-
- Novice
- Posts: 3
- Liked: never
- Joined: Aug 25, 2016 1:26 am
- Full Name: Raju George
- Contact:
Re: after v9 U2 install: Backup Service does not start
Hi Glouton and Foggy,
Glad to know that giving sysadmin rights to service account worked, please advise how we do this. my apologies since im pretty new to veeam , infact this is my first install of veeam.
Like how some mentioned here Veeam 9 version 902 works well, im able to add Server 2008 R2 as back up repository BUT NOT server 2012
When update 1 is applied i can have server 2008 R2 as back up repository BUT NOT server 2012
But when update 2 is applied , i cannot even open the console
I dont have separate SQL server , im not sure how to give sysadmin rights to service account , please help
Thanks
Raj
Glad to know that giving sysadmin rights to service account worked, please advise how we do this. my apologies since im pretty new to veeam , infact this is my first install of veeam.
Like how some mentioned here Veeam 9 version 902 works well, im able to add Server 2008 R2 as back up repository BUT NOT server 2012
When update 1 is applied i can have server 2008 R2 as back up repository BUT NOT server 2012
But when update 2 is applied , i cannot even open the console
I dont have separate SQL server , im not sure how to give sysadmin rights to service account , please help
Thanks
Raj
-
- Veeam Software
- Posts: 21139
- Liked: 2141 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: after v9 U2 install: Backup Service does not start
Hi Raj, you can google for the step-by-step instruction on granting roles and permissions in SQL Server Management Studio. Basically, all you need to do is executing the statement given by Anton above to grant the VIEW SERVER STATE permission to the Veeam service account (no need for full sysadmin role).
In case adding permissions doesn't help, feel free to contact technical support for a closer investigation.
In case adding permissions doesn't help, feel free to contact technical support for a closer investigation.
-
- Novice
- Posts: 3
- Liked: never
- Joined: Aug 25, 2016 1:26 am
- Full Name: Raju George
- Contact:
Re: after v9 U2 install: Backup Service does not start
Thanks Foggy, i will try that and let you know how it goes , appreciate your help guys
Who is online
Users browsing this forum: Google [Bot] and 59 guests