Environment: 2 Servers SQL 2008 R2 RTM Standard Edition, Windows Server 2008 R2 SP1 standard edition. Both servers using the same domain service account for SQL with sysadmin access and local Administrator group access on both servers.
4 databases are successfully mirrored without issue, all database owners are sa.
When we attempt to setup mirroring on the 5th database it successfully starts and then within a minute goes to a (Principal disconnected) state on Primary and stays at (Mirror, Syncronizing / Restoring) on the mirror. The Mirroring monitor just shows "Disconnected" from the beginning of the event for the fifth database.
I have run a SQL Trace while setting up mirroring and the only thing in them is "Attention" with the service account and host name, no other details.
The Windows Application logs on both Primary and Mirror server show SQL Server event ID 1438. We are not using a witness and have never attempted to set one up in this environment.
Any suggestions on what to check would be appreciated