Re: [DotNetDevelopment] Authentication issue in web.config

34 views
Skip to first unread message

Stephen Russell

unread,
Apr 27, 2013, 9:00:13 PM4/27/13
to dotnetde...@googlegroups.com



On Wed, Apr 24, 2013 at 3:15 PM, LimTim <aish...@gmail.com> wrote:
I am developing a website.
 
I want to use widows credential to log onto SQL server for connection strings
So I have added code

When I run Webpage i get error 
 
System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
 
--------------

You need to define a USER in SQL Server because NT Authority, the "user" that is currently designated as your web site on the server has no rights on the server.

Now take that connection string in you .Config and tweak it to present the new user you just defined.  

HTH 

--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell
Reply all
Reply to author
Forward
0 new messages