Home Dashboard Directory Help
Search

Unable to setup database mirroring between two SQL Server 2012 Business Inteligence Edition SQL Sever Instance. by Nirav_Joshi


Status: 

Closed
 as Fixed Help for as Fixed


2
0
Sign in
to vote
Type: Bug
ID: 737911
Opened: 4/20/2012 6:51:59 AM
Access Restriction: Public
0
Workaround(s)
view
3
User(s) can reproduce this bug

Description

--We have two SQL Server 2012 Business Inteligence Edition SQL Sever Instances.

--While trying to create Database Mirroring Session using the wizards in SQL Server management studio.
-- We got the following error message after connecting to the mirroring server.
SERVERNAME\INSTA12 is not a valid mirror server instance . Which must be Enterprise,Developer or standard edition of SQL Server.

-- We can take Witness servetr out or in this would be same error message we received every time.
-- As per the Edition matrix it is suppored so far as following
http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx


Feature Name             Business Intelligence

Database mirroring     Yes (Safety Full Only)
Details
Sign in to post a comment.
Posted by Microsoft on 6/14/2012 at 1:24 PM
Sorry for hte naming confusion. The issue is fixed and will be available in Service Pack 1 of SQL Server 2012. CU1 is a roll-up of hotfixes which have already shipped to customers.

Cut from the KB article:
"... if you are not severely affected by any of these problems, we recommend that you wait for the next SQL Server 2012 service pack ..."
Posted by Nirav_Joshi on 6/13/2012 at 10:38 PM
Thanks for the update.

Just want to confirm here i went through the KB article for SQL 2012 CU1
http://support.microsoft.com/kb/2679368

It has been no where mentioned that it was problem with GUI and has been fixed now.

Could you please verify the same and confirm it that has been fixed CU1 in next update.
Posted by Microsoft on 6/13/2012 at 10:43 AM
Thank you for your feedback.

This issue will be fixed in SQL Server 2012 PCU1.
Posted by Microsoft on 6/12/2012 at 8:52 PM
Thnak you very much for reporting this issue. We have fixed the issue and it will be available in the next update of SQL Server 2012.
Posted by Microsoft on 6/1/2012 at 1:33 PM
Hello, I just wanted to provide you an update that the team owning the GUI is investigating.

Thanks you, Debra Dove
Posted by Nirav_Joshi on 4/24/2012 at 4:30 AM
Hi,

We can able to setup mirroring session using command line.
But GUI still no change same error message.

Please progress it FAST or ASAP.

Its hampering productivity.
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
Books Online states the following that DB Mirroring is supported on the Business Intelligence edition as per the screenshot below.docx (restricted) 4/20/2012 -
Books Online states the following that DB Mirroring is supported on the Business Intelligence edition as per the screenshot below.docx 4/20/2012 40 KB