SQL 2008R2 Mirroring Issue

introlux
introlux used Ask the Experts™
on
Hi,

We have noticed errors cropping up in the logs. We have 3 servers, DB01, DB02 and DB03 (as the witness server).

Jumping on the witness server we have noticed odd entries in the logs and wanted some advice on this.

Database mirroring connection error 4 'An error occurred while receiving data: '24(The program issued a command but the command length is incorrect.)'.' for 'TCP://DB02:4040'.
Error: 1474, Severity: 16, State: 1.

Any help will be appreciated.

introlux
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
What is the version of Witness ? Well all participating sql version should be same in database mirroring.
SteveArchitect/Designer

Commented:
this is most likely a version issue. is the witness SQL version  newer than the versions used on the mirror?
introluxTechincal Director

Author

Commented:
witness is web edition and the other two DB's are standard editions
Architect/Designer
Commented:
I'm sorry to say that is very likely your issue. The witness can be SQL express without an issue as long as it's the same SQL version.
introluxTechincal Director

Author

Commented:
thanks - all same version and working.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial