Home Forums SQL Server 2008 Security (SS2K8) Logon failure: the user has not been granted the requested logon type at this computer.error for SQL Services even though account has Log on as a Service priveledges RE: Logon failure: the user has not been granted the requested logon type at this computer.error for SQL Services even though account has Log on as a Service priveledges

  • March 13, 2018 at 12:23 pm

    #1983030

    craig.d.brown - Tuesday, March 13, 2018 11:00 AM

    I've assumed that, since the user account is working on another SQL instance that there would not be any deny.  Any recommendation on how I could confirm this would be appreciated.

    You'd have to get in touch with whoever is the Active Directory administrators to find out.  There is an option to restrict the times and / or the computers an account can log in during / too.  Possibly the AD Admins set this for your service account, such that it can only log in to one server (the working one,) rather than any server / computer.