How to know the IP address of the Client - SQL Server Security

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » 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
Location: 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: 345
Points: 748
Location: 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
Location: 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: 345
Points: 748
Location: 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.