Multi Instance or Mutliple Virtual Servers

Can anybody tell me the differences, advantages or disadvantages in
installing an active/active cluster as
VIRTUAL/INSTANCE1
and
VIRTUAL/INSTANCE2
against
VIRTUAL1
and
VIRTUAL2
We did not seem to get the option to install a second instance on the first
virtual server and so opted for 2 virtual servers with names instance on
each so
VIRTUAL1 / INSTANCE1
and
VIRTUAL2 / INSTANCE2
Many Thanks
Steve
In a cluster, each instance is installed in its own virtual server.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Steve" <spam@.notformeplease.net> wrote in message
news:HLednboIr5j-OrnfRVnytg@.brightview.com...
> Can anybody tell me the differences, advantages or disadvantages in
> installing an active/active cluster as
> VIRTUAL/INSTANCE1
> and
> VIRTUAL/INSTANCE2
> against
> VIRTUAL1
> and
> VIRTUAL2
> We did not seem to get the option to install a second instance on the
first
> virtual server and so opted for 2 virtual servers with names instance on
> each so
> VIRTUAL1 / INSTANCE1
> and
> VIRTUAL2 / INSTANCE2
> Many Thanks
> Steve
>
|||Thanks Geoff
So I think that means we got it right first time.
Regards
Steve
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%2339SkcoHFHA.236@.TK2MSFTNGP14.phx.gbl...
> In a cluster, each instance is installed in its own virtual server.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Steve" <spam@.notformeplease.net> wrote in message
> news:HLednboIr5j-OrnfRVnytg@.brightview.com...
> first
>

MSSQLServerOLAPSerice will not start.

I setup a MSSQL 2005 Cluster running on top of Virtual Server 2005. Everthing was running fine until this morning, when suddenly Analysis Services failed to start on the Cluster. When I looked in the Event Log I see the following:

Source: MSSQLServerOLAPService
Category: (289)
Type: Error
Event ID: 0

Description:
The service cannot be started: The DOM parser failed to load and parse the stream. URL:'' Reason: 'A document must contain exactly one root element.

' Source:''. File position: 0. Line: 1. The DOM parser failed to load and parse the file '\\?\N:\Microsoft SQL Server\MSSQL.2\OLAP\Data\master.vmp'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Any idea on what I can do to resolve this problem.

Thanks.

Most likely you data became corrupted. If you can reproduce the scenario you should contact product support services to troubleshoot this problem.

To get Analysis Server to start again you delete all the files in "%AS installation folder%\data" folder.

You need to restore you databases you've backed up earlier. Alternatively you can re-create and re-process all the cubes and all dimensions you had.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thanks for the reply. I ended up simply deleting and reinstalling the service.