When I will implement database mirroring in 2 different server then what are the things I have to mention in service accounts? There are 2 options one is principle & another one is mirroring. Whether i have to put server name or anything else just clear this part. Thanks.
Need to look into the logs to understand the issue. But just a couple of generic checks, make sure both principal and mirror are on the same build/version. Please check the algorithm you're using and make sure it's AES but not RC4 algorithm.
Thank you Mr. Chandu, Your explanation was fantastic. But My issue is I have 2 different system, in both system have [NT Authority/System] . I have tried the below Script GRANT CONNECT ON ENDPOINT:: MIRRORING to [NT AUTHORITY\SYSTEM] But after if I executing the mirroring Same 1418 error is coming I try to check in sp_readerrorlog 2024-11-28 11:11:52.060 Logon Database Mirroring login attempt by user 'NT AUTHORITY\ANONYMOUS LOGON.' failed with error: 'Connection handshake failed. The login 'NT AUTHORITY\ANONYMOUS LOGON' does not have CONNECT permission on the endpoint. State 84.'. [CLIENT: 172.16.29.110] NT AUTHORITY\ANONYMOUS LOGON Can you please guide me where I have to fix this issue.
Hi Guys It Worked. But i cannot Open the Mirrored Database after the mirroring process. it Says The database TestMirror is not accessible. (ObjectExplorer) any Solutions?
What do you mean "you cannot open the mirrored database", you cannot access the mirrored database because it's always in restoring state. You can access only the principal.
What's the SQL version? Please check if you've any pending logs to be restored. It's not an error or issue, if the LSN should be in sync with the primary. Make sure that no log backup jobs running on primary while configuring mirroring. Restore necessary logs and then configure.
Principle Server: SQL 2017 Developer Edition Mirror Server: SQL 2019 Developer Edition. Took one Full & one Transaction log backups from Principle Server, same Restored in Mirror server. Then configured. Observed 927 error.
Please share the error message and check if any logs pending to restore. To isolate the issue, you can create a test database and try to configure. **Make sure that database mirroring endpoint encryption algorithm configured with AES but not RC4.
well explained each small thing in the video. Awesome sir.
Thanks very good explanation
Nice video thank you for giving end to end clarification
THANK YOU SO MUCH ANNA 😍🥰
Nice vídeo, ty
Hi Chandu, Do you provide DBA Training
Suggested to upload more videos and share knowledge replications, migration, performance issues etc.,
Sure, thanks for the feedback
When I will implement database mirroring in 2 different server then what are the things I have to mention in service accounts? There are 2 options one is principle & another one is mirroring. Whether i have to put server name or anything else just clear this part. Thanks.
Service accounts should be domain accounts.
After successful synchronized, secondary database shown restoring mode. How do I get back in normal mode with synchroinized?
Need to look into the logs to understand the issue. But just a couple of generic checks, make sure both principal and mirror are on the same build/version. Please check the algorithm you're using and make sure it's AES but not RC4 algorithm.
Thank you Mr. Chandu, Your explanation was fantastic. But My issue is I have 2 different system, in both system have [NT Authority/System] . I have tried the below Script
GRANT CONNECT ON ENDPOINT:: MIRRORING to [NT AUTHORITY\SYSTEM]
But after if I executing the mirroring
Same 1418 error is coming
I try to check in sp_readerrorlog
2024-11-28 11:11:52.060 Logon Database Mirroring login attempt by user 'NT AUTHORITY\ANONYMOUS LOGON.' failed with error: 'Connection handshake failed. The login 'NT AUTHORITY\ANONYMOUS LOGON' does not have CONNECT permission on the endpoint. State 84.'. [CLIENT: 172.16.29.110]
NT AUTHORITY\ANONYMOUS LOGON
Can you please guide me where I have to fix this issue.
Hi Guys It Worked.
But i cannot Open the Mirrored Database after the mirroring process.
it Says
The database TestMirror is not accessible. (ObjectExplorer)
any Solutions?
What do you mean "you cannot open the mirrored database", you cannot access the mirrored database because it's always in restoring state. You can access only the principal.
Please show how to configure on domain server
You mean to configure database mirroring on cluster environment?
How to troubleshoot 927 error in Database Mirroring ?
What's the SQL version? Please check if you've any pending logs to be restored. It's not an error or issue, if the LSN should be in sync with the primary. Make sure that no log backup jobs running on primary while configuring mirroring. Restore necessary logs and then configure.
Principle Server: SQL 2017 Developer Edition
Mirror Server: SQL 2019 Developer Edition.
Took one Full & one Transaction log backups from Principle Server, same Restored in Mirror server. Then configured. Observed 927 error.
Please share the error message and check if any logs pending to restore. To isolate the issue, you can create a test database and try to configure. **Make sure that database mirroring endpoint encryption algorithm configured with AES but not RC4.