Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

An error occurred while starting mirroring-Alter failed for Database 'AdventureWorks'. (Microsoft.SqlServer.Smo) Expand / Collapse
Author
Message
Posted Friday, January 17, 2014 9:33 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 8:31 AM
Points: 304, Visits: 1,170
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.'.




Aim to inspire rather than to teach.
SQL Server DBA
Post #1532137
Posted Friday, January 17, 2014 11:41 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 8:31 AM
Points: 304, Visits: 1,170
Was able to create mirroring Successfully after creating and giving service account under with SQL Server runs to proper rights.

Aim to inspire rather than to teach.
SQL Server DBA
Post #1532206
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse