Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Knowledge Base > ASP.Net > Errors and Bugs > SQL Server Session


Search:
What's New - What's Hot
You may receive the error "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection" - Part I     
Total Hits: 888  |  Today: 0Author: Harish Ranganathan      Rating:  
Read Reviews | Write Review |  Your Rating: 

Integrated authentication allows for SQL Server to leverage Windows NT authentication to validate SQL Server logon accounts. This allows the user to bypass the standard SQL Server logon process. With this approach, a network user can access a SQL Server database without supplying a separate logon identification or password because SQL Server obtains the user and password information from the Windows NT network security process. Choosing integrated authentication for ASP.NET applications is a goo...

You may receive the error "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection" - Part II     
Total Hits: 810  |  Today: 0Author: Harish Ranganathan      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article is in continuation with Part I where I explained the scenarios where this error occurs when the Webserver and SQL Server are running on the same machine. In case you havent read that, please Read Part I of this article, before proceeding. Check the SQL Server Authentication Mode and set is to Mixed Mode Authentication, as explained in Part I of this article. Then comes the actual interesting part. Though you configure your SQL Server to Mixed Mode Authentication and add ASPNET or NE...



Disclaimer - Privacy
© 2002-2017 DevASP.net