在设置镜象时,我执行以下的语句提示错误:CREATE ENDPOINT [Mirroring] AS TCP (LISTENER_PORT = 5022)FOR DATABASE_MIRRORING (ROLE = PARTNER, ENCRYPTION = ENABLED);错误提示:
消息 102,级别 15,状态 1,第 5 行
'ENABLED' 附近有语法错误。但是我使用这个语句:CREATE ENDPOINT [Mirroring] AS TCP (LISTENER_PORT = 5022)FOR DATABASE_MIRRORING (ROLE = PARTNER, ENCRYPTION = SUPPORTED);
就没有错误,请问这个两个的区别,和为什么第一个语句提示问题,该怎么解决?
消息 102,级别 15,状态 1,第 5 行
'ENABLED' 附近有语法错误。但是我使用这个语句:CREATE ENDPOINT [Mirroring] AS TCP (LISTENER_PORT = 5022)FOR DATABASE_MIRRORING (ROLE = PARTNER, ENCRYPTION = SUPPORTED);
就没有错误,请问这个两个的区别,和为什么第一个语句提示问题,该怎么解决?
FOR DATABASE_MIRRORING (
[ AUTHENTICATION = {
WINDOWS [ { NTLM | KERBEROS | NEGOTIATE } ]
| CERTIFICATE certificate_name
| WINDOWS [ { NTLM | KERBEROS | NEGOTIATE } ] CERTIFICATE certificate_name
| CERTIFICATE certificate_name WINDOWS [ { NTLM | KERBEROS | NEGOTIATE } ]
[ [ [ , ] ] ENCRYPTION = { DISABLED | { { SUPPORTED | REQUIRED }
[ ALGORITHM { RC4 | AES | AES RC4 | RC4 AES } ] } ]
[ , ] ROLE = { WITNESS | PARTNER | ALL }
)