I'm running IIS 5 and SQL Server 2K, and its running on a server separate of IIS. I'm having trouble establishing a connection to SQL Server. I get the error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. I've done everything they said to do on the Microsoft Websites about creating local accounts on both machines. Please help!

Check the authentication mode of your SQL SERVER, it's possible that it might be in windows authentication mode only. Choose Mixed mode.

Charul Shukla

I checked that as well, and its in mixed mode. I only get this problem when I try to connect to SQL Server that's on a different machine. When IIS and SQL Server are on the same machine everything works fine.