Login failed ... not associated with a trusted SQL server connection
Posted by: Paul Litwins Blog,
on 11 Sep 2006 |
View original | Bookmarked: 0 time(s)
If you've ever encountered a message along the lines of "not associated with a trusted connection to SQL Server", the problem is usually the SQL Server not supporting mixed mode (a.k.a. "SQL Server and Windows Authentication mode" in SQL Server 2005 or "SQL Server and Windows" authentication in SQL Server 2000).This usually occurs after one has added some SQL Server logins to a SQL Server and tries to establish a connection to that SQL box using ADO.NET, SQL...