Perfmon无法在SQL Server 2008上连接 [英] Perfmon can´t connect on SQL Server 2008
问题描述
嘿伙计们,
我是2天寻找并回答我的问题:
I am 2 days looking for and answer for my problem:
我正在尝试从服务器上记录一些来自ASP的计数器≻ s≻在另一个域中,不受信任(前端),甚至我在可信域中的服务器上尝试过,我可以直接将perfmon登录到SQL Server 2008.我收到了这个错误:
I am trying to log some counter from ASP from a Server that´s it´s in another Domain, not trusted (front end), even i tried in a server in a trusted domain, i can´t log perfmon directly to a SQL Server 2008. I got this error:
--------- -------------------------
日志名称:   申请
来源:     Microsoft-Windows-PDH
日期:       16/02/2011 10:07:38
事件ID:   3041
任务类别:无
级别:      错误
关键字:   经典
用户:       N / A
电脑:   xpto.domain
说明:
使用[Microsoft]调用SQLAllocConnect失败] [SQL Server Native Client 10.0] [SQL Server]登录失败,用户''
事件Xml:
<事件xmlns =" http://schemas.microsoft.com/win/2004/08/events/event">
< System>
< Provider Name =" Microsoft-Windows-PDH" GUID = QUOT; {04D66358-C4A1-419B-8023-23B73902DE2C}" EventSourceName = QUOT; PDH" />
< EventID Qualifiers =" 49152"> 3041< / EventID>
< Version> 0< / Version>
< Level> 2< / Level>
< Task> 0< / Task>
<操作码> 0< /操作码>
< Keywords> 0x80000000000000< / Keywords>
< TimeCreated SystemTime =" 2011-02-16T12:07:38.000000000Z" />
< EventRecordID> 31375< / EventRecordID>
< Correlation />
< Execution ProcessID =" 0"线程ID = QUOT; 0" />
< Channel> Application< / Channel>
< Computer> xpto.domain< / Computer>
< Security />
< / System>
< EventData>
< Data> [Microsoft] [SQL Server Native Client 10.0] [SQL Server]用户''登录失败。< / Data>
&NBSP;&NBSP; < Binary> 1848< / Binary>
< / EventData>
< / Event>
--------------
我尝试使用Windows中的Native SQL Client或SQL Server Native Client 10.0,我得到了同样的错误。
I tried with Native SQL Client from windows or with the SQL Server Native Client 10.0, i got the same error.
POP UP中显示的其他消息它:
Other message tha shows in a POP UP its:
"尝试启动数据收集器时设置以下系统错误:
使用%1调用SQLAllocConnect失败。"
所以我尝试了一切,包括Domain Admins用户,本地用户,用户来自SQL。
So i tried everything, with Domain Admins User, With local user, with User from SQL.
My SQL it´ s Mixed Authentication。
My SQL it´s Mixed Authentication.
我的信息:
FRONT END SERVER:WINDOWS 2008 SERVER R2。 (此处为Perfmon) - DMZ
FRONT END SERVER: WINDOWS 2008 SERVER R2. (Perfmon here) - DMZ
BACK END SERVER:WINDOWS 2008 SERVER。 (此处为Perfmon) - INSIDE
BACK END SERVER: WINDOWS 2008 SERVER. (Perfmon here) - INSIDE
SQL SERVER:带有SQL SERVER 2008的WINDOWS 2008服务器。(此处为SQL数据库) - INSIDE
SQL SERVER: WINDOWS 2008 SERVER with SQL SERVER 2008. (SQL Database Here) - INSIDE
我需要帮助,而且急!非常感谢!
I Need help, and urgency!! Thanks a lot!
推荐答案
我遇到了类似的错误。 发现在运行的perfmon上的hosts文件中有一个SQL Server 2008服务器条目。 当我删除条目时,错误消失了。
I was getting similar errors. Found there was an entry for the SQL Server 2008 server in the hosts file on the running perfmon. Errors went away when I removed entry.
这篇关于Perfmon无法在SQL Server 2008上连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!