Hi,
I m doing sql server database mirroring using two physical server which is on same domain.
prinicpal server -Dipak-Bandgar\SQL1
PORT NO USE FOR ENDPOINT 5022
NETWORK ADDRESS NAME -TCP://DIPAK-BANDGAR.EAT2EAT-SG.COM:5022
MIRROR SERVER - Swati-Pharate\SQL1
PORT NO USE FOR ENDPOINT- 5023
NETWORK ADDRESS NAME -TCP://Swati-Pharate:8080
BOTH SERVER ARE IN SAME DOMAIN
ENDPOINTS CONFIGURED SUCCESSFULLY.
PORT IS ALSO OPENED (CHECKED VIA TELNET)
FIREWALL IS ALSO OFF.
BOTH USER HAVING ACCESS OF ADMIN ACCOUNT.
BOTH SERVER ARE IN LAN
Using sql server enterprise edition 2012
ALTER DATABASE DatabaseName SET PARTNER = N'TCP://PrincipalServer:PortNumber'
This command is working fine on mirror server . but i mgetting same error while running on principal server.
but still m getting error 1418.
please help .
Thanks in advance.