Multiple Instances on the same virtual server?

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.
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@.state.pa.us" 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.
>
|||Thanks for your response.
Linchi Shea wrote:[vbcol=seagreen]
> 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@.state.pa.us" wrote:
|||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:
[vbcol=seagreen]
> 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@.state.pa.us" wrote:
|||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@.discussions.microsoft.com> wrote in message
news:DF86C624-8B4F-4FB6-9F44-B301D7EE8BA6@.microsoft.com...[vbcol=seagreen]
>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:
sql