Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server conn

[janilane]

Hi, anyone knows how to resolve this? This happens when I try to invoke the web method, I can connect to the datasource without any problem.I've search the net for solutions but can't find any. thanks

 

[petersgyoung]

ASP.Net web application (including web service) will use a less-privilege account as process identity (ASPNET on Windows XP and NETWORK SERVICE on Windows Vista and Windows Server 2003). If you want to use trusted SQL Server connection, you need to give read-write permission to these accounts.