question

zain avatar image
zain asked

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

database-mirroring
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image
sp_lock answered
  1. Do you have windows firewall turned on?

  2. Does the "user" setup up for mirroring have connect permissions?

1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1. fire wall are turnned off . 2. how to add user connect permission GRANT CONNECT ON ENDPOINT::Endpoint_Mirroring TO [Mydomain\dbousername]; GO fails
0 Likes 0 ·
praveen green avatar image
praveen green answered
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!
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.