Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON

时间:2023-03-10 04:46:31
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON

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

Solution 1

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