Le procedure nel database del gesatt sono cryptate sia per ORION che per il nostro gesatt … per modificarle :

programma usato -> DBFORGE SQL DECRYPTOR FREE

Select ISNull(Convert(nVarchar(MAX),DecryptByPassPhrase(‘DTL’,SECSCOM)), N”) From gpa_se Where SVID=1 And ENID=2

SELECT ENCRYPTBYPASSPHRASE(N’DTL’, N’Password=manager;Persist Security Info=True;User ID=sa;Initial Catalog=_WTO_ORION_COM;Data Source=orivm-sboif01′)

update dbo.gpa_se set SECSCOM = 0x01000000A9E8B5128F033EE4D1F08616277908ED7C56DEDDCCF0A6BDC7C1F4024A84EFE990C45EEECB2535A1DDE768C974127535B13454411221D8FAFB323ED77DD58D2D865566D1E3B20DB2BBF65F92B701333DAE1C45487A0F3E2486A9DC7385777102A43BC5C53F6D753F89FBA9DA508F743072C9BEAEBA309F9ADF6E31D608614503C0037EA480B98B31DD7C4EC64151AB0B51DF8586EE0D2E9D024387BED58DFB6C1FD149C994ECDD955F8F2AB98D022D91D10BF1DE27F105835CB7170746793C4283D11DC2722B13582209BACFFFAFB38BDCBA15BC5E4F21593BD5A1F6143719FDF605E557202F1EC25A210A034EC6C1FC where ENID=2

SELECT SECSCOM, CONVERT(NVARCHAR(MAX), DECRYPTBYPASSPHRASE(N’DTL’, SECS))
FROM dbo.gpa_se

ESEMPIO:
ENID1
Password=manager;Persist Security Info=True;User ID=sa;Initial Catalog=_WTO_ORION_Azi;Data Source=orivm-sboif01
secs= 0x010000009FB4EBF9753580D6C37235393BD7751D6F604D890D4B0216
Password=manager;Persist Security Info=True;User ID=sa;Initial Catalog=_WTO_ORION_COM;Data Source=orivm-sboif01
secscom= 0x0100000079A14C826FA313B6CC53AA15EF03CCD89179532F07EAEEE1