Adding Windows account to SQL Server

Question

Hi Friends,

I need to add the window controllerservices account to the SQL server and give it right to start and stop trace. Can some body please let me know how can this be done. I would really appreciate it.

Thanks

Answer 1

CREATE LOGIN [domain\account] FROM WINDOWS;
GRANT ALTER TRACE TO [domain\account];

Answer 2

Hi Remus,

Can you please let me know what should be the domain here.

Thanks,