>>Hi,
>>
>>I need to determine if a user, when trying to load an application, is being denied access by SQL Server. I have admin access to the SQL server. What is the feature of SQL Server I can use for this? That is, how can I see if "someone" is trying to connect to the SQL?
>>
>>TIA.
>
>Windows Event Log does not show me anything. That is, I can't find any "indicatiopn" in the Windows Event Log where a user has been connected or tried to connect to the SQL Server. But I thought there must be a feature in SQL Server itself, some kind of log, that shows who has attempted to connect and connected successfully or not. Does such feature exist?

Might this help?
http://msdn.microsoft.com/en-us/library/aa172599(v=sql.80).aspx