question

thrishank avatar image
thrishank asked

Required help on SQL mirroring on SQL2017 workgroup servers

Hi Team,

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.

-Thrishank K

sql-serverdbamirroringsql server 2017sql server 2016
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.

0 Answers

· Write an Answer

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.