在远程服务器上使用分析器 [英] Using profiler on a remote server

问题描述

大家好，

我们的办公室域有一个专用的SQL服务器，允许远程连接到域终端 - 我可以通过管理工作室成功连接到sql实例。但是，当尝试在远程SQL实例上运行sql server profiler时，它会抛出
身份验证错误。有人能指出我如何配置远程分析的正确方向吗？

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?

谢谢，

最大。

推荐答案

首先，这个新闻组是针对SQL Studio的，这是一个代号为Juneau的新工具，微软已经宣布，但尚未公开发布。

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

至于您的问题，使用Profiler连接到远程服务器没有什么特别之处。这与连接SSMS或SQLCMD没有什么不同。但是，为了能够运行跟踪，您需要在服务器上至少具有ALTER TRACE权限。

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.

这篇关于在远程服务器上使用分析器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！