Hi there, I'd successively done Mirroring without Witness server in test environment. There the ip for the principal and mirror server were "10.27.0.55" and "10.0.3.23" respectively. But when I placed the mirror server in my dr site, I gave it "10.96.2.200". Now the mirroring is not working. As far as I can get information from the web, I've tried. One thing I notice is that the windows login that I've used as service account of mirroring doesn't have Grant right to Mirroring Endpoint. Under securables, the system throws the following error:
cannot resolve the collation conflict between "Latin1_General_CI_AS_KI_WS" and "Latin1_General_Bin" in the Union Operation (error:468)Even when I tried to add the Endpoint and press OK, it won't appear again. SO I'd be grateful if anyone of You can help me with the solution.
asked Jan 29 '12 at 04:28 AM in Default
As per BOL recommendation
So the same problem is with your environment. May be this is the [bug] for which Microsoft has recommended this.: http://connect.microsoft.com/SQLServer/feedback/details/336208/collation-issue-raised-by-a-system-union-query-looking-at-securables-page-of-a-users-properties
answered Jan 29 '12 at 09:30 PM