Thursday, June 09, 2011 1:28 PM
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?
Thursday, June 09, 2011 9:44 PM
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, firstname.lastname@example.org
Friday, June 10, 2011 10:27 AMThanks. For those who are interested, a how-to link is here: http://sivasql.blogspot.com/2008/12/how-to-grant-alter-trace-permission.html
- Proposed As Answer by Sanjay Nagamangalam [MSFT] Friday, July 15, 2011 7:28 PM