Re: New Named SQL Server 2008 Instance in existing Cluster - HowTo?

You were good until the last sentence.

You cannot share resources, including disk resources, between instances. You get one instance per "Service or Application".

For a second instance, you will need new disks, a new network name, and a new IP address.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"John Myren" <john.myren(@).hemnekraftlag.no> wrote in message news:72118602-3571-4D9A-BB25-85B5A3A0BA23@xxxxxxxxxxxxxxxx
How do we add a new Named Instance under Services and Applications for the
existing SQL 2008 Cluster? We have the default MSSQLServer installed and
working OK.

We want to share the same data disk's for both Instances. Is this possible?


.

Relevant Pages

  • Re: SQL 2005 cluster
    ... The passive node also has 8 GB of RAM, 150 GB of SAN disk, and has 4 local ... test instances of SQL 2005, ... mapped to clustered disk resources and are specific to each SQL instance. ... - On the passive mode, in the above configuration, can the local instances ...
    (microsoft.public.sqlserver.clustering)
  • Re: Active/Active Question
    ... complete with IP address, disk resources, and network name on your cluster. ... SQL server, then you can load SQL again on the cluster and create the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2005 cluster
    ... nodes are equivalent so the choice of current host is arbitrary. ... Microsoft SQL Server MVP ... and the failover production instance. ... mapped to clustered disk resources and are specific to each SQL instance. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2005 cluster
    ... test instances of SQL 2005, and the failover production instance. ... The Cluster service arbitrates ownership and control. ... mapped to clustered disk resources and are specific to each SQL instance. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Event ID 17055 (18052 Error:826)
    ... Disk resources are on the node and accessable. ... The service starts and then immediately stops when attempting to start from ... "Geoff N. Hiten" wrote: ... SQL service should be set to Manual start. ...
    (microsoft.public.sqlserver.clustering)