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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|