Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
neilbarker
Starting Member
4 Posts |
 Posted - 2011-02-25 : 07:18:11
|
| Please please please can someone assist with a mirroring issue I have?No matter what I do I cannot get past the following error:Database mirroring connection error 4 'An error occurred while receiving data: '10054(failed to retrieve text for this error. Reason: 15105)'.' for 'TCP://nbtest02.nbtest.local:5022'.I have tried most of what is out there on Google but to no avail. I can ping all servers (principal, target and witness) from each other and can also telnet between the principle and target machines on port 5022.I restored the database to the target using the no recovery option and also did this for the log files too.I have no Windows firewalls on either.Soon I will have no hair as this is getting ripped out by the second!!!Thanks in advance,Neil |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
neilbarker
Starting Member
4 Posts |
Posted - 2011-02-26 : 02:42:57
|
| When I click on "Start Mirroring" after completing the security wizard. The logs show the following:02/26/2011 07:44:52,spid29s,Unknown,Database mirroring has been terminated for database 'nbtest'. This is an informational message only. No user action is required.02/26/2011 07:44:52,spid29s,Unknown,Error: 1443<c/> Severity: 16<c/> State: 2.02/26/2011 07:44:33,spid31s,Unknown,Database mirroring connection error 4 'An error occurred while receiving data: '10054(failed to retrieve text for this error. Reason: 15100)'.' for 'TCP://MIC-DELL016.makeitcheaper.local:5022'.02/26/2011 07:44:33,spid31s,Unknown,Error: 1474<c/> Severity: 16<c/> State: 1.02/26/2011 07:44:32,spid52,Unknown,Database mirroring has been enabled on this instance of SQL Server. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
neilbarker
Starting Member
4 Posts |
Posted - 2011-02-27 : 10:55:03
|
| Tara,Thanks for your help, I have managed to resolve the issue and mirroring is now working.During the security configuration I did not enter any username as I assumed that due to being on the same domain, logged in as domain admin user, with the service account also running as domain admin, I did not need to.I entered the username the service account was using and all is now good.Cheers,Neil |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Mirror mirror on the wall