This is a good write-up of the steps you need to take if you have “Login failed for user (null)“ errors.
http://weblogs.asp.net/AChang/archive/2004/04/15/113866.aspx