>>>>>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.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham