DavidB Thanks also, I have the sytbl map and was working sql7 never know if its been changed but seems it has not been, Thanks...

There is always the -E switch for a trusted connection.

Antares686 Thanks for your assistance on this matter, pochinej from http://www.sql-scripting.com

I have currently automated the whole process and it sends me an email at the end of every business day with a formated HTML table containing all the failed logins...

Profiler is a good tool for this type of an issue. I have had good results with capturing the profiler data to a table and writing your own custom queries...