all groups > sql server clustering > march 2007 > threads for march 22 - 28, 2007
Filter by week: 1 2 3 4 5
Active/Active to 2x Active/Passive?
Posted by Jim Millard at 3/28/2007 2:21:31 PM
I have a 2-node active/active cluster (SQL2KSP4 on Win2003sp1)
supporting 3 instances (2 on one node, 1 on the other). I've received
funding to upgrade the instances by adding new host nodes with
better/faster hardware (Yay!).
The end-result should be the 3 instances running active on the t... more >>
Install server 2003 SP2 - active/passive cluster
Posted by decipher at 3/28/2007 1:06:03 PM
Hello,
I can seem to find any official Microsoft info on upgrading a SQl 2005
cluster to server 2003 sp2. The release notes dont mention an upgrade in a
cluster. I've done a few SP upgrades in a cluster before and the steps I
would take are:
-install SP on passive node, reboot
-move r... more >>
SuperSocket info: LoadNetlibs(....) : Error 11
Posted by John O. at 3/28/2007 9:34:01 AM
I have three SQL2000 Instances running on a two node cluster. Instance A runs
fine on Node 1 and Instances B and C run on Node2. All of these listen
successfully on TCP, Shared Memory and Named Pipes.
However, if Instances B or C are moved to Node 1 they fail to start and
Event Log has SQLS... more >>
Use more than 1 node?
Posted by JayKon at 3/27/2007 9:54:02 PM
I was reading the Microsoft white paper
(http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx) on clustering and noticed something I didn't expect.
It seems to say that only one node of a cluster may be used at a time and
that it is not for (any kind of) load balancing... more >>
event id 17055
Posted by snazzy at 3/27/2007 7:28:17 PM
Hi,
I having a problem starting sql server in a cluster. The error has the
description;
17113:
initconfig: Error 2(the system cannot find the file specified.) opening
'master.mdf' for configuration information... more >>
JDBC XA in a cluster
Posted by Padron at 3/27/2007 6:01:14 PM
I want to know how to install the JDBC XA driver in a cluster and make i
cluster aware.
Thanks,
Padron... more >>
SQL IP Address (Disk D:)
Posted by Joe K. at 3/27/2007 5:52:28 PM
I have a windows 2000 advanced server with SQL Server 2000. Should the
disks drives that store databases in them be in the dependencies property
within the SQL IP Address?
Thanks,
Joe K.... more >>
startup options
Posted by snazzy at 3/27/2007 5:08:00 PM
Is there a way to readd the startup options for a server after removing
them? The server will not connect without them and without being able to
connect the properties sheet does not come up.
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Database resource won't start after changing cluster subnet
Posted by Curtis Morrison at 3/26/2007 7:51:40 AM
I'm running a SQL Server 2000 SP4 2-node active/acitve cluster on
Windows 2003 Server Enterprise Edition SP1. I changed the subnet mask
of my public network config, as well as the MCS virtual subnet and two
database resource subnets (all are using the same subnet). DNS is
correctly resolving to ... more >>
SQL Cluster/Can't execute SSIS package using a proxy acc in sql jo
Posted by TheMask at 3/23/2007 8:41:08 AM
I've a problem trying to execute a SSIS package inside a SQL Job that uses a
credential/proxy account.
The sql job hist error msg is:
Message
Unable to start execution of step 1 (reason: Error authenticating proxy
DOMAIN\USER, system error: Logon failure: unknown user name or bad
passwo... more >>
Active / Active 2000 cluster.
Posted by SQLdba at 3/22/2007 7:44:39 AM
I'm looking at MSFT press book for SQL 2005 and they say and active / active
cluster needs two virtual server names.
Can anyone confirm or deny if this is true for SQL 2000?... more >>
SQL 2005 Upgrade
Posted by ctowndu33 at 3/22/2007 6:58:00 AM
We have a two node cluster with two groups on them (W2K3). Each group has a
sql 2k instance running and the groups each reside on a node, failing over to
the other if necessary. My question is that we were looking to upgrade, but
are only able to upgrade the one instance to 2K5. I assume th... more >>
|