Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON

Question

0.00/5 (No votes)

See more:

I create a very simple website.
when I run website from VS2012 ,website easily can get data from SQLSERVER which run on server which is seperate (I mean SQLSERVER is on one server and I host website on my pc as server).
but when I publish website on my PC IIS,browsing the website from IIS manager cause below error:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON

Posted 17-Mar-14 22:56pm

saeed nazary

Updated 17-Mar-14 23:03pm

v2

Add a Solution

5 solutions

Solution 1

In order to authenticate users with anonymous login you have to do the following things in IIS:
Anonymous Authentication = Enabled
ASP.Net impersonation = Disabled
Windows Authentication = Disabled

In this case anyone can authenticate to your website.

I've stroked out this solution because it is for windows authentication:
~~In IIS you have to change in authentication pane the Anonymous Authentication value to Disable. After you have to change the impersonation to true.~~

Posted 17-Mar-14 23:15pm

norbitrial

Updated 18-Mar-14 4:40am

v4

Comments

saeed nazary 18-Mar-14 8:09am

Thanks for your answer.
I did what you mentioned.that problem solved but I encounter with a request that wants me to enter Username and Password.
by my credentials which is admin on network I can login without any problem but ordinary users cant login.
but the important problem is this:
I dont want to encounter any credential request for accessing website
could you help me in this regard

norbitrial 18-Mar-14 10:37am

I've improved my answer, now you can see the solution for your problem.

Solution 5

Bunch of thanks for your support.
The problem was for sqlserver windows authentication.

Solution is:

1-Create a user in sqlserver from Security section as SqlAuthentication
2-IN VS 2012 ,Create your connection String with SqlAuthentication
(determin Username and Password)
3-there is no need to change any IIS configuration.

thanx and best regards for who answer me,and helped me to solve this issue

Posted 18-Mar-14 5:47am

saeed nazary

Comments

saeed nazary 18-Mar-14 11:50am

Bunch of thanks for your support.
The problem was for sqlserver windows authentication.

Solution is:

1-Create a user in sqlserver from Security section as SqlAuthentication
2-IN VS 2012 ,Create your connection String with SqlAuthentication
(determin Username and Password)
3-there is no need to change any IIS configuration.

thanx and best regards for who answer me,and helped me to solve this issue

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Krunal Rohit · Accepted Answer · 2014-03-18T04:42:00

In IIS7 on your Windows 2008 Web Server...

Please go to Application Pools.

Select your web site.

Click "Advanced Settings" in the "Actions" panel.

Under "Process Model" select "Identity."

In the popup, select the "Custom account" radio button.

"Set" the account and password to your dbo account name and password that are used on your SQL Server 2008 database.

Save that.

Under sites, go to your website. In the Features View panel, select "Authentication" under IIS. Under ASP.Net Impersonation, make sure it's Disabled.

-KR

Paw Jershauge · Accepted Answer · 2014-03-17T23:18:00

Solution 2

You probably just need to provide a user name and password in your connectionstring and set Integrated Security=false

Posted 17-Mar-14 23:18pm

Paw Jershauge

Aravindba · Accepted Answer · 2014-03-17T23:22:00

Solution 3

Hi if u use sql server for website,need to SQL Server Authentication,dont use Windows Authentication.Try to give username ,password and providerName="System.Data.SqlClient".

Try to correct datasource in connectionString in web.config file

Posted 17-Mar-14 23:22pm

Aravindba

Updated 17-Mar-14 23:23pm

v2