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

unable to reconfigure mirroring Expand / Collapse
Author
Message
Posted Sunday, August 12, 2012 8:04 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 18, 2014 7:03 AM
Points: 201, Visits: 350
We are seeing the following error message when we are trying to reconfigure mirroring. We backed up the principal database, restored it on the mirrored server with norecovery option. Still seeing the following error.

End points on both principal server and mirror server is started:

"The server network address "TCP://TESTSERVER.test:1425" cannot be reached or does not exists".
Post #1343895
Posted Sunday, August 12, 2012 8:14 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 18, 2014 7:03 AM
Points: 201, Visits: 350
We have noticed the following error in SQL Server error logs:

The Database Mirroring protocol transport could not listen for connections due to the following error: '10013(An attempt was made to access a socket in a way forbidden by its access permissions.)'.

When we tried to research on the following error code, it has a particular permission issue which Microsoft talks about:

Windows sockets error codes, values, and meanings: http://support.microsoft.com/kb/819124

WSAEACCES (10013)

Translation: Permission denied.
Description: An attempt was made to access a socket in a way that is forbidden by its access permissions. For example, this error occurs when a broadcast address is used for sendto but the broadcast permission is not set by using setsockopt(SO_BROADCAST). Another possible reason for the WSAEACCES error is that when the bind (Wsapiref_6vzm.asp) function is called (in Microsoft Windows NT 4 .0 Service Pack 4 [SP4] or later), another program, service, or kernel mode driver is bound to the same address with exclusive access. Such exclusive access is a new feature of Windows NT 4.0 SP4 and later, and it is implemented by using the SO_EXCLUSIVEADDRUSE option.
Post #1343896
Posted Sunday, August 12, 2012 11:31 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:06 AM
Points: 167, Visits: 414
Hi,
Please check the ports are open from Primary to Mirror & Mirror to Primary serves.
Use Telnet & find.

Thanks
Satish
Post #1343976
Posted Friday, August 17, 2012 1:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 18, 2014 7:03 AM
Points: 201, Visits: 350
ports were open.
We restarted the mirroring endpoints and the issue got fixed.
Post #1346382
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse