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 > may 2004 > threads for may 1 - 7, 2004

Filter by week: 1 2 3 4 5

Can't get SQL 2000 installed on new node in Cluster
Posted by Pat Hall at 5/7/2004 2:26:07 PM
We can't get SQL 2000 to load on the new node (successfully added to the cluster). We are using the procedure How to add nodes to an existing virtual server (Setup)(from BOL). When asked for computer name we entered the SQL cluster name for the virtual server. When asked for the logon we used the...more >>


tempdb file placement on active/active
Posted by spee at 5/6/2004 9:56:03 PM
Given tempdb is recreated on startup is there any reason it must reside on a shared cluster resource After installation to the shared resource (because other systemdbs will need to reside here), i would like to move tempdb to internal disk Has anyone tried this? Or have any reference material th...more >>

MSDTC on Windows Server 2003
Posted by jf NO[at]SPAM uk.com at 5/6/2004 7:10:25 PM
I am running a sql server 2000 cluster on a windows server 2003 machine. Every time I try to install MSDTC it fails and this is what is in the Event Viewer: MS DTC setup failed to populate the shared cluster registry. The DTC resource will not be able to come online.Error Specifics: d:\n...more >>

Clustered Active/Active in Single-user mode
Posted by Moglia Michele at 5/6/2004 11:06:09 AM
What is the right procedure to start an instance of a clustered Active/Active Sql Server The online-book unspecifically writes From a command prompt, enter: sqlservr.exe -c - But some KB Technet articles say do start/stop SQL instance only from cluster administrator So how to do it Thanks...more >>

MSDTC stopped working on primary node
Posted by suprfly52 NO[at]SPAM yahoo.com at 5/6/2004 8:07:23 AM
Looking for some advice on an issued that just popped up. Not sure if this was the cause but after applying MS04-011 and 012 MSDTC will not run on the primary Node. Main application error message is: "MS DTC was unable to start because the installation of was not configured to run on a cluste...more >>

Recognize Server In Cluster
Posted by david_segal NO[at]SPAM hotmail.com at 5/6/2004 6:58:23 AM
Hi All, I'm posting it here since it seems that the way we access an SQL server in Culster could be very similar. I'm trying for quite a few days, without any success, to find out how to obtain basic info from a Clustered Exchange 2000, such as Mailboxes list, Storage Groups..., etc. How sha...more >>

Cluster and User Defined Functions
Posted by Rob Heyman at 5/5/2004 11:15:00 PM
Has anyone had difficulty with UDF's in a clustered environment? We have some DTS code that references a user defined function. When we run the DTS package on non-clustered servers, the DTS package executes in several minutes. However, when we run the same code against the database in a clus...more >>

Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b
Posted by Bill at 5/5/2004 9:34:20 AM
Hi, I got this error occasionally. I am using two nodes SQL Server 2000EE cluster running on Win server 2003, it's an Active/Passive configuration, and they pull data from a public external RAID. I have applied all latest SPs and installed MSDTC properly. SQL is still working fine. It s...more >>



Error: 17883 - The scheduler 0 appears to be hung...
Posted by franco at 5/5/2004 6:36:52 AM
Environment: Clustered SQL Server 2K sp3a (single instance) Product version: 8.00.760 Problem: I end up in error 17883. I am aware that the solution is to apply this patch: 821277 MS03-031:Security Patch for SQL Server 2000 Service Pack 3. I am also aware that after you install this cumulat...more >>

Step Guide Setting up SQL 2000 with W2K3
Posted by Kok-Mun, Ho at 5/4/2004 11:11:01 PM
Hi all I'm looking for step guide to set up SQL 2000 with W2K3. I could only find SQL2000 with Windows 2000 Thanks Cheers Kok-Mun, Ho...more >>

ACTIVE/ACTIVE configuration
Posted by Jeff at 5/4/2004 9:25:40 AM
We are looking at installing a 2 Node ACTIVE/ACTIVE SQL Server configuration utilizing two DELL PE6600 servers, both connected via FIBRE to a DELL CX200(CLARION). The OS will be clustered in a ACTIVE/ACTIVE configuration as well. The main purpose for attempting this is more for spreadi...more >>

Win2003 and MSDTC
Posted by Travis Butynski at 5/3/2004 11:02:06 PM
I've read the post/replies explaining how to setup MSDTC on a Windows 2003 server which is definitely great information. At this point, I still have on problem. The KB article says that Microsoft doesn't recommend that you create the MSDTC resource in the default Cluster Group or in the group(s...more >>

Win2k sp4 and post sp4 updates
Posted by Joe48184 at 5/3/2004 10:36:02 AM
Hello I need to update a clustered win2k os. The service pack applied on this clustered server was sp3 a server build time. I've applied the SLQ sp3 and security roll up with no problems. However, I'm a bit nervou and not sure the order in wich to apply the windows updates. Do I apply the updates...more >>

Application Databases storing location
Posted by Anonymous at 5/2/2004 11:57:50 PM
We have SQL Database in Cluster volume F: Cluster volume is mounted in the primary server A1. We have production and test databases of the applications stored in the Cluster Storage F:. Is it possible to store all the test databases of the applications in the C:(local harddisk) of the primary...more >>


DevelopmentNow Blog