Yesterday, I wanted to use SQL Server Profiler to check what was happening on the database side of an application I am developping. However, SQL Srever Profiler was giving me the following error message:

In order to run a trace against SQL Server you must be a member of sysadmin fixed server role or have the ALTER TRACE permission.

In order to resolve this, you need to issue the following SLQ query in the master database:

GRANT ALTER TRACE TO username

Replace username by the username you want to use to access the database in SQL Server Profiler.

Leave a Reply

Your email address will not be published. Required fields are marked *