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

Filter by week: 1 2 3 4 5

Changing IP Addresses of a cluster
Posted by DBADave at 4/7/2004 5:26:02 PM
I will be relocating a SQL 2000 cluster onto a new subnet of a corporate network and will need to change the 'public' IP address of the cluster nodes as well as the virtual IP address. In doing this, I want to make sure that I have the proper process down correctly 1. Change the IP addresses of e...more >>


Only Administrator May Connect
Posted by Dan at 4/7/2004 4:56:42 PM
What would cause a SQL Server 2000 Clustered server to output the error message listed below. This is a Windows 2000 Advanced Server. The error was pulled out of the SQL Server Errorlog. Error Message: Login failed for user 'DALLAS\BLKSDRRT'. Only administrators may connect at this...more >>

MSDTC
Posted by ash NO[at]SPAM discussions.microsoft.com at 4/7/2004 12:26:14 PM
We have installed sql server 2k on windows 2003. We are having problems with the MSDTC working correctly. We cannot get this service to fail over. This is the error: MS DTC's log information has not been configured correctly in the shared cluster registry. Error Specifics: d:\srv03rtm...more >>

Active/Active clustering solution for SQL SERVER
Posted by David Liu at 4/7/2004 8:35:47 AM
Basically, I need to have real active/active cluster solution on SQL server(any MS platform). The windows failover clustering tech is share nothing clustering , so can not do the load balancing stuff( distribute transaction traffic between servers). Only product I know on the market is PolyS...more >>

Installing SQL Server 2000 on XP Pro
Posted by Troy at 4/6/2004 4:11:06 PM
I've got SQL Server 2000 Enterprise Edition & running XP Pro, but it errors on install. Displays "Not supported on this operating system". What can I do, I need use Enterprise Manager & ect Thanks in advanc Troy...more >>

Start & Stop Service
Posted by Paul Ilacqua at 4/6/2004 3:56:01 PM
In SQL Server 7.0 NT 4.0 Ent. How do I start and stop the SQL Server service. When I stop the service with the service control applet, it just restarts itself. How can I stop this with the cluster admininstrator? Thanks Paul ...more >>

Cost is out the roof!!! Is there a better solution
Posted by M.Siler at 4/6/2004 2:36:27 PM
We are installing a Active/Passive cluster for our servers. We want to make sure that we don't go down. We are looking at installing an SQL cluster, but I'm being told that because we want to also open out database up to out Extranet for our customers that we are going to need a per processor li...more >>

SP3a install
Posted by Paul lane at 4/6/2004 12:06:03 PM
I need to upgrade my SQL 2000 cluster to SP3a. The cluster is an Active/Passive 2 node setup connected to an EMC 4700. Has anyone done something similar to this? What are some of the "gotchas" I need to be aware of? What are some good documents that you used? Any info on this would be greatly apprec...more >>



Test setup of a clustered environment.
Posted by Venkat Alluri at 4/6/2004 9:36:04 AM
Is it possible to setup a clustered environemnt using 2 desktops. I have Windows 2000 AS software and SQL Server Enterprise Edition software at work and I can use it. How to setup the cluster? Also do I need to buy additional hardware Ven....more >>

Move SQL Server cluster between SANs
Posted by Bjorn Mobak at 4/6/2004 12:56:01 AM
Hi. I'm in the process of migrating from a HP XP SAN to an EVA5000. The big issue is how to transfer the SQL Server disks. My plan is to give the cluster access to disks on both nodes. Change the Quorum drive to the EVA quorum disk. Then the fun part starts. Is there a proven path f...more >>

Deploying MS03-031 patch on cluster
Posted by Joe Huffman at 4/5/2004 4:27:25 PM
Hi All~ Now that we have taken the big step to a clustered SQL enviroment we are ahving problems deploying some hotfixes and patches to the cluster. Of course I have been getting the usually, it's not our product it is an MS problem, and it's not an MS problem, it's someone elses problem....more >>

SAN questions
Posted by kob uki at 4/5/2004 2:53:47 PM
Hi, Does anyone has experience having Solaris True64 VMS Exchange SQL Server Oracle on 1 SAN solution? Anyone could comment on it? Personally, this freaks me out. Thanks, kob uki ...more >>

Clustering SQL Server with four 2-way, or two 4-way?
Posted by Corrupter at 4/5/2004 1:39:20 PM
We are considering moving from a single 2-way system sql server to a multi-processor cluster. However, we can't seem to get an answer from anyone on what will provide better performance: a cluster with two 4-way nodes with 16gb of memory and access to a SAN or four 2-way nodes with the sa...more >>

Windows 2003 Editions
Posted by Vic Martin at 4/5/2004 8:26:06 AM
which edition of Windows 2003 do I need for a 3-node cluster...more >>

Active\Active Shared Database.
Posted by Marx at 4/5/2004 8:26:03 AM
Hi Is it possible in SQLServer to setup an Active/Active cluster between two servers and access the same database Like Oracle's Real Application Clusters, can this be achieved in sql may be using Federation On a high level, i would have two sqlservers clustered, and i would federate the data...more >>

cluster admin - rights needed ?
Posted by Hassan at 4/4/2004 7:02:21 PM
I have read that the cluster admin needs to be a domain admin to setup a cluster. I am using Win2003 and SQL 2000. Is that true ? If not, what are the minimum rights required as our n/w admins are hesitant about creating it as a member of domain admins ...more >>

Dual Nics problems with SQL 2000 Cluster
Posted by caicia at 4/4/2004 6:26:05 AM
HI I have two Dell Servers(For high avaiablity each machines have three intel gigabit Networkcards,one for heatbeat,two for clients link) with a disk array.I have installed Windows2003 and setup the Cluster,it's worked well,then i installed sql server 2000 EE on them through many articles(I created...more >>

Services login policies and rights question
Posted by frankm at 4/2/2004 4:09:19 PM
Scenario is Windows 2003 Enterprise and SQL Server 2000 Enterprise. I need to know what rights, policies and / or other configurations are needed for SQL Server to install on a cluster. (for that matter, any SQL Server install on / in a 2003 environment). It seems that things may have changed ...more >>

Windows 2000/2003 cluster problem
Posted by Paul Dube at 4/2/2004 3:09:26 PM
I am having a problem failing over in my SQL cluster. One node is running Windows 2000 and the other (the new one) is running Windows 2003. Both are running SQL 2000 SP3. I am unable to fail over one instance. It gives the following errors: Let's call my servers SQL1 (Windows 2003) and SQL2 (Win...more >>

Installing cluster in Windows 2000 + 2003
Posted by Paul Dube at 4/2/2004 1:37:20 PM
I have a Windows 2000 that crashed and was part of a active/active SQL cluster (SQL 2000). Instead of reinstall the box with Windows 2000, I reinstalled it with Windows 2003 Advanced. In Cluster Administrator (on the Windows 2003 box), I am trying to add the node, and I always get the followin...more >>

Remote server setting -- Urgent
Posted by George at 4/2/2004 11:16:07 AM
I have a sql2k clustered server. now this server need remote server connection to other server. I have set up remote server on both site, but only one way works: connection to clustered server is ok while from clustered server I can not get the remote site. error msg: Server: Msg 17, Level 16, Stat...more >>

Add internal drive to one of two nodes within MS 2000 Cluster?
Posted by ericwoven NO[at]SPAM yahoo.com at 4/2/2004 10:29:50 AM
If I offline one of two nodes in a cluster, can I add an internal drive to the offlined-node, then bring the node back online into the cluster? Will this new drive cause any problems? Thanks....more >>

Upgrade NT4.0 Domain To Windows 2003
Posted by Steve at 4/1/2004 8:06:03 PM
I have been tasked with migrating our NT 4.0 domain to a Windows 2003 domain structure. I have a Windows 2000/SQL 2000 Cluster running critical applications in my current NT 4.0 domain. I've created a separate trusted 2003 domain, and I intend to move all of my accounts over to it using the Acti...more >>

No Cluster to Cluster
Posted by Nick Maxwell at 4/1/2004 4:14:25 PM
We are going through a process of clustering windows 2000 & sql 2000. We currently are running windows 2000 server & sql 2000 on a single server, non-clustered of course. We have the procedures down for creating the windows cluster and then the sql cluster, but have questions as to migrating t...more >>

SQL Server Setup don't recognize Win 2003 EE Cluster
Posted by Sefirah at 4/1/2004 8:29:25 AM
I have read lots of articles about and I think [hope] i'm close to solution but... I have two Windows 2003 Enterprise Edition in a two-node cluster (both are Domain Controllers) and I want to install SQL Server 2000 over this cluster as a prerrequisite to install SMS 2003. The cluster has ...more >>


DevelopmentNow Blog