Friday, June 27, 2008 6:48 PM
No matter what I try, I constantly run into a 1418 error, I've check all my tcp/ip configs both in sql, and the server 2003 os, on both vms. I’ve enabled tcp/ip filtering and allowed all connections, I’ve used telnet to connect up. Nothing seems to work. Each server can ping the other, they can telnet into 5022, I don’t know where to proceed from here. Is there some config somewhere or issues with vms that I am not seeing? All the machines in the mirroring array are server 2003, I have the physical machine as the witness, vm1 as the Principal, and vm2 as the Mirror.
Monday, June 30, 2008 7:23 AMModeratorTurn off tcp/ip filtering, turn off firewall and then try to mirror your database again. Check network connectivity between all three servers first. If it works without tcp/ip filtering and firewall you'll need to edit your rulesets.
Technet Forums Moderator | Solution Specialist | Ask The Experts IT-forum
Monday, June 30, 2008 6:18 PMI've tried it before without tcp/ip filtering, the fact it was not working is why I turned it on. Also our domain policies do not allow the firewall to be turned on, and all ports are open, you can scan and detect the ports with a port scanner.
Tuesday, July 01, 2008 12:02 PM
Based on some research, I found that this error message 1418 might not be useful and might even lead the wrong way. Would you please take a look at the following articles to see if they can help?
Additionally, as this issue mainly relates to SQL Server, I would like to suggest that you post this issue in our SQL Server forum if the problem remains. People there have better knowledge on this.
Thank you for your understanding and I hope this helps.
Best regards,Chang Yin
- Marked As Answer by Chang Yin Sunday, July 06, 2008 9:09 AM