all groups > sql server clustering > december 2006
Adding drive dependencies to WIN2k/SQL2k cluster resource
Posted by zoneranger NO[at]SPAM gmail.com at 12/28/2006 6:47:00 PM
I need to add two additional SAN attached volumes to be dependencies
for my SQL Server Cluster resource. Do I have to restart the cluster
service for this to take affect? Is there another way for the cluster
resource to re initialize it's dependencies without restarting?
... more >>
Clustering question: Why would the sql server name resource fail to maintain the computer account in AD?
Posted by Wilson U at 12/23/2006 3:24:43 PM
Hello,
We have SQL 2005 installed on Windows 2003 active/passive cluster. A domain
account is used in the cluster setup. The sql server name has the 'Enable
kerberos authentication' checked to register and maintain its record in AD.
It can create the computer object in AD but about every ... more >>
Getting Cluster Metadata
Posted by Vijay Ram S at 12/22/2006 12:44:01 AM
Hi
Is there any TSQL query/function/procedure that would return the metadata
about the SQLServer cluster?? I need to write a program to get the
information about the SQLServer application cluster. I need to get
information like participating nodes in the application cluster.
Any in... more >>
Problem rebuilding node: Kerberos error on target node
Posted by Wayne at 12/21/2006 10:06:53 AM
OS: Windows 2003 SP1 64bit Enterprise Ent.
SQL 2005 Standard Ent SP1 installed.
Active/Passive Cluster setup
I have evicted and rebuild the node and I have verified the cluster groups
are working excluding SQL. I attempt to install from the other node and I am
good to go until I hit "Instal... more >>
need help setting up resources
Posted by dmcmillan via SQLMonster.com at 12/20/2006 10:52:44 PM
I haven't set up a failover cluster before and hope someone can help.
It is Windows 2003, SQL Server 2005 failover cluster. We have set up 2 nodes
emrdb1 and emrdb2, cluster name is emrcluster.
Do we need to add SQL Server Agent as a resource?
How do I set up physical disks? I need C:, E:, F:, ... more >>
Physical move of clustered SQLServer
Posted by adb2303 at 12/20/2006 2:17:40 AM
Hello,
All of our Intranet servers are physically moving from one datacentre
to another. We have already catered for the front-ends, but I need to
find out what needs doing to our clustered SQL Server 2000 environment.
We have a 2 node Win2k cluster, with SQL Server 2000 Enterprise
Edition... more >>
CLUSTERING ANALYSIS SERVICES
Posted by Xavier Catillon at 12/19/2006 9:01:54 PM
Hi All,
I would like to know if it's possible to have on the same cluster instance,
the cluster server and the analysis services.
Or if I have to configure another cluster instance for the analysis service.
Thanks for your reply.
Xavier.
... more >>
SQL Cluster and Firewall
Posted by Alex at 12/19/2006 4:36:20 PM
Hi,
We need to implement a solution in which two Windows 2003/ SQL Servers 2000
based servers being located behind firewalls in two different locations,
together form SAN attached geo-cluster systems. SQL Server ports will be
opened on firewall to DMZ and accessible by Web servers located i... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Move from active/passive cluster to active/active
Posted by hiddo.vanloon NO[at]SPAM gmail.com at 12/18/2006 5:46:53 AM
Hi,
sorry for my lack of knowledge on this issue..
I've installed a Windows 2003 Cluster with SQL 2005. Works like a charm
when i do a failover.
Now i want to make this cluster active/active (multi instance) so no
connection is lost when a node goes down, but can't find any info on
how t... more >>
Relocate SQL Cluster to new SAN
Posted by cute.fluff NO[at]SPAM gmail.com at 12/14/2006 6:57:30 AM
Hey all,
im having a crisis here... i have 14 days to reloacte my SQL Cluster
from its current SAN to a new storage.
i have 2 win2k3 ent servers running MS cluster service and SQL 2000
Cluster running on them (both servers run on the latest SP for sql and
OS with all latest updates)
i have n... more >>
fail to install sql server 7.0 to window2000 server cluster
Posted by linbiao at 12/12/2006 8:07:00 PM
we have a 2 nodes win2k server cluster which installed sqlsrv 7.0, the
primary one failed, and the secondary take over the service as design.
we do not have system backup for the primary node, and we got a blue screen
for that one. it seams like that some registe records are crashed. we decide... more >>
Connection failures
Posted by kristan.mcdonald NO[at]SPAM googlemail.com at 12/12/2006 7:13:25 AM
Hi all,
I need a bit of help with a really strange problem we've got with out
SQL cluster. The setup is - 2 windows 2003 nodes, sharing a das, sql
2000 enterprise sp4. Cluster was up and running for a couple of days,
the one of our offices said they could not connect to it. This box is
held i... more >>
disk failure on cluster array
Posted by icemon at 12/11/2006 9:04:16 PM
We experienced a disk failure on the cluster array. It's a
active/passive SQL cluster. I was told by dell that we must powerdown
the passive before replacing the failed drive because otherwise both
servers will attempt to rebuild the array. Is this true? Can you
simply swap out the bad drive... more >>
Clustering Question...
Posted by Hassan at 12/10/2006 12:15:06 PM
Say I have a current standalone SQL 2005 node that is SAN attached.
How can I get it clustered by adding a passive secondary node to it ? Can I
do so ? Or do I have to setup an entirely 2 new clustered set of servers and
move the database from the standalone server to it ?
I am trying to a... more >>
Cluster Resource replacing physical server
Posted by Bowulf at 12/7/2006 12:07:08 PM
We are replacing an existing SQL 2000 EE server with a clustered
resource by the same name. We have done this before, but are running
into an issue on this install. Here are the steps we have performed:
* Migrate databases as files
* Shut off original server
* Delete original computer account... more >>
SQL Management Studio On Only One Node
Posted by Tam O'Shanter at 12/1/2006 7:58:06 PM
Greetings,
Recently setup 3 SQL Server 2005 Clusters and noticed that SQL Server
Management Studio is only installed on one node of each cluster.
I'm thinking it was installed only on the node I used to install the SQL
Server Virtual Server.
Two Questions:
1. Is this by design?
2.... more >>
|