Home » Blog » Topic » Getting SQL Server Error 1418. How to Fix?

Getting SQL Server Error 1418. How to Fix?

Lincoln Burrows ~ Modified: May 2nd, 2016 ~ ~ 1 Minute Reading

Home › Forums › Getting SQL Server Error 1418. How to Fix?

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • May 2, 2016 at 1:15 pm #2016 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    Hi all I am getting one problem in mirror configuration that error number is 1418

    Here am try to troubleshoot
    Like am change the all service a/c’s to same

    Port 5022 principal server
    Port 5023 mirror server
    Port 5024 witness server

    But still I am getting this error plz any one help me

    May 3, 2016 at 9:24 am #2020 Score: 0
    Stephen West
    Moderator
    4 pts

    Make sure your firewall is turned off

    May 4, 2016 at 9:55 am #2028 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    I have already checked that all the servers have the same credentials but it still showing the same error.

    May 7, 2016 at 12:59 pm #2050 Score: 0
    Barry Alllen
    Moderator
    25 pts

    Please make sure that the database is restored with NO RECOVERY option on Mirror Server.

    May 11, 2016 at 12:51 pm #2064 Score: 0
    Kerry Morris
    Moderator
    33 pts

    Verify that the endpoints are started on the partners by using the state or state_desc column of the sys.database_mirroring_endpoints catalog view.

    If either endpoint is not started then execute an ALTER ENDPOINT statement to start it.

    May 13, 2016 at 10:48 am #2074 Score: 0
    Andrew Jackson
    Moderator
    1 pt
    • Make sure that your SQL Server port is not blocked by the system Firewall
    • Go to Computer Management >> Service and Application >> SQL Server 2005 Configuration >> Network Configuration

      • Enable TCP/IP protocol.

    For more information: http://www.sqlserverlogexplorer.com/database-mirroring-error-1418/

    May 16, 2016 at 11:19 am #2087 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    Thanks Andrew for this informative blog. The steps mentioned in the blog helped me to resolve my problem.

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.