Can two separate SQL Server instances on a clustered box share the same resource name such as SQ

I am setting up a two active instances of MS SQL Server on a clustered box. In the past I have set up using the nomenclature SQLCLUSTERNAME\INSTANCE-NAME such as SQLCLUS1\INST1 and SQLCLUS2\INST2.

But, this time the client will like it installed such as SQLCLUS1\INST1 and SQLCLUS1\INST2. I did not think this is possible That is I assumed that cluster resource names have to be unique. But, nevertheless I have tried to do so for the last few days, but no luck.

Can someone please let me know if it is indeed possible to have two separate instances in a single cluster.

BTW, I know this is quite possible with non-clustered instances where the SQLSERV1\INST1 refers to an actual server name, and not a resource name.

You are partially correct.

You CAN have two separate instances in a cluster -but in order for the cluster resource names on both instances to be the same, both instances will have to be installed on the same node. You could do that, making it an Active-Passive cluster -but I don't think that is what you desire. So if you wish both nodes to be Active, then you will have to continue using distinctive resource names (as in your first surmise.)

|||BTW, how would you set up. One Active, and one passive with different instance names.|||The same way that you set up an Active-Active cluster, except you put both instances on the same node.|||I am still a little unsure. Will the instances have names such as SQLCLUS1\INST1 and SQLCLUS1\INST2 or SQLCLUS1\INST1 and SQLCLUS2\INST2.

- Daniel|||

If you are asking about two instances on the same host, then SQLCLUS1\INST1 and SQLCLUS1\INST2 would work.

Instance names can be whatever you desire. The virtual server name will be the same in both cases.

Can two separate SQL Server instances on a clustered box share the same resource name such as SQ

I am setting up a two active instances of MS SQL Server on a clustered box. In the past I have set up using the nomenclature SQLCLUSTERNAME\INSTANCE-NAME such as SQLCLUS1\INST1 and SQLCLUS2\INST2.

But, this time the client will like it installed such as SQLCLUS1\INST1 and SQLCLUS1\INST2. I did not think this is possible That is I assumed that cluster resource names have to be unique. But, nevertheless I have tried to do so for the last few days, but no luck.

Can someone please let me know if it is indeed possible to have two separate instances in a single cluster.

BTW, I know this is quite possible with non-clustered instances where the SQLSERV1\INST1 refers to an actual server name, and not a resource name.

You are partially correct.

You CAN have two separate instances in a cluster -but in order for the cluster resource names on both instances to be the same, both instances will have to be installed on the same node. You could do that, making it an Active-Passive cluster -but I don't think that is what you desire. So if you wish both nodes to be Active, then you will have to continue using distinctive resource names (as in your first surmise.)

|||BTW, how would you set up. One Active, and one passive with different instance names.
|||The same way that you set up an Active-Active cluster, except you put both instances on the same node.|||I am still a little unsure. Will the instances have names such as SQLCLUS1\INST1 and SQLCLUS1\INST2 or SQLCLUS1\INST1 and SQLCLUS2\INST2.

- Daniel
|||

If you are asking about two instances on the same host, then SQLCLUS1\INST1 and SQLCLUS1\INST2 would work.

Instance names can be whatever you desire. The virtual server name will be the same in both cases.

sql

Can RS 2005 point to SQL 2000 DB?

I would like to install Reporting Services 2005 on one IIS box and point to a
separate SQL Server 2000 box which would be used to host its two databases
(ReportingServer and ReportingServerTempDB).
Will this work?
--
LulkYes. You need a 2005 license on the IIS box but the databases can be on 2000
(I am running in this configuration).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lulk" <Lulk@.discussions.microsoft.com> wrote in message
news:E9845796-C306-4014-B9D2-6C753C4F2EA5@.microsoft.com...
>I would like to install Reporting Services 2005 on one IIS box and point to
>a
> separate SQL Server 2000 box which would be used to host its two databases
> (ReportingServer and ReportingServerTempDB).
> Will this work?
> --
> Lulk|||Yes, this will work. The database will have to have its schema updated, but
can be hosted on SQL Server 2000. You can use the Reporting Services
Configuration Tool to accomplish this easily enough.
Rodney
"Lulk" <Lulk@.discussions.microsoft.com> wrote in message
news:E9845796-C306-4014-B9D2-6C753C4F2EA5@.microsoft.com...
>I would like to install Reporting Services 2005 on one IIS box and point to
>a
> separate SQL Server 2000 box which would be used to host its two databases
> (ReportingServer and ReportingServerTempDB).
> Will this work?
> --
> Lulk|||Does it require two SQL Server licenses if you are going to run RS 2005 on a
separate ISS server and point to a separate 2000 SQL Server? What if I point
to a separate SQL 2005 Server, would that configuration still require two SQL
Server licenses?
--
Lulk
"Bruce L-C [MVP]" wrote:
> Yes. You need a 2005 license on the IIS box but the databases can be on 2000
> (I am running in this configuration).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Lulk" <Lulk@.discussions.microsoft.com> wrote in message
> news:E9845796-C306-4014-B9D2-6C753C4F2EA5@.microsoft.com...
> >I would like to install Reporting Services 2005 on one IIS box and point to
> >a
> > separate SQL Server 2000 box which would be used to host its two databases
> > (ReportingServer and ReportingServerTempDB).
> >
> > Will this work?
> > --
> > Lulk
>
>|||Yes. Whatever box RS is running on needs a license.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lulk" <Lulk@.discussions.microsoft.com> wrote in message
news:3A86DA3A-674D-4F8E-BAF2-9CB0823DEF9A@.microsoft.com...
> Does it require two SQL Server licenses if you are going to run RS 2005 on
> a
> separate ISS server and point to a separate 2000 SQL Server? What if I
> point
> to a separate SQL 2005 Server, would that configuration still require two
> SQL
> Server licenses?
> --
> Lulk
>
> "Bruce L-C [MVP]" wrote:
>> Yes. You need a 2005 license on the IIS box but the databases can be on
>> 2000
>> (I am running in this configuration).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Lulk" <Lulk@.discussions.microsoft.com> wrote in message
>> news:E9845796-C306-4014-B9D2-6C753C4F2EA5@.microsoft.com...
>> >I would like to install Reporting Services 2005 on one IIS box and point
>> >to
>> >a
>> > separate SQL Server 2000 box which would be used to host its two
>> > databases
>> > (ReportingServer and ReportingServerTempDB).
>> >
>> > Will this work?
>> > --
>> > Lulk
>>