SQL error 1418 while trying to mirror with 2 vms
-
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.
TS_IT
All Replies
-
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.
TS_IT -
Tuesday, July 01, 2008 12:02 PM
Hello,
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?
http://alan328.com/SQL2005_Database_Mirroring_Tutorial.aspx
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.
http://forums.microsoft.com/TechNet/default.aspx?ForumGroupID=93&SiteID=17
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
.png)
