I'm trying to configuring the SQL mirroring on SQL2017 in work group servers. All ports are enabled and both the servers are communicating each others. i have restored the .bak and .trn file on mirror instance then try to configure mirror from principal server it's throwing an error 927.
Even i tried to configure with command based then it's showing as below
Msg 1418, Level 16, State 1, Line 2
The server network address "TCP://172.16.2.9: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.
Even i add the host names in host file for name resolution but no luck. all the service are running on same account with full admin privileges, Firewall is turned off, ports were opened on both servers 1433,5022,5023.
Both SQL server username and password is same on both sql and windows servers.
Please help me on this.