May 11, 2018 at 8:56 am
I am trying to setup a mirrored database. The database is identical on both servers.
ServerA is the primary, and ServerB is the mirror. I am logged into ServerA with an account having full administrative access to both servers and both SQL instances.
When I go through the mirror wizard, it lets me setup the connections; however when I try to start mirroring I am getting the following error:
The server network address "TCP://ServerA.mydomain.com:5022" can not be reached or does not exist.
When I look in the SQL logs on ServerB I am seeing Error: 1443, Severity: 16, State: 2. which simply states that mirroring has been terminated. I don't see any errors or other messages related to mirroring on ServerA.
So it seems like the primary is reaching out successfully to the secondary; but the secondary is not able to talk back.
I've verified that the firewall settings on both servers are essentially wide open; they shouldn't be blocking anything on the local network.
Any ideas or suggestions would be appreciated... It's been years since I mucked around with mirroring but when I did, I never had these kinds of problems getting it working 😀
May 11, 2018 at 11:25 am
cphite - Friday, May 11, 2018 8:56 AMI am trying to setup a mirrored database. The database is identical on both servers.ServerA is the primary, and ServerB is the mirror. I am logged into ServerA with an account having full administrative access to both servers and both SQL instances.
When I go through the mirror wizard, it lets me setup the connections; however when I try to start mirroring I am getting the following error:
The server network address "TCP://ServerA.mydomain.com:5022" can not be reached or does not exist.
When I look in the SQL logs on ServerB I am seeing Error: 1443, Severity: 16, State: 2. which simply states that mirroring has been terminated. I don't see any errors or other messages related to mirroring on ServerA.
So it seems like the primary is reaching out successfully to the secondary; but the secondary is not able to talk back.
I've verified that the firewall settings on both servers are essentially wide open; they shouldn't be blocking anything on the local network.
Any ideas or suggestions would be appreciated... It's been years since I mucked around with mirroring but when I did, I never had these kinds of problems getting it working 😀
You could try running through the troubleshooting article for Mirroring. I'd probably check the endpoints first - refer to that section:
Troubleshoot Database Mirroring Configuration (SQL Server)
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply