>>>>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.
>
>Can I see the SQL server log from SSMS? If yes, where do I find it there? Thank you.
Take a look at
http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/my-favorite-powershell-script-reading and the comments to that blog.
If it's not broken, fix it until it is.
My Blog