Install Second Node

How would I go about installing the second node for SQL 2000 cluster? The
first node is up and running.
Think I go it. Thanks-
"Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
news:uNZKUQMtHHA.2124@.TK2MSFTNGP02.phx.gbl...
> How would I go about installing the second node for SQL 2000 cluster? The
> first node is up and running.
>
|||Whats the answer ? You cant do this live, can you ?
"Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
news:uAIXXWMtHHA.1208@.TK2MSFTNGP05.phx.gbl...
> Think I go it. Thanks-
> "Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
> news:uNZKUQMtHHA.2124@.TK2MSFTNGP02.phx.gbl...
>

install replication components on cluster

Hi,
At the SQL Server cluster installation time I haven't choose the replication component(wasn't required at that time). Now it is and when I run again the setup to modify the installation and to add the replication components it doesn't give me that option.
The only option that I have is to uninstall the SQL Server.
Is it what is suppose to be? If yes how can I install the replication components?
Cata,
replication isn't enabled from the setup. If you use EM, and go to tools,
replication, configure publishing... you can set it up there.
Regards,
Paul Ibison
|||Thanks for your replay.
At the setup time when you install the SQL Server one is
asked if he wants to install the Replication components -
so there are some components that have to be installed. I
haven't choose that option.
Additionally when I am choosing to configure replication
EM - Tools - Cofigure Publishing, I get the message "The
Replication components were not included when SQL Server
was installed on <server>"

>--Original Message--
>Cata,
>replication isn't enabled from the setup. If you use EM,
and go to tools,
>replication, configure publishing... you can set it up
there.
>Regards,
>Paul Ibison
>
>.
>
|||My apologies - I had selected this checkbox without thinking when I installed, which was a while ago. I'm out of the office for a while but if no-one else answers in the next few days then I'll try on a test cluster I have built back at work. I suspect yo
u'll have to break the cluster then add the components, but I'll have a look.
Regards,
Paul Ibison

Install New Instance/ Store Data & Log Files in existing drive

Hello,
I need to install a new instance of SQL Server 2000 on a cluster.
Currently, we have three instances. Each instances stores program files on
the E:\ Drive. Each instance has its own drive for data and another for
logs. However, there is no more unallocated space on the array to create
another partitioned drive.
My question is: If I create the new instance, can I store the data and log
files on an existing drive? Are there any performance or overhead costs that
should be considered?
Thank you,
Caroline
Each instance must have separate disk resources from any other instances.
You will need new disks to create another instance.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Caroline" <Caroline@.community.nospam> wrote in message
news:4E870F35-33B9-4E92-91E6-1993FD8FE4C4@.microsoft.com...
> Hello,
> I need to install a new instance of SQL Server 2000 on a cluster.
> Currently, we have three instances. Each instances stores program files
> on
> the E:\ Drive. Each instance has its own drive for data and another for
> logs. However, there is no more unallocated space on the array to create
> another partitioned drive.
> My question is: If I create the new instance, can I store the data and
> log
> files on an existing drive? Are there any performance or overhead costs
> that
> should be considered?
> Thank you,
> Caroline
sql

Install Muliti Instances on SQL 2005 cluster with the same server name

I am trying to install multi instances on my server cluster 2003 R2 Sp2. Because of the compatibility issues with my services I need to install both SQL 2000 and 2005. With 2000 I can easily specify the instance and servername. The server name can be the same, but the instance has to be different. Is this true for 2005? I have found so far that for every new instance that you create that you need to have a different virtual server name. How can you utilize the same virtual name and have multi insances

servername\$instance1

servername\$instance2

and so on

ThatGuy

I do not think this is supported as virtual server name should be unique across the network in your domain.

Install msde with instancename on a W2003 cluster

How can i install the SQL MSDE (sp3a) with a instance name
on a windows 2003 cluster server.
A custumer has a windows 2003 cluster server. When i run
our setup, with parameters like intsance=myprogram, the
software installs normaly on the server. Our client
software louks voor
%Server%\%InstanceName% across the network.
The software don't see the instance name.
Thanks.
Sounds like it is installing correctly. There is nothing special about
installing MSDE on a node of a cluster. Can you use OSQL on the server you
installed MSDE on to connect to the SQL Server? Have you used svrnetcn.exe
to enable the protocols for MSDE? Have you applied SP3 to the MSDE
installation? TCP/IP is not available on Windows 2003 until SP3 is
installed on any version of SQL Server 2000.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Yes, the software installs correctly. (I don't see event
in the logs)
We used msde 2000 with sp3.
Yes i have used the svrnetcn.exe to configure the tcp/ip
protocol, set port to 1433.
I haven't used Osql to test the connection.
I test with the sql enterprice manager, to connect the
msde on the 2003 server. This don't work.
When i install the same msde software on a nomal Windows
2003 server everything works fine.
What else can i do?
What can there be wrong?
Thanks for your reply.
sql

Install MSDE on 2003 server cluster

I've two server 2003 configurated as cluster. How to
install MSDE2000A on nodes ?
hi Carlo,
Carlo Dolenz wrote:
> I've two server 2003 configurated as cluster. How to
> install MSDE2000A on nodes ?
AFAIK MSDE does not support cluster installation...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||You can install MSDE as an instance (default or named) on each node of the
cluster but MSDE is not cluster aware so if you're thinking of a
mini-failover cluster, that's not gonna happen with MSDE.
joe.
"Carlo Dolenz" <anonymous@.discussions.microsoft.com> wrote in message
news:282d01c514ea$7f039090$a501280a@.phx.gbl...
> I've two server 2003 configurated as cluster. How to
> install MSDE2000A on nodes ?

Install Full-Text on Existing SQL Server 2005 Cluster

I need to install the full-text engine on an existing SQL Server 2005
cluster virtual instance but can't seem to figure out how. Any ideas?
Start | Programs | Add/Remove Programs
Click the modify link underneath SQL Server.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Adam Weigert" <adam.weigert@.wegmans.com> wrote in message
news:uKpmBzkPGHA.2624@.TK2MSFTNGP12.phx.gbl...
>I need to install the full-text engine on an existing SQL Server 2005
>cluster virtual instance but can't seem to figure out how. Any ideas?
>
|||Unfortunately, the only change operation I can do from Add/Remove programs
for the cluster instance is either add or remove a node from the cluster.
There are no options to change what is installed.
I've looked at some of the command line maintenance features, but haven't
been able to figure out the correct command to issue.
Any other ideas or info?
|||In case anyone else runs into this, I did open a support case with Microsoft
and they concluded that this option was "left out" of the cluster change
options. They are going to place a feature enhancement request with the
product team. I'll update the thread if any new information arises in the
near future.
|||Thanks for the info.
*mike hodgson*
http://sqlnerd.blogspot.com
Adam Weigert wrote:

>In case anyone else runs into this, I did open a support case with Microsoft
>and they concluded that this option was "left out" of the cluster change
>options. They are going to place a feature enhancement request with the
>product team. I'll update the thread if any new information arises in the
>near future.
>
>

Install fails with a "..path specified...is invalid"

After running through all the pre-install questions, it begins by saying that
it is performing operations on the cluster nodes and then fails with the
message:
"The path specified in a command line argument is invalid:
\\<servername>\admin$\<servername>_MSSQLSERVER.iss "
Any thoughts?
Either the administrative shares have been disabled or you are running under
an account that does not have access to the administrative shares on all
nodes of the cluster.
Sincerely,
Anthony Thomas

"Isaac Story" <IsaacStory@.discussions.microsoft.com> wrote in message
news:7FCDAF81-7BCF-4E99-9A74-5F564D090E63@.microsoft.com...
> After running through all the pre-install questions, it begins by saying
that
> it is performing operations on the cluster nodes and then fails with the
> message:
> "The path specified in a command line argument is invalid:
> \\<servername>\admin$\<servername>_MSSQLSERVER.iss "
> Any thoughts?
|||Actually I found the problem in a KB article. I had Terminal Services
installed on two of the nodes. SQL Clustering cannot be installed on a node
or nodes that have terminal services installed. Just thought I would post
that for anyone else how might run across the same problem.
"Anthony Thomas" wrote:

> Either the administrative shares have been disabled or you are running under
> an account that does not have access to the administrative shares on all
> nodes of the cluster.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Isaac Story" <IsaacStory@.discussions.microsoft.com> wrote in message
> news:7FCDAF81-7BCF-4E99-9A74-5F564D090E63@.microsoft.com...
> that
>
>

Install fails on x64 cluster nodes.

I can't seem to install SQL Server 2005 (x64 version) on an x64 Win2k3 two node cluster.

I get all the way through the configuration and setup fails because it cannot start a task on the remote node. The error message indicates to check the task scheduler log file, which I have and I cannot find any 'errors' in the file.

Google/MSDN/Technet turn up nothing on multiple searches. Has anyone else run into this problem?

My installation account is a local admin on both machines, so is the sql cluster account. For the life of me I cannot figure out what's different for an x64 install vs 32bit....

Fixed the problem...

My account was not authoritative for the "Domain Services" group.

|||

I have the same problem, can would appreciate it if anyone could elaborate on this "Domain Services" group. What do you mean by not "authoratative" for this group?

Thanks.

Install fails on x64 cluster nodes.

I can't seem to install SQL Server 2005 (x64 version) on an x64 Win2k3 two node cluster.

I get all the way through the configuration and setup fails because it cannot start a task on the remote node. The error message indicates to check the task scheduler log file, which I have and I cannot find any 'errors' in the file.

Google/MSDN/Technet turn up nothing on multiple searches. Has anyone else run into this problem?

My installation account is a local admin on both machines, so is the sql cluster account. For the life of me I cannot figure out what's different for an x64 install vs 32bit....

Fixed the problem...

My account was not authoritative for the "Domain Services" group.

|||

I have the same problem, can would appreciate it if anyone could elaborate on this "Domain Services" group. What do you mean by not "authoratative" for this group?

Thanks.

Install fails on SQL2k5 because no IIS on Server

We have a new cluster that we are trying to install SQL 2k5 enterprise on and the security requirements will not allow us to install IIS on the same server as SQL. Is there a way around the requirement of having IIS installed on the server with SQL 2k5?It's not a requirement, unless you need RS on the cluster. You'll get a warning early on, but Setup will proceed if IIS is missing.|||The setup just closes itself down when it is doing the check for server components. There is no error at all. When we check the log file there is a statement about IIS not being installed or is disabled.|||Ugh. Well, the crash is likely due to another cause. Are you referring to summary.txt, or one of the detailed logs? If the former, I would proceed by looking at ...core.log and/or core(local).log. But at this stage there aren't going to be very many logs so check everything there for clues.

Installation and licencing about MSSQL 2005 Standard edition and clustering mode

Hi,

I have a question about using MSSQL server 2005 standard edition in Clustering mode.
I would like to build a msql cluster with only 2 servers (2 nodes).

I read here -> http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
page 5 that you can use MSSQL server 2005 standard edition in Clustering mode with 2 nodes.

But my question is :
Can I use windows 2003 standard edition (Clustering mode managed ?) or I only can use windows 2003 enterprise edition ?

J.Windows 2003 Standard supports a 2 node cluster and SQL Server 2005 Standard also supports a 2 node cluster, so yes.

install cluster sql 2005

I've setup a Windows 2003 Enterprise Edition cluster of 2 nodes, with sql2000
cluster and analysis services cluster.
I must install sql 2005 and analysis services 2005 without upgrade 2000
instances.
can you help me ?
What do you need help with? Knowledge base articles, etc. etc.....
DatabaseAdmins.com,LLC
"Gigi73" wrote:

> I've setup a Windows 2003 Enterprise Edition cluster of 2 nodes, with sql2000
> cluster and analysis services cluster.
> I must install sql 2005 and analysis services 2005 without upgrade 2000
> instances.
> can you help me ?
>
|||You will have to establish two new cluster groups, which will contain
dedicated IP addresses, network names, disks, and the SQL Server instance
for one, Analysis Services for the other.
You install SQL Server just like you normally would, but need to give it a
new unique Server Name and Instance Name.
Analysis Services on the other hand is truly clustered, whereas AS2000 only
used the general services resource.
Migrate a SQL Server 2000 Analysis Services cluster to a SQL Server 2005
Analysis Services cluster
http://support.microsoft.com/kb/910233
SQL Server 2005 Failover Clustering White Paper
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
SQL Server 2005 Upgrade Technical Reference Guide
http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en
Sincerely,
Anthony Thomas

"Gigi73" <Gigi73@.discussions.microsoft.com> wrote in message
news:1E59C379-13BF-4C60-B6C4-BAFFA95E4251@.microsoft.com...
> I've setup a Windows 2003 Enterprise Edition cluster of 2 nodes, with
sql2000
> cluster and analysis services cluster.
> I must install sql 2005 and analysis services 2005 without upgrade 2000
> instances.
> can you help me ?
>

Install additional instance in a cluster

I am looking for a best practice or any suugestion on the best way to install an additional Sql 2005 instance in a cluster environment. We have a production environment that is active/active/passive and need to install an additional instance with a little impact to the current production instances as possible. Ant suggestions or articles I can review?

Hi...see the whitepaper at the following address:

http://www.microsoft.com/downloads/details.aspx?FamilyID=818234DC-A17B-4F09-B282-C6830FEAD499&displaylang=en

It contains multiple sections and information on installing Sql2k5 in a clustered environment...

HTH