Thanks for prompt response.
I checked the sql server text logs and they are showing no information of the attempted connection. I doubt if there will be any relevant entry in the SQL Server transaction log in the database. As for running a trace I have never performed that before. I will investigate and have a go.
Thanks