SQL Profiler Error . Need Help ?

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"

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Well yes...

by Tony Hopkinson In reply to SQL Profiler Error . Need ...

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.

Related Discussions

Related Forums