+ -
当前位置:首页 → 问答吧 → 关于service broker远程通信时的安全证书问题

关于service broker远程通信时的安全证书问题

时间:2011-12-21

来源:互联网

在service broker两个实例间的通信时在sys.transmission_queue表中提示我

Connection handshake failed. The certificate used by the peer is invalid due to the following reason: Certificate not found. State 89.

这是什么原因呀?我也创建证书了,为什么提示我未找到呀

作者: liulmz123321   发布时间: 2011-12-21

------启用传输安全-------
USE master
GO
CREATE MASTER KEY ENCRYPTION BY PASSWORD = '1294934A!'


CREATE CERTIFICATE TestStart1
WITH SUBJECT = 'Test Start Number1',
EXPIRY_DATE = '5/4/2012'
GO


BACKUP CERTIFICATE TestStart1
TO FILE = 'F:\SqlBackup\TestStart1.cer'
GO


CREATE ENDPOINT TestStart1_Broker
STATE = STARTED
AS TCP
(LISTENER_PORT = 4020)
FOR SERVICE_BROKER
(AUTHENTICATION = CERTIFICATE TestStart1,
ENCRYPTION = REQUIRED)
GO


CREATE LOGIN TestStartLogin
WITH PASSWORD = 'TestStart'
GO
CREATE USER TestStartUser
FOR LOGIN TestStartLogin
GO

GRANT CONNECT ON Endpoint::TestStart1_Broker TO TestStartLogin
GO



-------对话安全------
USE TestStart
GO
CREATE MASTER KEY ENCRYPTION BY PASSWORD = '1294934A!'
GO

CREATE CERTIFICATE TestStartCert
WITH SUBJECT = 'TestStart cert',
EXPIRY_DATE = '5/4/2012'
GO

USE TestStart
GO
BACKUP CERTIFICATE TestStartCert
TO FILE = 'F:\SqlBackup\TestStartCert.cer'
GO



USE TestStart
GO
CREATE USER TestStartUser
WITHOUT LOGIN
GO

------导入-----
USE TestStart
GO
CREATE CERTIFICATE TestEndCert
AUTHORIZATION TestStartUser
FROM FILE = 'F:\SqlBackup\TestEndCert.cer'
GO


USE TestStart
GO
GRANT SEND ON
SERVICE::[//MessageBook/BrokerStartService]
TO TestStartUser

作者: liulmz123321   发布时间: 2011-12-21