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 > april 2006 > threads for april 22 - 28, 2006

Filter by week: 1 2 3 4 5

can I cluster sql 2000 on a ex64 windows cluster?
Posted by Mike at 4/27/2006 12:31:02 PM
Is this a suported configuration?...more >>


Mirroring
Posted by Per Schjetne at 4/27/2006 9:45:24 AM
Is there a way to detect if the principal or mirror is running the database? I want build my own altert system, sending an SMS whenever a automatic failover/failback happens. Per Schjetne ...more >>

Mirroring Failover/Failback
Posted by Per Schjetne at 4/27/2006 9:42:15 AM
I have been using Mirroring now for a while and put the system into production now after applying SQL sp 1. We have a setup with a witness, principal and mirror with certificates (the witness is on a webserver in a different domain, so we can't use integrated security). Automatic failove...more >>

communication error when test fail over
Posted by anoni at 4/27/2006 8:19:03 AM
I get microsoft odbc sql server driver tcp/ip sockets general network error and microsoft odbc sql server driver communication link faillure errors when I open our client app and while I did a cluster failover. Any reasons. Thanks. ...more >>

Cluster machines cannot see the domain??
Posted by Bradchand at 4/26/2006 12:09:02 PM
Does anyone else have problems with their cluster machines being able to see the domain. i have 2 clustering setups on 2 different subnets and none of the 4 machines can see the domain, list the domain server, or connect to any of the domain machines besides the domain controller. The dns is f...more >>

Minimum permissions needed for installation of SQL Server 2005?
Posted by Nils Loeber at 4/26/2006 12:51:27 AM
Hi all, the BOL state that a domain user account with two additional privileges (act as part of OS and connect as service) and membership in the local administrator group in all nodes is sufficient for installing SQL Server 2005. Has anybody successfully installed the product under these ...more >>

Cluster Failover Failed -- KB help anyone?
Posted by dwcscreenwriterextremesupreme NO[at]SPAM gmail.com at 4/25/2006 12:36:30 PM
Our second node in an active/active SQL cluster (Win 2K SP4/ SQL2K SP2) failed as a result (it seems) of a bad NIC at the public interface. Cluster and SQL logs seem to support that the failover went successfully, except for SQL job agent suddenly stopping on the first node. However, 2 hour...more >>

Bind failed on TCP port 1433
Posted by Manoj at 4/25/2006 9:22:01 AM
Hi, We recently change the IP of SQL Virtual server, the IP was updated using the installation wizard. SQL Server starts but does not listens on port 1433, below error is logged in event log "19012 : SuperSocket Info: Bind failed on TCP port 1433." "SuperSocket info: (SpnRegister) : Error...more >>



How to apply the SQL SP4 on Active \ Active cluster?
Posted by S Siva Prasad [SIVA] at 4/25/2006 5:12:02 AM
On SQL Server 2000 Enterprise Edition with SP3a running on Windows Server 2003 Enterprise Edition in a Active \ Active Cluster. There are two nodes on the cluster. Both nodes are active. There are 6 instances of SQL Servers running on each nodes. The box is with 24x7 availability....more >>

Seperate instances of SQL on differeng VM's
Posted by Cluster_Quest at 4/25/2006 3:01:02 AM
I am being asked to migrate various SQL Databases, 2000 and 2005 to a single large clustered enviroment. I believe that you can install a single seperate instance of SQL 2000 on a Virtual Machine (this is required as they each use differeing collation sequences), however, can both SQL 200...more >>

Mirroring in SQL2005 not supported bij Microsoft?
Posted by Jeroen van Zutphen at 4/25/2006 12:00:00 AM
Hi, We're planning to implement mirroring with SQL-Server 2005. On: http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx Microsoft advises againts using this technology in production situations. What are my alternatives? Regards, Jeroen ...more >>

Shared Database (Active/Active Clustering)
Posted by Leila at 4/24/2006 12:05:07 AM
Hi, Is it possible to have a database (on SAN) that two active nodes of clustering environment work on it simultaneously? Thanks in advance, Leila ...more >>

Load Balance Clustering
Posted by Leila at 4/24/2006 12:00:00 AM
Hi, Are there any solution to implement load balancing on one database between two nodes of cluster? Thanks in advance, Leila ...more >>

SQL 2000 Cluster recovery after ethernet switch outage
Posted by Graham Morris at 4/24/2006 12:00:00 AM
I have a two-node SQL Server 2000 cluster. Each node has two network interfaces - one interface on each is connected to its opposite number by a crossover cable, and the other interface is connected to an gigabit ethernet switch, to talk to the outside world. All standard stuff. (Both nodes ...more >>

Hardware Match
Posted by Leila at 4/23/2006 10:16:31 PM
Hi, Our company has a HP Proliant DL380 and we need another server to establish a clustered environment. Should we but exactly the same server with the same hardware configuration or if the new server is listed in HCL will be enough? Thanks in advance, Leila ...more >>

Lost connection with SQL Server
Posted by Cedric at 4/23/2006 10:09:02 PM
Current topology - Sql Server 2000 on Windows 2003 Cluster The Client access to the database started to degrade on a particular database, when we tried to access the SQL Enterprise Manager - it result in connection failed. however other databases were available. Being in a cluster we mo...more >>

Public and Private Network
Posted by Leila at 4/22/2006 12:00:00 AM
Hi, I have problem in understanding term "Public Network" and "Private Network". I need some clarification. For example in this sentence: "Disable NetBIOS for all private network cards before beginning SQL Server Setup" Many thanks in advance, Leila ...more >>


DevelopmentNow Blog