Wednesday, March 28, 2012

Multi Server Administration (Error Enlist MSX)

With Sql-Server 2000 i am using since a long time the jobserver (MSX) with TSX-servers.

Now I installed Sql-Server 2005 Standard Edition (the same i have tested with developer edition) on NT-2003 SP1.

I have 2 Sql-Server instances installed.

Now i tryed to configure one instance as MSX-Server and the other one as TSX-Server.

No Chance. When i do it with Management-Studio the following error ist displayed:
The enlist operation failed (reason:SqlServerAgent Error: Unable to connect to 'MSX HG-ALV-012\I1'). (Microsoft Sql Server,Error:22026).

In the Agent-log i found after every try the following error-messages:

Date 06.12.2005 17:29:42
Log SQL Agent (Current - 06.12.2005 17:29:00)

Message
[298] SQLServer Error: 805, SSL Provider: Die Zertifikatkette wurde von einer nicht vertrauenswürdigen Zertifizierungsstelle ausgestellt. [SQLSTATE 08001]

[298] SQLServer Error: 805, Client unable to establish connection [SQLSTATE 08001]

Message in Eventlog:
Date 06.12.2005 17:29:42
Log Windows NT (System)

Source Schannel
Category (0)
Event 3221262354
Computer HG-ALV-012

Message
Das vom Remoteserver erhaltene Zertifikat wurde von einer nicht vertrauenswürdigen Zertifizierungsstelle
ausgestellt. Aus diesem Grund k?nnen keine der im Zertifikat enthalten Daten verifiziert werden. Die
SSL-Verbindungsanforderung ist fehlgeschlagen. Die angeh?ngten Daten enthalten das Serverzertifikat.
I don't know what this has to do with certificates? The Configuration for the connections on the server (tcp) is definitely set to "ForceEncrypten=No".

Both Sql Server instances are ruTongue TiedTongue Tiednning under the same Domain-Account. (Also the Agents!)Tongue Tied

Has anyone an idea how to solve that problem?

There is a good Webcast exactly on this topic recorded at Dec 15 2005.
Theme: Upgrading SQL Server Agent to SQL Server 2000.

EventID is 1032285816

Look at http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032285816&EventCategory=5&culture=en-US&CountryCode=US

Regards

Ralph Kemperdick

sql

No comments:

Post a Comment