[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 813
  • Last Modified:

Error when creating SQL server 2005 Endpoint

Dear all,

Right now I just move all Db from an old DB, which is mirrored before, to a new server.

When I try to create the new mirror relation I find I need to drop the existing master key and recreate.

but when I try to recreate the end point using this script:


CREATE ENDPOINT Endpoint_Mirroring
   STATE = STARTED
   AS TCP (
      LISTENER_PORT=7024
      , LISTENER_IP = ALL
   )
   FOR DATABASE_MIRRORING (
      AUTHENTICATION = CERTIFICATE ccc
      , ENCRYPTION = REQUIRED ALGORITHM AES
      , ROLE = ALL
   );
GO


I get this error:

"The certificate 'ccc' is not valid for endpoint authentication. The certificate must have a private key encrypted with the database master key and current UTC date has to be between the certificate start date and the certificate expiration date.
"

Any reason on this and how to fix this ?

What we need to do is just to recreate the mirror ASAP.

DBA100.
0
marrowyung
Asked:
marrowyung
  • 2
1 Solution
 
marrowyungAuthor Commented:
keyu,

we only need cert. to setup mirror if and only if both primary and DR SQL server don't trust each other ? like the start account of both server is not hte same and not under the same domain ?
0
 
marrowyungAuthor Commented:
We forget about that and we use the wizard to generate the end point and keep all existing first.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now