Sql server 2005 error while mirroring instances between two systems

• ksree76

  SSC Rookie

  Points: 47

  More actions

  May 21, 2008 at 8:33 am

  #191350

  Hi,

  Iam getting an error in the error log when i start mirroring Between two instances from two different systems.

  "Database mirroring connection error 4'An error accoured while receving data'An existing connection was forcibly closed by remote host:

  Error: 1474 Serviarity 16,state 1;"

  Can any one explain me the cause of the problem

  Thanks and Regards

  Sreedhar Kuruba

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  May 21, 2008 at 4:30 pm

  #818912

  - Did you use "NO RECOVERY" when restoring database on the MIRROR server?

  Also, go thru this link:

  http://alan328.com/SQL2005_Database_Mirroring_Tutorial.aspx

  Manu

• Deepak-405225

  SSCertifiable

  Points: 6120

  More actions

  May 21, 2008 at 6:41 pm

  #818935

  Check this thread from MSDN and see if it helps,

  http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=258365&SiteID=1

  [font="Verdana"]- Deepak[/font]