LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » SQL Server Database Administration » SQL Server Security » How to know the IP address of the Client

How to know the IP address of the Client

Options

Previous Topic · Next Topic

raaz

Posted: Thursday, July 05, 2007 6:08:32 AM

Rank: Junior DBA

Joined: 5/17/2007
Posts: 59
Points: 189
Where do you live?: India

Hi,

Is there any possible way to find the Client's IP address connected to the SQL Server Database?

Thanks in advance.

Scott Whigham

Posted: Thursday, July 05, 2007 7:30:35 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 476
Points: 1,053
Where do you live?: Dallas, TX

Not from SQL that I know of... The only thing we can get is the HOSTNAME and that's just unreliable since it's up to the programmer who wrote the connection to pass that info correctly.

raaz

Posted: Friday, July 06, 2007 3:53:33 AM

Rank: Junior DBA

Joined: 5/17/2007
Posts: 59
Points: 189
Where do you live?: India

Hi Scott,

In the sys.dm_exec_connections we can find the information of the sessions connected and the client net IP addess and connect time details. I don't know what is the base table for this view.

How ever i want to know how this can be used in auditing the data.

Is there any default audit setting available with SQL Server?If so how it can be done?

Any idea on this..

Thanks In Advance.

Scott Whigham

Posted: Friday, July 13, 2007 9:00:37 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 476
Points: 1,053
Where do you live?: Dallas, TX

That's right - forgot about that! So many things to remember with SQL 2005 Smile

Thanks!

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.