Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL 08 mirror menu option missing

Posted on 2009-07-09
4
Medium Priority
?
407 Views
Last Modified: 2012-05-07
Experts,
I have, in the last few months, migrated my sql 05 data to a new server using Windows Server 2008 64bit SP1 and MSSQL 2008 SP1.  This server is to be the principal on mirror setup.  Last week on a different box I reloaded a 32bit version of Windows Server 2008  and MSSQL 2008 SP1.  This 32 bit machine is to be the mirror.  

On the mirror box, I am able to access the mirror menu option via right click/tasks/mirror or simply looking at the DB properties (any DB).  On the principal box - I can't access the mirror menu option either way (any DB).

Additionally, when I add the SQL install disk (the same dvd used for both installs), the features menu for the mirror box includes 2 items (already installed) that don't list on the principal box: Analysis Services and Integration Services.  BIDS is listed as installed on both boxes.

Hopefully I have included enough info for this to be clear to someone, as it is mud to me.

Thank you.
0
Comment
Question by:Targhee
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 15

Expert Comment

by:rob_farley
ID: 24820658
What version is installed on each server? Can you connect and "SELECT @@VERSION" for me (on both)?

Rob
0
 

Author Comment

by:Targhee
ID: 24825215
Hi Rob,
Thanks for the help.

Principal server:  

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)   Mar 29 2009 10:11:52   Copyright (c) 1988-2008 Microsoft Corporation  Web Edition (64-bit) on Windows NT 6.0 <X64> (Build 6001: Service Pack 1)

Mirror Server:

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)   Mar 29 2009 10:27:29   Copyright (c) 1988-2008 Microsoft Corporation  Standard Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)
0
 
LVL 15

Accepted Solution

by:
rob_farley earned 2000 total points
ID: 24828490
Ah - Web Edition on the principal. There's your problem. Upgrade it to something better.

Rob
0
 

Author Closing Comment

by:Targhee
ID: 31601710
Rob - thanks.
This server was to have been a Coldfusion server to begin with, but things were forced to be changed.  I was unaware that the web edition was a 'less complete' OS.  I think I will rework the hardware setup.
0

Featured Post

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question