1 Reply Latest reply on Jan 24, 2018 6:53 AM by t3chno

    Attempting to use an NT account name with SQL Server Authentication

    redlotus

      Hi All,

       

      In sql error log ( SQL 2008 R2) I notice that we keep getting this same issue "

      " Login failed for user ABC\xxx"

      Reason: Attempting to use an NT account name with SQL Server Authentication. [CLIENT: ..........] .

      AUthentication is mixed mode

      I checked in Solarwind and user ABC\xxx is there ( crossed with blue pen
      )

      I am wondering why this happen . Any feedback is much much appreciated !

      Cheers

        • Re: Attempting to use an NT account name with SQL Server Authentication
          t3chno

          Found the Issue :-)

           

          The account needs to be granted 'Log on as a Batch Job'

          1. In the Control Panel, open Administrative Tools, then Local Security Policy.
          2. Beneath Security Settings, open Local Policies and highlight User Rights Assignment.
          3. Locate Log on as a batch job. Open the properties and add any users that need this right.
          4. When finished, save your changes and close the Local Security Settings window.

           

          I'm all working now :-)