Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007


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 >>



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 >>


DevelopmentNow Blog