Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 giving profiler access to SSAS server

Author  Topic 

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2011-09-28 : 02:56:11
Hi,

Hi have 2005 SSAS server, i need to give a user to run the profiler, how do we give this access. ?

Thanks,
Gangadhara MS
SQL Developer and DBA

DBA in the making
Aged Yak Warrior

638 Posts

Posted - 2011-09-28 : 08:16:57
You need to be a sysAdmin to run profiler, but I'd be very careful about doing that.

------------------------------------------------------------------------------------
Any and all code contained within this post comes with a 100% money back guarantee.
Go to Top of Page

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2011-09-28 : 13:42:31
check this: http://www.sql-server-performance.com/2009/how-to-run-sql-profiler-without-sysadmin-rights/
Go to Top of Page
   

- Advertisement -