SQL DATABASE
Database
2
Posts
2
Posters
0
Views
1
Watching
-
Hi Guys , Is there any script that i can run on the database server so that i can retreive all the Computers(IP addresses) that tried connect to the database? Please advice. Many thanks, Regards, kibrom
I think you can't retrieve client IP's trying to connect to your DB.You could query net_address from sys.sysprocesses which is unique identifier for the network adapter on the workstation of each user ,but how to refer it to user IP I don't know.:confused: