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.
| Author |
Topic |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2014-10-15 : 00:58:33
|
| Not sure if this is in the right forum, apologies if it's not, but:-We put our users into groups to access different areas/db's on the server, is there a way of tracing the ip address of each connection to find out the specific user/pc running a query (or even a report on the report server)? |
|
|
Shanky
Yak Posting Veteran
84 Posts |
Posted - 2014-10-15 : 07:54:50
|
| Hi,You can use DMV sys.dm_exec_sessions(http://msdn.microsoft.com/en-us/library/ms181509.aspx) with below query and track Host address of the client connecting to this serverselect session_id,net_transport,client_net_address,client_tcp_port from sys.dm_exec_connectionsHope this helpsRegardsShankySQL Server MVPhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
 |
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2014-10-15 : 10:22:52
|
| Thanks, I'll give it a shot. |
|
|
|
|
|
|
Identifying Connections