locked
Error:1418 during Mirroring RRS feed

  • Question

  • I am trying to do mirroring using SQL Server Ent. 2005 SP1 on two machines. I was able to create end points on both the machines at the port no.s 5091 and 5092 respectively. I have all the security setting settings for both the users. I am getting error no. 1418 while starting mirroring sessions.
    Can anybody tell me how to troubleshoot this error?
    Wednesday, November 8, 2006 9:38 AM

All replies

  • Google Error 1418, there are helpful pointers

    e.g. check your SQL is listening on TCP, and the correct port

    maybe SQL Browser?

    you pointed to the correct ports?

    Our mirroring works off the box, because I just used the wizard and used the default ports

    Wednesday, November 8, 2006 3:19 PM
  • Wednesday, November 8, 2006 5:35 PM
  • Try editing the C:\WINDOWS\system32\drivers\etc\hosts file on each server to include

                IP address   DNSname                      for each server.

     

    Wednesday, November 8, 2006 7:24 PM