Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Who is connecting to SQL feature?
Message
From
31/10/2012 11:35:10
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01556118
Message ID:
01556166
Views:
39
>>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
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform