Using profiler on a remote server

Question

Hi all,

Our office domain has a dedicated SQL server that allows remote connection to domain terminals - I can connect to the sql instance via management studio successfully. However when trying to run sql server profiler on the remote SQL instance it throws an authentication error. Can somebody point me in the right direction for how to configure remote profiling?

Thanks,

Max.

Answer 1

First, this news group is for SQL Studio, a new tool codename Juneau, which Microsoft has announced, but not yet released publicly.

As for your question, there is nothing special about connecting to a remote server with Profiler. That's no different from connecting with SSMS or SQLCMD. However, to be able to run a trace, you need to have at least ALTER TRACE permission on the server.

---

Erland Sommarskog, SQL Server MVP, [e-mail]

Answer 2

Thanks. For those who are interested, a how-to link is here: http://sivasql.blogspot.com/2008/12/how-to-grant-alter-trace-permission.html