Is it possible to install the third instance?

Hi everyone,
I have active-passive two node cluster server, it's already installed two
instances with associated two network names and IP addresses. Is there
possible to install the third instance in this cluster server, if give the
specific network name and IP address but no physical node 3?
Regards,
-Chen
Yes. The Active-Passive, Active-Active nomenclature is left over from SQL
7.0 and no longer accurately represents the clustering capabilities of SQL
Server 2000. The short version is you can have up to 16 instances on a
cluster, regardless of the number of nodes. You can choose which instances
should be on which nodes during normal operating conditions. You do have to
have a unique network name, IP address, and disk resource for each instance.
You also need to make sure you have enough physical resources (memory, CPU,
IO capacity) on each node to handle the work load, even during a failover
condition.
The correct current terms are single-instance and multiple-instance
clusters.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:430C357E-407A-4F73-8764-DDAFD3203DC2@.microsoft.com...
> Hi everyone,
> I have active-passive two node cluster server, it's already installed two
> instances with associated two network names and IP addresses. Is there
> possible to install the third instance in this cluster server, if give the
> specific network name and IP address but no physical node 3?
> Regards,
> -Chen
>
sql

Is it possible not to keep together textfields?

Hi,

This all appears when exporting a report to PDF:

I've a report with a label and textfield in the upper third, below the textfield there are some other controls. My problem is, that all works fine as long as the text for the textfield is short enough to fit the page. If the text gets to long I get a nearly blank page with only the label on it and the textfield on the next page. I found no property to change this behaviour. I want my textfield to split up to multiple pages, just as Access does it!

I want to see the first part of the content on the first page and then page footer, page header and then the second part on the next page.

I tried a list-control and a table-control with a rect in it -> same problem.

I found a very ....uncommon... way to do it, I made a subreport with just a textfield on it which has the value "Parameters!Text" (add the report parameter "Text") and put this subreport into my report and passing the long text as a parameter to the subreport ;)

But I think that's not exactly brilliant..

Any other hints?

Benni

|||

Okay,
very similar problem, if I have a report header(rectangle with some labels in it) with a list below it. As long as the record in the list contains few data all looks fine. If the content reaches a specific length the whole record is keept together on the next page (there is no report header, so a bit more space). If the content gets even larger its okay again (some parts on the first page, the rest on the next page)!

I've NOT set KeepTogether vor any control. I also tried the subreport trick, but it doesn't work ;(

Why does Microsoft add so many rarely needed extra features (e.g. multiple datasets side by side) and loose sight of the basic features? If I don't get this running I'll have to choose a different product, because no user wants to have this strange reports.. Even Access 2000 (I've no older version available) has better keeptogether options ;(

|||

Benni,

Did really the textfield "nokeeptogether" work using a subreport?

It doesn't work for me, perhaps your text was more than one page long? Did you do any other settings to make it work?

/Dan

|||The official MS workaround is to make a few Textfields under each other and split the text right into them. We've made a service request at microsoft and they told us, that they could rise a DCR (Design Change Request). We'll see if they fix it..

Is it possible not to keep together textfields?

Hi,

This all appears when exporting a report to PDF:

I've a report with a label and textfield in the upper third, below the textfield there are some other controls. My problem is, that all works fine as long as the text for the textfield is short enough to fit the page. If the text gets to long I get a nearly blank page with only the label on it and the textfield on the next page. I found no property to change this behaviour. I want my textfield to split up to multiple pages, just as Access does it!

I want to see the first part of the content on the first page and then page footer, page header and then the second part on the next page.

I tried a list-control and a table-control with a rect in it -> same problem.

I found a very ....uncommon... way to do it, I made a subreport with just a textfield on it which has the value "Parameters!Text" (add the report parameter "Text") and put this subreport into my report and passing the long text as a parameter to the subreport ;)

But I think that's not exactly brilliant..

Any other hints?

Benni

|||

Okay,
very similar problem, if I have a report header(rectangle with some labels in it) with a list below it. As long as the record in the list contains few data all looks fine. If the content reaches a specific length the whole record is keept together on the next page (there is no report header, so a bit more space). If the content gets even larger its okay again (some parts on the first page, the rest on the next page)!

I've NOT set KeepTogether vor any control. I also tried the subreport trick, but it doesn't work ;(

Why does Microsoft add so many rarely needed extra features (e.g. multiple datasets side by side) and loose sight of the basic features? If I don't get this running I'll have to choose a different product, because no user wants to have this strange reports.. Even Access 2000 (I've no older version available) has better keeptogether options ;(

|||

Benni,

Did really the textfield "nokeeptogether" work using a subreport?

It doesn't work for me, perhaps your text was more than one page long? Did you do any other settings to make it work?

/Dan

|||The official MS workaround is to make a few Textfields under each other and split the text right into them. We've made a service request at microsoft and they told us, that they could rise a DCR (Design Change Request). We'll see if they fix it..