Hi, Here is our newly built cluster configuration: 2 node Active/Passive Windows 2003 Ent. SQL 2000 SP4 D:\ for SQL Data E:\ for SQL Logs 2 cluster groups: Cluster group SQL group SQL is running great, failover between nodes works good. However, during the cluster install and the SQL...more >>

When it comes time to remove a node from my 4-node/3 instance cluster, how will SQL Setup handle the multiple instances? Will I have the option to remove all three instances in one fell swoop, or will I have to re-run the uninstall process for each instance? I'm curious primarily for plann...more >>

We have 2 servers on a SQL 2000 cluster and now we would like to move away from a clustered enviroment to just a standalone machine. Any idea how I should proceed? ...more >>

I'm adding new nodes to an existing SQL Cluster Win2k SP1 SQL 2000 Ent. SP3a. Was wondering if I am going to have a problem since the IP addresses of the new nodes are on a different VLAN. Old node, Cluster IP & Virtual SQL IP are on 10.28.1 The new nodes are on 10.28.17. These IP addre...more >>

I sStill having cluster problems. Win2k3 SP1 SQL 2000 SP3a. Neither node has any hotfixes. Have looked thru postings on various sites and KB articles and not found anything that helps. See this is the cluster.log. So far nothing points to my problem. 00000f84.00000ef8::2007/05/30-01:...more >>

Hi guys, I had a very odd error occur over the weekend in a development environment, and I want to see if you've ever heard of this or had this happen. Environment: Active-Active SQL Cluster on Windows 2000 Server, SP4 One instance is called DEV, the other UAT SQL Server 2000 Enterprise E...more >>

Hi I am considering consolidating our environment to a Single SQL enterprise server. I'm curious about how the instances are handled.. if one instance gets updated how does this impact the other instances that are running. What effect does this have as far as the master db goes. Is there a si...more >>

There are no indications as to why. Every 8 minutes or so the event log records: Event Type: Information Event Source: Service Control Manager Event Category: None Event ID: 7035 Date: 5/29/2007 Time: 10:15:49 AM User: MEMOPROD\cluster Computer: MEMOSQL1 Description: The SQL Server ...more >>

Hello folks Windows 2003 SERVER (SP1) 8GB Do I need to restart OS after adding \PAE in Boot.ini? Thanks ...more >>

I have added two new nodes to the cluster and successfully installed SQL 2000 on both. I am trying to apply SP3a to both and am getting the message "18:01:30 One or more errors occurred while running remote setup on the clustered machines. 18:01:35 Setup failed to perform required operation...more >>

Hi all, I have recently changed IP addresses on my MS SQL cluster (the new IP addresses belong to a different network). Both physical node IP addresses and resource's IP addresses have been changed. Everything seems to work fine. The cluster is up and responding normally. The resources f...more >>

Can anyone let me know how to know that SQL Server is in Cluster through Enterprise Manager ...more >>

As the Sp2 de SqlSErver2005 in cluster must installed.? If I execute it in the server does not give option to select the instance me, it says to me that been it is not been worth. Thanks., (sorry my english) ...more >>

I am having trouble installing a brand new SQL2005 Cluster. Servers: DL585's, AMD x64, Windows 2003 Enterprise X64 with SP2 SQL: SQL 2005 Enterprise x64 (attempting to install anyways) Disks on each machine: C: OS D: Stuff Shared Disks: (via EMC ICSCI) M: (MSDTC Shared Disk) Q: Cluster Quo...more >>

Guys, I keep getting errors while trying to install SQL 2K5 server on Win2K3 x64 R2 SP2 cluster. The setup sequence was 1. Install SQL client/tools on all nodes 2. Install first instance of SQL server 3. Install SQL SP2 for client/tools on all nodes 4. Install SQL server SP2 for instance 5....more >>

I added two new nodes to our existing SQL 2000 server cluster (evicted 1 node 1st). No problems both new servers see the disks in the SAN but don't own them yet, of course. Ran into a problem installing SQL Server 2000 from the active node. I followed the steps in BOL and got to the "Remote...more >>

We had a problem with one of our servers which is apart of a cluster ( NODE1 ). It required reloading and now we're back to installing SQL. When we're on NODE2, its partner, and try to install SQL, it complains about NODE1 (see logfile). However, when we try to load SQL from NODE1 the same ...more >>

Hi, I am a new guy in Windows 2000 in SQL clustering. The SQL cluster cannot failover while 1 node is down. I would like to know if there is any standard checkup procedure or tools to collect information for further problme analysis. Thanks a lot. ...more >>

Hi All, I've been struggling with this issue for a few days now. We have 2node Server 2003 Entprise cluster with a fresh install of MSSQL 2000 SP3a. Everything works great until I attempt to simluate a node failure. Node 2 starts every service fine with the exception of the 3 SQL services: ...more >>

Ran into a problem in scheduling applying the Service Pack to our SQL 2000 active/passive cluster when we add new nodes. 50 plus databases and an unknown number of apps. I'm wondering what people do to ensure that no apps/people are trying to access the databases when the s...more >>

Hi all, i'm wondering whether any of you clustering experts could help. Our apps team look after a trading system that uses an HP DL360 server running SQL 2000 SP3a with a few small databases on it. This is a critical server as it stores trading system information, market orders etc. A req...more >>

Hello When I run (copied from BOL as an example of enabling AWE) the following statement I got an error.It did changes but with error message. Should I use WITH OVERRIDE? Can someone explain on subject? Is it BOL incorrect? sp_configure 'show advanced options',0 RECONFIGURE GO sp_confi...more >>

Hi, Does any one have any experience with the Hibernate layer [which acts as an abstraction layer between DB & application layers]? The factor which is bothering me is the absence of stored procedures. All transactions are done via this Hibernate Layer. What I am looking at is a system whic...more >>

Hello, We have a 2 node Active/Passive 32 bit SQL cluster. We wish to convert the cluster to 64 bit Server 2003 and 64 bit SQL 2005. It is of cheif importance that we don't have an exended outage as we are an ASP and our clients don't take well to this type of thing. If anyone can shed...more >>

Hi everybody, I'm looking for documentation about moving a fail-over cluster of SQL2005 between different IP network and between difefrent Windows domain. Some advice ? Thanks in advance. Pierluigi...more >>

I have recently been given a cluster of 2 * DL580s with Windows 2003 sp1 installed. I installed a SQL2005 sp1 virtual server and instance on Server1, and then a similar install on Server2. DTC is a separate group, with its own disk, network name and IP address; the Cluster group is separate wi...more >>

Hi everybody. I have been evaluating this feature in order to fail-over between two server in two remote site connected through a 1 Gbps link. Anybody had good experience about it? Can I mirror a SQL2005 Enterpise Itanium Edition with a SQL2005 Enterprise on a 32-bit system ? Can I do ...more >>

Thank you for Geoff N. Hiten provides me very useful info. Please experts confirm with the following. Please take alook at the follwing list and tell me whether it looks good to you. SQL Server 2000 (SP4)+ Windows 2003 Clustering. Two nodes , on each node there is ONE SQL instance. a...more >>

Hello, theres I have a question about sql server agent jobs on clustered environment.(active/passive) After using SSMS to connect the cluster db, set up a new job on sql server agent. The job doesn't start when time's up. how do I setup my job ? must I create job on each node ? ...more >>

Hi we have two 64 bit servers. One is AMD and another is Intel Xeon. We are thinking of building a SQL 2k5 cluster on them. The question is, is it OK to build a cluster as they are not the same architecture? They will both be running windows 2003 R2 64 Bit and SQL 2k5 64 bit. Can you plea...more >>

Hello! I´ve got some problems with starting a SQL Server 2005 Resource Group on a failover cluster. The installation of the Virtual SQL Server 2005 went well, except the message "All resources did not come online and therefore you will need to manually set the cluster restart option." ...more >>

We are planning to migrate from SQL 2000 32 to sq 2005 64 bit environment. Are there any known issues? ...more >>

Hi there, My customer is currently setting up a two node cluster. Since they are planning to use the same domain account to start all services, they are wondering if it’s OK to use only one domain group during setup. If they are using just one service account, are there any specific rea...more >>

Our current setup is: 2 Windows 2003 Advanced Server, members of 2003 AD domain SQL cluster: active/passive shared drives: 4 logical drives: quorum, logs, database, IIS (old SAN) Requirement: to migrate existing 4 shared drives to new 4 shared drives (new SAN). Only changes on two servers ...more >>

I'm new to SQL and clustering... Running cms 2002 sp2 with one SQL 2000 server backend and would like to ad a passive SQL instance but how is that done ? (is there a HOW to outthere ?) ...more >>

Does it get away from the shared disk limitation we have today that is considered a single point of failure ? ...more >>

I have an existing 2-node cluster on older hardware that is hosting 3 SQL2000 virtual server/named instances. The current OS version for both nodes is Windows 2003 Ent SP1. I intend on upgrading this to a 3-node cluster by adding two very new host nodes followed by removal of one older node...more >>

I know this has been talked about again, and again.. but This is what i got.. 1. 2x Windows 2003 Ent servers.. attached to a dell powervault 220s storage array that has a. 3x arrays, 1 for the the quorom, 1 for each clusternode's data disk 2. SQL 2005 In...more >>

I have a challenge!!!!!!!!!!! Requirements are: A. To replace the 2 nodes of SQL 2005 Cluster on Windows 2003 SP1, with a set of 2 new nodes (hardware). B. Keep all the settings of SQL 2005, Databases, .etc. the same way they are. C. WITH THE SAME IP ADDRESSES (no change to any ...more >>

i had to put in a long cross over cable for the private connection when i created the cluster and now that i have a new shorter cable i was wondering what would happen if i just replaced the cable while the system was live. will this break things or is it safe? Thanks Justin ...more >>

Based on the other threads I've read in the group, I'd like to confirm the steps needed to perform to add a third node to a cluster that has been running for a while on 2 nodes... After adding the new node to the cluster, for each instance in the cluster (assume: each instance is its own cl...more >>

I have a 3-node Win2003 ENT R2 / SP2 cluster hosting 3 named instances of SQL2000. Two nodes are active (2 instances on one node, 1 instance on the other) while the third node is passive. I'm interested in doing some testing of SQL2005 in a cluster environment (we know our DB & App work fin...more >>

Hi all, I was wondering whether it is possible to change IP addresses of cluster nodes without the need to rebuild the cluster? I have a SQL server clustered environment with 5 cluster nodes (physical servers). There are around 10 sql servers build on top of that (with their own IP addre...more >>

Hello, This is the second time in less than 2 weeks this has happened to my db server. Page (1:14440325), slot 6 for text, ntext, or image node does not exist.. I have performed a dbcc checktable and UPDATE STATISTICS “TBLNAME” WITH FULLSCAN after obtaining the table info. from th...more >>

Hello. I've built a cluster and followed the steps for creating a clustered Integration Services (SSIS) resource... http://msdn2.microsoft.com/en-us/library/ms345193.aspx I chose to put SSIS in its own cluster group, separate from the SQL Server cluster group. However, this webpage mak...more >>

I have a clustered environment which includes 2 nodes. The cluster fails across fine but the only issue is the disks do not appear in My Computer. When I connect to the disks through Windows disk management all the disks are there. Any ideas? Many thanks ...more >>

Hi I have a 2-node active-passive SQL cluster (with SSIS manually clustered in the SQL resource group). I want to convert to active- active by installing a named instance on the second node. Am I correct in saying that the new virtual server cannot have its own SSIS instance but must instead u...more >>