An error occurred while starting mirroring-Alter failed for Database 'AdventureWorks'. (Microsoft.SqlServer.Smo)

• SQlLogic

  SSCrazy Eights

  Points: 9686

  More actions

  January 17, 2014 at 9:33 am

  #282472

  Hi Guys ,

  I am trying to set up Mirroring on my local machine to test SQL2008R2. And when Ever I am trying to start getting this error..

  An error occurred while starting mirroring-Alter failed for Database 'AdventureWorks'. (Microsoft.SqlServer.Smo)

  IS anyone has idea?

  On Mirror Server Error log has this details

  : Database Mirroring login attempt by user.' failed with error: 'Connection handshake failed. The login 'NT AUTHORITY\NETWORK SERVICE' does not have CONNECT permission on the endpoint. State 84.'.

  

• SQlLogic

  SSCrazy Eights

  Points: 9686

  More actions

  January 17, 2014 at 11:41 am

  #1681196

  Was able to create mirroring Successfully after creating and giving service account under with SQL Server runs to proper rights.