Re: Multiple Instances on the same virtual server?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Linchi is correct, you need a separate clustered group and network name for
every instance.

Now onto the VMP issue. I think you are confusing disks with names now. Yes,
SQL2005 supports VMP. The support is for any type of SQL install, clustered
or not.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


"ipconfig2" <ipconfig2@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DF86C624-8B4F-4FB6-9F44-B301D7EE8BA6@xxxxxxxxxxxxxxxx
I dont think Linchi has correct information here.

Without having tested this, SQL 2005 supports Volume Mount Points(VMP).
So,
you can install numerous instances on one VirtualServerName. They need to
have unique IP and Instance Name.

Am I off here or is this VMP only supported on non-clustered
installations?
VMP should help the driveletter saturations problems that large
installations
experienced during SQL2000.

Any thoughts on this?

"Linchi Shea" wrote:

No, not with SQL2005 (or SQL7/2000). Each clustered SQL instance must
have
its own network name (i.e. its own virtual server name).

Linchi

"brimoore@xxxxxxxxxxx" wrote:

Is this possible?

I would like to have 2 instances on my virtual SQL 2005 cluster,
listening on different ports.

For example, if my virtual hostname is HOSTNAME123 can I have one
instance on HOSTNAME123, port 1433 and the second instance on
HOSTNAME123, port 1432?

Or does each clustered instance need its own, distinct hostname?

Thanks in advance.




.

Relevant Pages

  • Re: Question about setup
    ... MVP - Windows Server - Clustering ... when I launched SQL 2005 - I do not ... Do I need to run the install again? ...
    (microsoft.public.sqlserver.clustering)
  • Re: Serivce Pack 2 for Windows 2003 enterprise server fails
    ... MVP - Windows Server - Clustering ... I learned a lesson in all this, it is treat a service pack like an new OS ... licdll.dll and it allowed us to install the service pack but..... ...
    (microsoft.public.windows.server.clustering)
  • Re: SQL2005 Clustering Under Virtual Server Release 2
    ... If you proceed from this point, it looks like the install then ... currently installed on the virtual server is a SQL2000 named instance. ... Developer Edition definitely allows clustering. ... My problem comes when attempting to install SQL 2005 (I'm using the ...
    (microsoft.public.sqlserver.clustering)
  • Re: Question about setup
    ... MVP - Windows Server - Clustering ... I completed the install; however, when I launched SQL 2005 - I do not see ...
    (microsoft.public.sqlserver.clustering)
  • Re: Question about setup
    ... MVP - Windows Server - Clustering ... when I launched SQL 2005 - I do not see ... Do I need to run the install again? ...
    (microsoft.public.sqlserver.clustering)