Disable Interactive Logon Breaks SQL Backups

VMware specific discussions

Disable Interactive Logon Breaks SQL Backups

Veeam Logoby rreed » Fri Aug 19, 2016 7:00 pm

Afternoon everyone. Due to some audit findings we found some service accounts that needed set to deny active logon. Upon doing so all our SQL servers' backups broke w/ "Win32 error:Logon failure: the user has not been granted the requested logon type at this computer." It is currently a domain admin which includes local administrator though we're waiting for that to get pulled back. I found this https://forums.veeam.com/post165004.html?hilit=interactive%20logon#p165004 but the only response to our same issue appeared to be from another user who set their service account back to interactive logon and the problem went away. Same for us, we removed disable interactive logon and they started working again. But, clearly we can't do that. :wink:

Do we have a fix please?
VMware 6
Veeam B&R v9
Dell DR4100's
EMC DD2200's
EMC DD620's
Dell TL2000 via PE430 (SAS)
rreed
Expert
 
Posts: 354
Liked: 72 times
Joined: Tue Jun 30, 2015 6:06 pm

Re: Disable Interactive Logon Breaks SQL Backups

Veeam Logoby rreed » Fri Aug 19, 2016 7:20 pm

Upon some spot checking, our service account is also in a group that is in sysadmin role as well.
VMware 6
Veeam B&R v9
Dell DR4100's
EMC DD2200's
EMC DD620's
Dell TL2000 via PE430 (SAS)
rreed
Expert
 
Posts: 354
Liked: 72 times
Joined: Tue Jun 30, 2015 6:06 pm

Re: Disable Interactive Logon Breaks SQL Backups

Veeam Logoby rreed » Fri Aug 19, 2016 8:19 pm

On the real SQL servers anyways, many of them are SQL Express.
VMware 6
Veeam B&R v9
Dell DR4100's
EMC DD2200's
EMC DD620's
Dell TL2000 via PE430 (SAS)
rreed
Expert
 
Posts: 354
Liked: 72 times
Joined: Tue Jun 30, 2015 6:06 pm

Re: Disable Interactive Logon Breaks SQL Backups

Veeam Logoby ynguldyn » Thu Aug 25, 2016 2:59 am

We're facing the same dilemma: we can choose to make proper SQL backups with Veeam or stay compliant with our security audits. I have confirmed with support that we can't have both.

Obviously, security considerations are winning.

It would be really nice if the interactive logon requirement could be removed. What about it, rebyata iz Veeam?
ynguldyn
Lurker
 
Posts: 2
Liked: never
Joined: Thu Jun 23, 2011 9:59 pm

Re: Disable Interactive Logon Breaks SQL Backups

Veeam Logoby foggy » Mon Sep 05, 2016 3:16 pm

Need to research the ability to work without interactive logon.
foggy
Veeam Software
 
Posts: 14765
Liked: 1083 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to VMware vSphere



Who is online

Users browsing this forum: larry and 19 guests