I have got this error when trying to connect with SQL Server 2000 from
ASP.NET 2.0 using Windows Authentication. >Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. The Sql server is in Mixed Mode and it is running on Windows Server 2000. Connection String used : "Data Source=server;Initial Catalog=db;Integrated Security=SSPI" any idea? Thanks in Advance Chadru
You could add a Windows Authentication account to the SQL Server that maps to the service process used for IIS - but it might be better not to do that, as that would mean that the IIS process would have access to your SQL Server by default.