locked
How to resolve Error: 1418 in sql server while mirroring RRS feed

  • Question

  • Hi  Support,

    I am trying to mirroring a database in sql server. I created a database and took a backup of it and restored on the another instance(i am using same server but with different instances). But after doing all operations and click on start mirroring, then it showing following error.

    The server network address "TCP://indserver.xxxx.local:5022" can not be reached or does not exist. Check the network address name and reissue the command. (Microsoft SQL Server, Error: 1418)

    I followed mirroring steps in this "http://www.codeproject.com/Articles/31325/Step-by-Step-SQL-Mirroring-the-ASPState-Database" Here it says, create an user on both principal and mirror server with the same credentials in STEP 3.So please provide me solution for above error.

    Friday, May 2, 2014 10:04 AM

Answers

  • Hi Pankaj Sharma,

    According to your error message, we need to verify if you backup your database with full recovery model and restore this database to a mirror instance with NORECOVERY option. You need also verify all instances can access every other partner and make sure endpoints are running properly, you have granted the SQL Service Account CONNECT permission to the listener on the other machine.

    If after trying this you are still getting a 1418 error, here's a blog post with a couple of other things to check for:

    http://blogs.msdn.com/grahamk/archive/2008/12/08/database-mirroring-error-1418-troubleshooter.aspx

    Regards,
    Sofiya Li


    Sofiya Li
    TechNet Community Support

    Monday, May 5, 2014 3:51 AM
  • Hi,

    go through the following MicroSoft article.  http://technet.microsoft.com/en-us/library/ms189127.aspx

    Thnaks,

    Rajasekhara Reddy Kondreddy


    Thanks, RajaSekhara Reddy . K

    • Proposed as answer by Sofiya Li Monday, May 5, 2014 3:33 AM
    • Marked as answer by Sofiya Li Friday, May 9, 2014 2:06 AM
    Friday, May 2, 2014 10:55 AM

All replies