Tuesday, 30 June 2015

in order to run trace against sql server you must be a member of sysadmin



Solution:
Provide ALTER TRACE permission for the particular user

USE master
GO
GRANT ALTER TRACE TO user1
GO

After your work you can REVOKE the access

USE master
GO
REVOKE ALTER TRACE FROM user1
GO


Another way to grant rights, login with sysadmin login then open SSMS
~~ Open Security then Logins
~~ Right click on the login name and click Properties
~~ Securables tab
~~ Click Search to Select the instance that required permissions
~~ Under Explicit tab
~~ Select the check box ALTER trace permission and Click OK.