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 10:48 am

    #1982977

    How do you set the service account? You should use the SQL Server Configuration Manager, since this also grants the permissions needed.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]