Wednesday, January 6, 2016

TIP on SQL Server Profiler Trace

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

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...