i configured mirroring using three different servers
where pricipal server being the standard
mirror server using the standard version
witness can be anything so i am using Enterprise Edition
when i finish the congifuration it says the endpoint are configured but when i say start mirroring it gives the error
" ALTER FAILED FOR DATABASE 'DB' (Microsoft Sql Server . smo) An exception accured while executing a Transact-Sql statement or batch. (microsoft.sqlserver.connectioninfo)
The server network address "TCP://servername.domainname.loc:5022" cannot be reached or does not exist. check the network address name and that the ports for the local and the remote endpoints are operational "microsoft sql server error : 1418
i checked the ports and used alter command as below:
SELECT name, port FROM sys.tcp_endpoints
ALTER ENDPOINT Mirroring FOR DATA_MIRRORING (ROLE = PARTNER, ENCRYPTION = SUPPORTED)
but still nothing goes right i am starving please help me
and i have checked using both windows and sql authentication as well