|
|
|
#1 |
|
Messages: n/a
Hébergeur: |
Hi,
I am running SQL Profiler for one of my server. But when I m giving the server name to connect, i am getting the error as: " 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." Pls . |
|
|
|
#2 |
|
Messages: n/a
Hébergeur: |
"pramodbura" <pramodbura@gmail.com> wrote in message news:3cd108eb-d052-4aea-8513-7a3d911be750@p25g2000hsf.googlegroups.com... > Hi, > I am running SQL Profiler for one of my server. > But when I m giving the server name to connect, i am getting the error > as: > > " 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." > > Pls . Hi It sounds like you don't have the permissions. I assume you are not a sysadmin on this server? You will need to be granted the ALTER TRACE permission to your login e.g GRANT ALTER TRACE TO TEST John |
|
![]() |
| Outils de la discussion | |
|
|