Hi @Piseth Ben ,
This error happens when the server network endpoint did not respond because the specified server network cannot be reached or it does not exist. You could check the following items once:
- Goto services.msc and check the sql server is running under which account. Make sure that sql server and sql server agent services should run with same credentials.
- in the mirror database server you should do the same step as step 1. Give the same credentials as in principal server. If that user is not present create a new one on the both servers with same credentials.
- Now got principal server and in sql server add the new login under Security-->Login. Give the server roles as Sysadmin and public. Add the same user on the mirror server also.
- Now do the mirror in the principal database. You did not get any error there.
Please refer to How to resolve Error: 1418 in sql server while mirroring to get more details.
Best regards,
Carrin
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.