Newbie to Toad - Session Permission Error

Toad for SQL Server
1

Hello all,

I just downloaded Toad For SQL Server on to my server and created a new account/user on SQL Server to work with.

But when I try to trace sessions, I get permission denied.

I have given it the following:

GRANT ALTER TRACE TO xxxxx;
GRANT SELECT ON SYS.TRACES TO xxxxx;

what else is required so I can conduct a session trace?

TIA…Q

2

no one knows?

3

Hi,

Sorry for reply you so late. Would you like try to use sys.sp_addsrvrolemember to add role member processadmin?

Best Regards,

Kelly

4

Worked perfectly. Thank you.