db mirroring error 1456

• kkarthik117

  SSC-Addicted

  Points: 476

  More actions

  April 26, 2013 at 4:18 pm

  #271879

  Hi

  I have configured db mirroring successfully without witness.

  later when im adding witness server i have constantly failed with the following error

  "Alter Database command couldn't sent to remote server instance 'TCP://FKBSUB:5022'.

  The database mirroring configuration is not changed.Verify Server is connected and try again (Microsoft SQL Server,Error:1456)"

  my principal in on sp2

  mirror on sp1

  witness on sp1

  thanks

• Neeraj Dwivedi

  SSCertifiable

  Points: 6768

  More actions

  April 27, 2013 at 5:53 am

  #1610588

  Duplicate Post :-

  http://www.sqlservercentral.com/Forums/Topic1447198-1549-1.aspx