[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 172
  • Last Modified:

see all ip addresses connected to sql server 2005

how to see all the ip addresses
0
rgb192
Asked:
rgb192
1 Solution
 
chapmandewCommented:
select client_net_address, * from sys.dm_exec_connections
0
 
rgb192Author Commented:
client_net_address
<local machine>

does not say ip address of remote ip address that is using sql server
0
 
chapmandewCommented:
if you have remote machines connected it will...I just confirmed on my machine.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
rgb192Author Commented:
i am using php code to connect to sql server

i cant see the ip address of where i am using php code to query sql server
0
 
malcouCommented:
Check your client protocols in SQL Server configuration manager - if TCP/IP is not enabled you will not see the IP address - then it is connectiong using on of the other protocols
0
 
St3veMaxCommented:
If you are using php; you need to confirm where the php web server sits. If it's on the same box; then as far as SQL is concerned; the connection originated locally, hence the 'Local Machine'

HTH
0
 
rgb192Author Commented:
is there a table
or database
that records all the ip addresses of conections
0
 
rgb192Author Commented:
thanks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now