Post reply

sql server profiler not running when clicking from tools in sql server management studio in sql server 2012

  • February 6, 2014 at 7:10 am

    #283285

    Hi. I had sql server management studio for sql server 2012 installed on my pc when I started at this company a year ago, but the sql server profiler was gray under tools in SSMS.

    I then installed the full tools, and the profiler is no longer grayed out, but it doesn't run when I click on it.

    Could this be an issue with PATH/libraries, or some other issue?

    Is there a logfile I can look in to see what errors the profiler is getting?

    If so, where is the file located?

    Thanks very much for any suggestions or help.

    I'm sorry, but being a newbie, I had posted this to another forum, sql server 7/sql server 2000, two days ago, and don't know how to delete it from there.

  • February 6, 2014 at 8:13 am

    #1686626

    Verify that you have the executable (Profiler.exe) in your binn directory: "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn". If not you may need to reinstall the tools.

    This also could be a good time to learn Extended Events 😉


    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • February 6, 2014 at 8:21 am

    #1686630

    Thanks Keith. Will try to reinstall. Only profiler file is the XML config file.

    Regards,

    Richard

  • February 6, 2014 at 12:52 pm

    #1686730

    Re-installing the tools worked. Thanks, Keith.

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

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