Groups | Blog | Home


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 > march 2007 > threads for march 8 - 14, 2007

Filter by week: 1 2 3 4 5

Create SQL sever 2005 clustering in existing non cluster SQL 2005
Posted by James at 3/14/2007 10:56:08 AM
Hi (I send one before but looklike it did not pass through) I have questions as below. 1) On production server win 2003 64 bits, I can not see Cluster by ClusterAdmin, Quarum is the folder in C:\Drive, SAN is only shared drive, SQL logon by local system account, Sql connect as (local) or Com...more >>


SQLXML4 fails with 3221225478
Posted by jwgoerlich NO[at]SPAM gmail.com at 3/14/2007 10:47:38 AM
Hello group, I am building a SQL 2005 Standard failover cluster on Windows 2003 Enterprise. Everything looks alright; dual HBAs, dual NICs, MSDTC as part of the Cluster Group, all hotfixes applied. The server setup completes successfully, however, the remote workstation components fail. Sp...more >>

MSDTC - Give it a dedicated group or use Cluster Group?
Posted by jwgoerlich NO[at]SPAM gmail.com at 3/13/2007 12:44:51 PM
Hello group, I have been testing out SQL 2005 clusters. I noticed that putting the "Distributed Transaction Coordinator" resource (i.e., MSDTC) in either its own cluster resource group or in the default Cluster Group with the quorum works. The latter would be my preference because it saves an...more >>

install cluster sql 2005
Posted by Gigi73 at 3/13/2007 4:13:35 AM
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 ? ...more >>

3 Node W2K3 SQL 2005 Cluster
Posted by hiddo.vanloon NO[at]SPAM gmail.com at 3/13/2007 3:12:05 AM
All, I've setup a Windows 2003 Enterprise Edition cluster of 3 nodes. Everything is attached to a san (CX500). Just installed SQL 2005 and all works fine. Is it possible to have this cluster with 2 active nodes and 1 passive node? i've setup a drive (r:\) and it's online but only avaiabl...more >>

MSDTC Required?
Posted by Cgal at 3/12/2007 4:43:34 PM
I am preparing for the installation of SQL Server 2005 Standard on a two-node cluster. The SQL Server books Online" topic named "Before Installing Failover Clustering" indicates that you must install MSDTC if you are installing the Database Engine and SSIS, Notification Services or Workstat...more >>

System Memory Setup - Boot.ini
Posted by Dragon at 3/12/2007 10:29:57 AM
Hi, I have a two node Windows 2003 Adv. Cluster setup. I have also installed a clustered instance of SQL2000 Ent as well as SQL 2005 Ent each on this cluster. Each of my nodes has 16GB RAM. My goal is to setup 7GB RAM for each of the SQL servers and leave 2 for OS and other Apps etc. I a...more >>

setting up new cluster using sql 2005
Posted by bijupg NO[at]SPAM hotmail.com at 3/12/2007 6:33:05 AM
Hi GUYS, Currently i am having two seperate 2 node clusters of sql 2000 one for OLTP and other for Reporting each having seperate MSA.in the new environment I am planning to have two 2 node clusters of sql 2005 but both clusters will use same MSA . is it advisable or better to go for seperat...more >>



SQL Connectivity Lost after Reboot
Posted by Vick Shaw at 3/12/2007 12:00:00 AM
Hello, Last Friday we recycled all our production servers including a 2 node SQL 2000 Cluster. Eversince I'm unable to establish connection between one of the SQL Node and a webserver. The webserver is located outside the firewall. Appraently the webserver is able to establish connection to the...more >>

"Setup failed to perform required operations on the clustered nodes" - SP4 install on failover node
Posted by Bowulf at 3/9/2007 7:04:14 PM
I created a single node SQL 2000 cluster for testing purposes on Windows 2003 SP1 box. In time, the application folks wanted to test failover and requested a failover node. I added the failover node to the cluster group and to the SQL cluster. I verified failover to the new node of the quoru...more >>

Startup problems on one of 2 nodes
Posted by R Stovall at 3/8/2007 12:07:57 PM
We have a 2 node A/P cluster running Server 2003 and SQL 2000 SP4. Our DBA and I moved all of the database and log files (including master) to new LUNs on the SAN. Everything is fine on the node we were using at the time, but when we try to move the SQL resource to the other node it will not...more >>

SQL Resources FAIL when restarting "Passive" Node
Posted by Pat R. at 3/8/2007 10:54:31 AM
I have a two node cluster running W2K3 EE SP1 and MSSQL 2000 SP4. IBM 366 Quad duo core w/ hyperthreading and 16 GB RAM each. I am hosting 5 instances "Multi-instance" of MSSQL combining a total of 120 Databases - Eggs in one basket for sure. MSDTC separated from the instance resources and f...more >>


DevelopmentNow Blog