如果想使用SQL 2005作为RMS的Database,或许需要一些方法来达到这样的目的.当你尝试在SQL 2005上存储RMS数据库时,客户端的访问会有类似这样的错误:
:
“联系受限权限服务时出现问题。”
查看IIS Log,还可以发现这样的信息:
记录为500错误:2006-06-06 9:22:32 W3SVC1 10.0.0.20 POST /_wmcs/Certification/Certification.asmx - 80 RMSVR/Administrator Windows+Rights+Management+Client 500 0 0
检查RMS服务器,在应用程序中有类似这样的错误:
事件类型: 错误
事件来源: RMS
事件种类: Certification
事件 ID: 9
日期: 2006-6-6
事件: 10:05:11
用户: N/A
计算机: RMSVR
描述:
A general error occurred. The following information was reported: System.Data.SqlClient.SqlException: 替代参数 1 的数据类型与指定格式应具有的类型不匹配。
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.DigitalRightsManagement.Certification.CertificationGen._GetUser(Identification identification)
at Microsoft.DigitalRightsManagement.Certification.CertificationGen._GetUserKeysAndCertificateWithQuota(String userName, Identification identification, DateTime passportAccountCreation, Byte[] machinePublicKeyHash, Boolean persistent, RsaKeyBlob& userKeys, PersonaCertificate& certificate, QuotaResponse& quota)
at Microsoft.DigitalRightsManagement.Certification.CertificationGen.Certify(String userName, Identification identification, String machineCertificate, DateTime passportAccountCreation, Boolean persistent)
at Microsoft.DigitalRightsManagement.Certification.Pipeline.Certify(CaType caType, CertifyParams[] requestParams, HttpRequest request, IIdentity userIdentity)
有关更多信息,请参阅在 http://go.microsoft.com/fwlink/events.asp 的帮助和支持中心。
数据:
0000: 7b 36 31 30 63 64 31 35 {610cd15
0008: 34 2d 30 65 30 65 2d 34 4-0e0e-4
0010: 35 62 35 2d 61 63 38 65 5b5-ac8e
0018: 2d 35 31 37 39 63 66 39 -5179cf9
0020: 36 39 37 38 39 7d 2e 32 69789}.2
如果你也碰到这要的事情,或许这些SQL Script可以帮你:
use master
go
go
exec sp_addmessage 60000, 5, 'Unexpected activation error', 'us_english', false, 'REPLACE'
go
exec sp_addmessage 60001, 5, 'Bad parameter %s in procedure %s', 'us_english', false, 'REPLACE'
go
exec sp_addmessage 60002, 5, 'User %s not found', 'us_english', false, 'REPLACE'
go
exec sp_addmessage 60003, 5, 'Machine quota, %d, for user %d exceeded', 'us_english', false, 'REPLACE'
go
go