May be this will help you – Just set up a profiler of SQL server trace to examine the “audit login failed event” to get together detailed information about permissions problems or issues. If you eant further concern of how to use SQL server profiler just check the SQL server documentations in msdn.microsoft.com.