Database Mirroring Issue Error NO:1418
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
I'm stuck with the same issue. I've tried the things you've mentioned above. But since the login which I'm using as the service account for the mirroring has the role of 'public' and 'sysadmin'. So while executing the Grant Connect query, the system throws error like 'you can't grant, deny or revoke rights to the user which is the member of sysadmins'. So my stomach has started aching via my mind. Please someone help me out on this issue!
