Post reply

Capturing connection coming from outside in SQL server using profiler

  • May 14, 2015 at 10:18 am

    #308126

    Hi,

    I need to do testing on capturing connection coming from outside using Profiler. Basically I need to do something from other SQL servers connecting to this SQL server and test if it is captured by profiler. Can you please advise how I can do it. I would really appreciate your help !

    Thanks

  • May 14, 2015 at 10:23 am

    #1797929

    if you fire up a new trace and use the login audit template, this will trace just connections. then in the hostname field you will see the source of the connection. this should be a low impact trace as you are not tracking query activity, however will still have a load on the system so just make sure it doesn't impact performance. if so you'll have to use server side tracing.

  • May 14, 2015 at 10:28 am

    #1797932

    Thanks for jumping in so quickly ! My question is what kind of task can I do in the source server to test the connection?

  • May 14, 2015 at 11:20 am

    #1797938

    oh sorry! you can try and set up linked servers from the remote sql instances to make sure you can connect successfully. then query the instance through those linked servers.

  • May 14, 2015 at 12:17 pm

    #1797968

    Thank You !!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply