Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'[Answered] RSS

• • Reply
  jibarra

  Member

  12 Points

  79 Posts

  Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

  Apr 28, 2014 11:54 PM|jibarra|LINK

  hi team

  i have this issues, i have 2 machines Machine A has SQL server 2008 express Machine B has IIS 7 with windows 7 32 bit

  i have a web page that search the log information from tables from Machine A,if a run the website from Machine B where the iis is installed the webpage will open

  but if i run it from another machine the samewebsite im getting this error

  Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

  any advice

  i have this option to true

  connectionString<add name="ConnectionString" connectionString="Data Source=DBA\SQLEXPRESSP3;Initial Catalog=MYDB;Integrated Security=True" providerName="System.Data.SqlClient"/>

  <identity impersonate="true"/>

  <authentication mode="Windows"/>

   

• • Reply
  dyyo

  Participant

  1100 Points

  400 Posts

  Re: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

  Apr 29, 2014 01:21 AM|dyyo|LINK

  hi there,
  
  you should create a separate db user to access the database. Next, your connection stirng should look something like.:
  
  <add name="connString" connectionString="Data Source=our_SQL_SERVER_ID;uid=your_DB_username;pwd=your_DB_password;Initial Catalog=your_DB_name"></add>
  
  Therefore, you cannot use the "Windows Authentication mode", but "SQL Server Authentication mode"
  
  Please mark this response as an answer if it helps. Thanks heaps!

  Regards,
  Dyyo - Microsoft Recommended ASP.NET Hosting
  
• • Reply
  jibarra

  Member

  12 Points

  79 Posts

  Re: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

  Apr 29, 2014 10:26 AM|jibarra|LINK

  thanks dyyo but if i do that

  the user and password will be see and we can have a securty breach

  thanks for your advice

• • Reply
  toon10

  Member

  1 Points

  3 Posts

  Re: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

  May 01, 2014 08:22 AM|toon10|LINK

  I had a similar issue with my site not so long ago.  I added the following to the web.config file and it cured it:

      <authorization>
        <deny users="?" />
      </authorization>

  Not sure if that will fix the problem as I'm fairly new to ASP coming from a Windows forms based background but it's worth a try.

• • Reply
  om1042

  Member

  390 Points

  139 Posts

  Re: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

  May 01, 2014 11:15 AM|om1042|LINK

  Possible areas to check

  1-Check which application pool the web site is running.if its taking application pool identity and that account does not have acces to db then it will fail.

  2-Chek what authentication is set up at IIS level for this site.if both windows and anonymous authentication is enabled then disable anonymous authentication as you are

  using windowsauthentication only.

• • Reply
  Sam - MSFT

  Star

  10596 Points

  1379 Posts

  Re: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

  May 08, 2014 06:24 AM|Sam - MSFT|LINK

  Hi,

  jibarra

  Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

  First, your users need to have delegation enabled and if the only thing that's changed, it'l likely they do. Otherwise you can uncheck the "Account is sensitive and cannot be delegated" checkbox is the user properties in AD.

  Second, your service account(s) must be trusted for delegation. Since you recetly changed your service account I suspect this is the culprit. (http://technet.microsoft.com/en-us/library/cc739474(v=ws.10).aspx)

  Refer to the following article:

  http://stackoverflow.com/questions/12462674/sql-server-returns-error-login-failed-for-user-nt-authority-anonymous-logon

  Best Regards!