December 1, 2008 at 1:17 pm
Please, Help!!!!
One of my project need to user mirroring to replicate data between 2 database servers. Servers are the same domain, I follow the mirroring rules, but some error message stop me......
The principal Server:
SQL Server Log:
Error: 1474, Severity: 16, State: 1.
Database mirroring connection error 4 'An error occurred while receiving data: '10054(An existing connection was forcibly closed by the remote host.)'.' for 'TCP://servername.domain:5022'.
The Mirror Server
SQL Server Log:
The Database Mirroring protocol transport is now listening for connections.
Logon Database Mirroring login attempt by user 'NT AUTHORITY\ANONYMOUS LOGON.' failed with error: 'Connection handshake failed. The login 'NT AUTHORITY\ANONYMOUS LOGON' does not have CONNECT permission on the endpoint. State 84.'. [CLIENT: xxx.xx.x.xx]
December 3, 2008 at 7:11 am
Not an expert on mirroring, but it sounds like your SQL Server(s) are not using domain accounts to run and they may need to for mirroring.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 3, 2008 at 7:17 am
This does look like an SQL account issue, to get mirroring to work you will need to either run your SQL servers with a domain accout, or if this is not possbile then you will have to setup mirroring to use certificates for authentication
December 3, 2008 at 8:22 pm
if you don't want to use a domain account here are instruction to use certificate for local accounts. Unfortunately I have no experience with doing it like this
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply