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 running under the same Domain-Account. (Also the Agents!)
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
No comments:
Post a Comment