SQL error 1418 while trying to mirror with 2 vms
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. Ive enabled tcp/ip filtering and
allowed all connections, Ive used telnet to connect up. Nothing seems to work. Each server can ping the other, they can
telnet into 5022, I dont 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
June 27th, 2008 9:48pm
Turn 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
Free Windows Admin Tool Kit Click here and download it now
June 30th, 2008 10:23am
I'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
June 30th, 2008 9:18pm
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://blogs.technet.com/josebda/archive/2007/06/11/misleading-error-1418-message-in-sql-server-database-mirroring.aspx
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
Free Windows Admin Tool Kit Click here and download it now
July 1st, 2008 3:02pm