|
Home > Archive > Application Center Administration > February 2004 > "failed to authenticate, or connect to, SQL Server" message
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
"failed to authenticate, or connect to, SQL Server" message
|
|
|
| 12/30/2003 8:29:08 AM APP-xxx-x 8015
Application Center
Source: Monitoring Logging
Log query SELECT TOP 40 * FROM EventView WHERE Log
= 'Application Center' AND Severity <= 2 AND (Category =
N'Replication' AND Data LIKE N'%ReplicationID=CMSAuth;%')
ORDER BY TimeGenerated DESC, ID DESC failed to execute
using the connection string Provider=SQLOLEDB;Integrated
Security=SSPI;Data Source=167.x.x.x\MSAC;Initial
Catalog=ACLog. Status is 0xc0140060 Failed to
authenticate, or connect to, SQL Server.
Why can't my cluster controller authenticate to a member
of the cluster to read the MSAC MSDE instance? I've tried
the suggestions mentioned in the MS KB, but they didn't
help.
| |
| George Cheng [MSFT] 2004-02-08, 8:44 am |
| Are all your sql services started? Is this a SP2 install?
May be easiest to uninstall / reinstall AC2K since that rebuilds MSDE.
Thank You
George Cheng
Microsoft Application Center/Index Server/Site Server Search Support
Note: This article has no warranties implicit or explicit.
All the content is given on the "as is" basis and the user
takes full responsibility for its use and assumption.
Microsoft Corporation Copyright 2003
All Rights Reserved
--
--------------------
| Content-Class: urn:content-classes:message
| From: "Chris" <anonymous@discussions.microsoft.com>
| Sender: "Chris" <anonymous@discussions.microsoft.com>
| Subject: "failed to authenticate, or connect to, SQL Server" message
| Date: Tue, 30 Dec 2003 05:44:22 -0800
| Lines: 23
| Message-ID: <09a101c3cedb$07ff08e0$a301280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcPO2wf/n2JJrrfMTf2NOG+ojYFhjQ==
| Newsgroups: microsoft.public.applicationcenter.admin
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.applicationcenter.admin:4734
| NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
| X-Tomcat-NG: microsoft.public.applicationcenter.admin
|
| 12/30/2003 8:29:08 AM APP-xxx-x 8015
|
| Application Center
| Source: Monitoring Logging
|
|
| Log query SELECT TOP 40 * FROM EventView WHERE Log
| = 'Application Center' AND Severity <= 2 AND (Category =
| N'Replication' AND Data LIKE N'%ReplicationID=CMSAuth;%')
| ORDER BY TimeGenerated DESC, ID DESC failed to execute
| using the connection string Provider=SQLOLEDB;Integrated
| Security=SSPI;Data Source=167.x.x.x\MSAC;Initial
| Catalog=ACLog. Status is 0xc0140060 Failed to
| authenticate, or connect to, SQL Server.
|
|
| Why can't my cluster controller authenticate to a member
| of the cluster to read the MSAC MSDE instance? I've tried
| the suggestions mentioned in the MS KB, but they didn't
| help.
|
|
|
|
|
|
|
|
|