Availability for the Always-On Enterprise
foggy
Veeam Software
Posts: 16957
Liked: 1380 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Backups and 9.5U3

Post by foggy » Jul 11, 2018 11:47 am 1 person likes this post

ae_group_ag wrote:We have the same issue but with Windows Server 2003. I added our veeam service user to the sysadmin role but this doesn't solved it.
The error message is "Logon failure: the user has not been granted the requested logon type at this computer".
Logon as batch job right is still required even if the account has sysadmin role.

hansvh
Influencer
Posts: 10
Liked: 1 time
Joined: Feb 26, 2013 11:24 am
Full Name: Hans
Contact:

Re: SQL Backups and 9.5U3

Post by hansvh » Jul 11, 2018 12:45 pm

As far as I understand, for the issue with "Unable to update SQL backupset" error, the immediate fix is db_datawriter permission on msdb database for the account you use for SQL processing.
Hmmm. This does not seem to work. I've got a replication job running of a SQL server with this issue. Gave the Veeam user which runs the job the db_datawriter permission on the SQL server by running this query:

Code: Select all

use msdb
go

alter role db_datawriter add member [username];
go
Job still finishes with same warning. Am I missing something?

Gostev
Veeam Software
Posts: 23116
Liked: 2917 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL Backups and 9.5U3

Post by Gostev » Jul 11, 2018 12:52 pm

Please use test SQL queries from the last post on the previous page to troubleshoot this (or open a support case for assistance).

hansvh
Influencer
Posts: 10
Liked: 1 time
Joined: Feb 26, 2013 11:24 am
Full Name: Hans
Contact:

Re: SQL Backups and 9.5U3

Post by hansvh » Jul 11, 2018 1:18 pm 1 person likes this post

hansvh wrote:Job still finishes with same warning. Am I missing something?
I indeed was missing something :oops: . The useraccount that runs the backups has local admin rights on the database server as well as SQL sysadmin rights on the database itself. Completely forgot about another SQL server instance running on the same server (sigh). Gave the Veeam user sysadmin rights on that instance as well which solved my problem!

melliott7
Novice
Posts: 3
Liked: never
Joined: Jul 09, 2018 12:30 pm
Full Name: Marcus Elliott
Contact:

Re: SQL Backups and 9.5U3

Post by melliott7 » Jul 11, 2018 1:43 pm

Hi Gostev,

I ran the first 2 test quires and It had the correct output on those. However when I go to run the third query it gave me this message below.

!!Here is the query I copied from your post!!

update [msdb].[dbo].[backupset]
set name = 'test'
where backup_set_id = <any_backup_set_id>


!!Here is the error message I recieved!!!

Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '<'.

Let me know what you think when you get a chance.

Thanks,

foggy
Veeam Software
Posts: 16957
Liked: 1380 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Backups and 9.5U3

Post by foggy » Jul 11, 2018 1:52 pm

You should specify a valid ID from msdb.dbo.backupset table here. You can take any from the select backup_set_id from msdb.dbo.backupset output.
Also, please ensure you're executing it under the user that is specified in the job and on the same instance you're getting the warning for.

Gostev
Veeam Software
Posts: 23116
Liked: 2917 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL Backups and 9.5U3

Post by Gostev » Jul 11, 2018 9:25 pm

All, we have created a hotfix that does two things:

1. After failing to logon as a batch job, the job will immediately retry using interactive logon (pre-U3a way) before failing completely.

2. Warning about backupset update failure was changed to info event which additionally explains the issue in better details:
Transaction logs backup will not be possible due to insufficient permissions to update backupset for SQL instance: %SQLInstance%

Adjusting account's security rights and permissions on msdb according to the updated system requirements remains the preferred solution for obvious reasons, however we still decided to provide the hotfix for situation when adjusting account settings is not possible. The hotfix is available through our support.

igelm
Lurker
Posts: 1
Liked: never
Joined: Jul 12, 2018 4:58 am
Full Name: Marcin Igel
Contact:

Re: SQL Backups and 9.5U3

Post by igelm » Jul 12, 2018 11:21 am

Hello,
Where exactly can I download this hotfix?

foggy
Veeam Software
Posts: 16957
Liked: 1380 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Backups and 9.5U3

Post by foggy » Jul 12, 2018 11:27 am

Hi Marcin, please contact support to obtain it.

willjohnson
Novice
Posts: 4
Liked: 1 time
Joined: Jul 11, 2018 8:02 am
Contact:

Re: SQL Backups and 9.5U3

Post by willjohnson » Jul 12, 2018 11:29 am

We've asked twice but still haven't received the hotfix...

foggy
Veeam Software
Posts: 16957
Liked: 1380 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Backups and 9.5U3

Post by foggy » Jul 12, 2018 11:33 am

Please ask to escalate the case, chances are not everyone on the first line is yet aware, since the hot fix was just posted. T3 is certainly aware.

foggy
Veeam Software
Posts: 16957
Liked: 1380 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Backups and 9.5U3

Post by foggy » Jul 12, 2018 4:42 pm 1 person likes this post

Now all the support tiers are informed, so no more need to escalate the case to get the hotfix. Thanks!

fcompaired
Novice
Posts: 6
Liked: 1 time
Joined: Nov 02, 2015 4:02 pm
Full Name: Federico Compaired
Contact:

Re: SQL Backups and 9.5U3

Post by fcompaired » Jul 12, 2018 7:26 pm

I'm experiencing same issue after upgrading. I opened a case and was sent to this forum thread. :?:

fcompaired
Novice
Posts: 6
Liked: 1 time
Joined: Nov 02, 2015 4:02 pm
Full Name: Federico Compaired
Contact:

Re: SQL Backups and 9.5U3

Post by fcompaired » Jul 12, 2018 7:43 pm 1 person likes this post

The error I started seeing in alll SQL transaction log sessions is:
Unable to truncate Microsoft SQL Server transaction logs. Details: Failed to call RPC function 'Vss.TruncateSqlLogs': Error code: 0x80004005. Failed to invoke func [TruncateSqlLogs]: Unspecified error. Failed to process 'TruncateSQLLog' command. Failed to logon user [domain\user]. Win32 error:Logon failure: the user has not been granted the requested logon type at this computer. Code: 1385

Veeam support mentioned the setting 'Log on as batch job'

In our scenario we use a domain service account that has sysadmin role in all SQL instances. What I just did was granting 'Log on as batch job' permission to the service account in AD and tested running a backup job restarting the Log session. It has worked for this 1 job. I will keep checking all the other jobs.

melliott7
Novice
Posts: 3
Liked: never
Joined: Jul 09, 2018 12:30 pm
Full Name: Marcus Elliott
Contact:

Re: SQL Backups and 9.5U3

Post by melliott7 » Jul 13, 2018 2:10 pm

Hi Foggy and Gostev,

Thanks for the help with the 3 SQL Queries. I was able to run the third query and that completed with out a hitch so all three check out okay. I Ran the quires with the same account that is used for the backups and in SQL Server Management Studio I signed in using windows authentication with the same account. I also double checked SQL Server configuration manager to make sure there wasn't any other instances running that I didn't know about and it looks like there is only one (MSSQLSERVER, SQL Server Browser, and SQL Server Agent). Im still getting that warning message after several days.

let me know what you guys think when you get a chance.

Thanks,

Post Reply

Who is online

Users browsing this forum: Google [Bot], mecki and 38 guests