SQL Server Profiler is started from either the Microsoft® Windows NT® or Windows® 95/98 Start menu or SQL Server Enterprise Manager. When SQL Server Profiler is started, it does not automatically monitor any events until a trace definition is created (or imported from a trace definition file) and started.
SQL Server Profiler can connect to Microsoft SQL Server™ using either Windows NT Authentication Mode or SQL Server Authentication. When Windows NT Authentication Mode is used to connect to SQL Server, the user account that is used to run SQL Server Profiler must be granted permission to connect to SQL Server. The login account must also be granted permissions to execute SQL Server Profiler extended stored procedures. For more information, see System Stored Procedures.
Important When using a shared memory network library, SQL Server does not support impersonation unless SQL Server Profiler is connected using Windows NT Authentication.
To start SQL Server Profiler