SQL Server 2008????????????
?????????κ? ???????[ 2016/7/28 11:13:15 ] ????????????? SQL Server
??????????????????????
????1??????????????? ????汾???У???????治?????
????2???????????????????????????鱸??
????3??????????????????????? ???????????????????????????????????????????????????????? ??????????????????????????????????????????鵼?????????
??????????????
????1???????????????????????????????????????
????--?????????
????use master
????CREATE MASTER KEY ENCRYPTION BY PASSWORD ='?????'
????go
????2????????????? ??????
--???????
CREATE CERTIFICATE Cret_test
with SUBJECT = 'Certificate test'
GO
--???????????
BACKUP CERTIFICATE Cret_test
TO FILE=N'D:Cret_test.cer'
WITH PRIVATE KEY
(
FILE =N'D:Cret_test.pvk'??
ENCRYPTION BY PASSWORD='??'
)
GO
????3???????????????
--?????????
USE jiami
GO
CREATE DATABASE ENCRYPTION KEY
WITH ALGORITHM = AES_256
ENCRYPTION BY SERVER CERTIFICATE Cret_test
GO
--???????
ALTER DATABASE jiami
SET ENCRYPTION ON
GO
?????????????????????????
????1????????????????
?????????ú????????????
????USE master
????GO
????CREATE MASTER KEY ENCRYPTION BY PASSWORD = '?????'
????2?????????????
USE master
GO
CREATE CERTIFICATE Cret_test
FROM FILE=N'd:Cret_test.cer'
WITH PRIVATE KEY
(
FILE=N'd:Cret_test.pvk'??
DECRYPTION BY PASSWORD=N'??‘
)
GO
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11