I was trying to find out who/ what application are connecting to SQL SERVER "ITSQL"
Instance Name:"ITSQL"
IP Address: "172.00.00.00"
Say,
Application XYZ connecting to SQL SERVER with Instance Name:"ITSQL "
and
Application ABC or someone else connecting to SQL SERVER with IP Address: "172.00.00.00"
when i try to run Trace with below template
EventClass ApplicationName LoginName SPID Starttime Database HostName SessionLoginName ServerName
i was not able to find out application which are connecting to SQL SERVER with IP Address: "172.00.00.00"
so after a lot of testing i found that even when ABC application is trying to connect with IP address "172.00.00.00" , it shows as connecting to Instance name "ITSQL"
So, i was able to find out all connections..
Fyi...this is not proven yet in production..
No comments:
Post a Comment