>>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?
You can also try checking SQL Server log.
If it's not broken, fix it until it is.
My Blog