locked
Error 1418 RRS feed

Answers

All replies

  • Have you checked your endpoint configuration and if they are started?

    You can get information by running this:

    SELECT * FROM sys.database_mirroring_endpoints;
    
    Wednesday, March 24, 2010 8:05 PM
  • I have. The state is 0 and state_desc is STARTED on both servers. Here is the result

    name endpoint_id principal_id protocol protocol_desc type type_desc state state_desc is_admin_endpoint role role_desc is_encryption_enabled connection_auth connection_auth_desc certificate_id encryption_algorithm encryption_algorithm_desc
    Mirroring 65536 267 2 TCP 4 DATABASE_MIRRORING 0 STARTED 0 1 PARTNER 1 3 NEGOTIATE 0 1 RC4

     

    name endpoint_id principal_id protocol protocol_desc type type_desc state state_desc is_admin_endpoint role role_desc is_encryption_enabled connection_auth connection_auth_desc certificate_id encryption_algorithm encryption_algorithm_desc
    Mirroring 65536 273 2 TCP 4 DATABASE_MIRRORING 0 STARTED 0 1 PARTNER 1 3 NEGOTIATE 0 1 RC4


    Abdallah El-Chal, PMP, ITIL, MCTS
    Wednesday, March 24, 2010 8:15 PM
  • Here is a good doc to follow when troubleshooting a 2008 mirror setup:

    http://msdn.microsoft.com/en-us/library/ms189127.aspx

     

    Here is a kb for the specific error you are seeing; it is also referenced in the article above:

    http://msdn.microsoft.com/en-us/library/aa337361.aspx

     

    I would start with a telnet from one machine to the other using port 5022.  I know you added the port in your firewall, but that's really the first item to be checked off the list.

     

     

     

    Wednesday, March 24, 2010 9:30 PM