March 5, 2010 at 5:09 am
hi for database mirroring between two nodes without witness not works and from one node continues give error:
The server network address "TCP://LSS_PC32.domain.INDIA:5022" 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.
how to check this...all pcname, domain name is check by me and found ok.
Thanks in advance
March 5, 2010 at 7:47 am
Might make sure there isn't a firewall blocking that TCP port.
The Redneck DBA
March 5, 2010 at 8:28 am
You also need to be sure to GRANT CONNECT permissions to the endpoints for the service account that SQL Server is running under. Ran into that issue when trying to setup database mirroring in SQL Server 2008.
Edit: This is assuming you, like me, are trying to use NT Authentication. If you are using certificates, I haven'r played with that yet.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply