Question

  • Creator
    Topic
  • #2213372

    SQL Profiler Error . Need Help ?

    Locked

    by mtamilmani ·

    When i run my SQL Profiler . I got error message like as ” In order to run a trace against SQL Server you must a member of sysadmin fixed server role or have the ALTER TRACE permission”

All Answers

  • Author
    Replies
    • #2869866

      Clarifications

      by mtamilmani ·

      In reply to SQL Profiler Error . Need Help ?

      Clarifications

    • #2869497

      Well yes…

      by tony hopkinson ·

      In reply to SQL Profiler Error . Need Help ?

      Basically it’s saying you need someone with admin authority to add the user you are logging on to the sql server with that permission.

      If it’s sql server 2005/2008 run up sql server management studio, find the logins, select the one you are using see what roles you’ve been granted. If you don’t have permission/ knowledge to do that you need to talk to your DBA.

Viewing 1 reply thread