ERROR While Connecting to Mirror DB

Question

Dear all,
 
This is george, am new to this forum. I am submitting the error while trying DB MIRRORING. kindly help me with your suggestions.

When i am try to Create a Mirroring Session, the following is the error message, i am getting.

I really followed Mr.Kelo's instructions to create End Points and Started and Setting up Listenig port, But while giving the following command i am getting the error like below.

Query Executed on Principal Server:

ALTER

DATABASE DB_MIRROR

SET

PARTNER ='TCP://EAPL:5023'

where DB_MIRROR = Database Name;  EAPL=Machine Name

THE ERROR MESSAGE I AM GETTING IS,


Msg 1418, Level 16, State 1, Line 1

The server network address "TCP://EAPL:5023" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.

I dont know where will be the problem, I have tried with UI also. I am getting same error. Kindly tell me How to check the Network addressname and Ports for Local and remote endpoints are operational.

Kindly help me in this issue,

Thanks and Regards,

x.george

Answer 1

Are both the sql server involved in SQL mirroring run under a DOMAIN account ?
If not , have you given CONNECT rights to the logins for connecting at DB mirror endpoint.

---

Thanks, Leks

Answer 2

Hi,
Do you grant the connect permission on the endpoint to the login user? To allow database mirroring Network access using Windows Authentication, please refer to the following document:
http://msdn.microsoft.com/en-us/library/ms178029.aspx

Also, ensure that an endpoint exists for each of the server instances. For more information, see How to: Create a Mirroring Endpoint for Windows Authentication (Transact-SQL):
http://msdn.microsoft.com/en-us/library/ms178029.aspx

If there are any more questions, please let me know.
Thanks.

---

***Xiao Min Tan***Microsoft Online Community***

Answer 3

Do you have a firewall (e.g. windows firewall) blocking that port at either end?