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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics