I ended up switching over to log shipping, but may have located the culprit.  It appears that one of the cumulative updates (CU3) may address this particular issue.

https://support.microsoft.com/en-us/help/4056354/fix-mirroring-session-stops-synchronizing-after-doing-rolling-upgrade

I hope...

Note - Have recreated endpoints and attempted a different port (5022) without success. Added port to inbound/outbound firewall rules as well.

Correct - All three instances are running Standard.

Thank you for the replies.  Had thought about disabling the endpoint for the interim to be safe and will proceed with that approach.  Have a wonderful day!

RVSC48 (9/29/2016)

---

Or, have not done this in a while, in ssms, go the properties of the database on the Primary server, then go to Transaction Log Shipping, and uncheck the...

Since I received the earlier error when I ran sp_delete_log_shipping_secondary_primary, I've disabled...

This originally was the secondary database in the log shipping configuration so when I go into the properties this particular setting is unchecked.

When I attempted to run the stored procedure I received the following error message:

exec...

Thank you for the follow-up and the additional note regarding the "Man in the Middle Attack". Any outside transmission of the data will be sent via SSL so I'm...

Hi Erland,

Thank you for your reply. That makes sense on the "Security by Obscurity" as I wasn't too sure how using EncryptByKey/DecryptByKey would be used in any other way....

Thank you for your reply Sean. I apologize for the delay in responding as I've been out of town over the weekend.

In your first reply you note that there...

When there's not a clustered index on a table and a query is performed against it, a full table-scan will be needed as SQL Server has no idea of the...

Here is a link to the MSDN for Clustered Index Design Specifications which may help you better understand what columns you should use for your clustered index.

http://msdn.microsoft.com/en-us/library/ms190639%28v=sql.105%29.aspx

Also, you...

Good Question - When in doubt, the answer is always 'C' 🙂

Thank you for your replies. I had thought that this may be the case but was having trouble locating anything online in the documentation. I'll go ahead and...