How to Audit IP Address in SQL Server 2005/08

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

How to Audit IP Address in SQL Server 2005/08

Author

Topic

svellampalli
Starting Member

3 Posts

Posted - 2011-03-23 : 15:43:56

Hello -

Is it possible to Audit IP Address of all users who are accessing SQL Server and what login they are using.

Is this feature is available in SQL Server 2005 and SQL Server 2008.

Please advise.

Regards

Sathish Vellampalli

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-23 : 15:52:29

You'll need to get the hostname from sysprocesses, then do a ping via xp_cmdshell to get the IP address. Sysprocesses also contains the login info. Poll the data maybe once a minute.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

svellampalli
Starting Member

3 Posts

Posted - 2011-03-23 : 16:09:41

Thank you Tara for quick reply.

Is there any steps or procedure that you can provide me to implement this sceanrio.

Please advise.

Regards

Sathish Vellampalli

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-03-23 : 17:16:11

Or try this:

select client_net_address, * from sys.dm_exec_connections

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources