Error When make Mirroring between SQL Server Standard Edition and Enterprise Edition


we can have Mirroring between Standard and Enterprise editions. But when you do this via SSMS (Graphical Interface), you might end up with following error message.

But when we use T-SQL statements, we were able to setup database mirroring and which worked perfectly fine too.

Error Message:

This mirroring configuration is not supported. Because the principal server instance, <server_name>, is Standard Edition, the mirror server instance must also be Standard Edition.

531x484xSQLServerMirroringEditionError_thumb_jpg_pagespeed_ic_yWV4PufZF4

BgInfo v4.16


If you manage multiple computers you probably need BGInfo. It automatically displays relevant information about a Windows computer on the desktop’s background

Download BgInfo software

http://technet.microsoft.com/en-us/sysinternals/bb897557