Login Failed

• guaro5555

  Mr or Mrs. 500

  Points: 548

  More actions

  January 16, 2015 at 11:27 am

  #300409

  Hi gurus

  I am in need of some serious help, and I hope you gurus can help me.

  I have a sql server with one instance and I can connect to it using windows auth but not sql server auth, I have checked an the server is config to do both sql and win mode,that is one, but when I log as win auth every time I try to run a query I get this error

  " LOGIN failed for user "NT authority\Anonymous logon"

  Can I get some help and thanks a bunch

• RTaylor2208

  SSChampion

  Points: 13298

  More actions

  January 19, 2015 at 8:13 am

  #1771130

  guaro5555 (1/16/2015)

  ---

  Hi gurus

  I am in need of some serious help, and I hope you gurus can help me.

  I have a sql server with one instance and I can connect to it using windows auth but not sql server auth, I have checked an the server is config to do both sql and win mode,that is one, but when I log as win auth every time I try to run a query I get this error

  " LOGIN failed for user "NT authority\Anonymous logon"

  Can I get some help and thanks a bunch

  What application are you trying to connect to the SQL server with? SSMS, sqlcmd, something else?

  The failure message you are getting indicates you are trying to connect using windows authentication, and not SQL authentication as a login failure with SQL Authentication would not state that particular user unless you have actually tried that as a user name.

  Past experience tells me that you are probably connecting via a service that is running under the local system account rather than a AD login hence the "NT Authority\Anonomous" login, but this is pure speculation without knowing how you are connecting.

  MCITP SQL 2005, MCSA SQL 2012

• Jeff Moden

  SSC Guru

  Points: 1004561

  More actions

  January 19, 2015 at 8:18 am

  #1771133

  The Windows Login still has to be present on the SQL Server or the AD Group that the login belongs to has to be present on the SQL Server.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)