I am having difficulty changing the virtual ip address of a sql 2000 cluster on Windows 2003. The disk fails and I have tried to change per microsoft articles to fix, without success. I am thinking of unclustering the servers in SQL and then trying. I found articles to do this in SQL 7, but no...more >>

Error 17 SQL Server does not exist or access denied We have two clusters , one with four nodes, the other with two. We are encountering difficulties on some with communication going one way, say between SQL instance 1 to the default instance running on the other node. The strange thing is ...more >>

Hi, We are building a new Win2k Adv, SQL 2000 cluster. what is the best way to install the anti virus software after the cluster has been built.....do we need to pause the the node, and then install anti virus software etc.... Cheers Ray ...more >>

All, My problem is a funky one. I have a 2003 cluster that appears to be properly functioning. and SQL 2000 in Active/Active I have 3 Instances of SQL Server 2 were running on Node A and 1 on Node B. On of the SQL Instances on Node A appeared to be working properly, could access it throu...more >>

Hello group, today we tried to install a SQL 2k cluster very unsuccessfully. Would need your support. What we have: 2 Server (node 1, node 2) with external storage installed as a cluster (MSCS). Partitions are C (for node 1 and 2), e and q (quorum db) - both on the external storage. O...more >>

I know I've been asking a lot of dumb questions here lately but - One must learn somewhere. In my test lab cluster that I'm building, W2k3 Cluster admin put each of my physical disks in its own group. Now I'm keep one for the cluster group, and one for the MSDTC, which leaves me four. I'm...more >>

Plat form: Windows 2003 enterprise ed, SQL Server 2000 Failover Clustering SP3A enterprise ed. Action: Change some registry keys after bring SQL resources offline. I am trying to change the following registry keys to point to new location on registry at Master node, member node and virtual...more >>

Morning, We have two nodes in a sql cluster. The "Lan" connection on one of the servers fails at different times and I can't track down the problem and I am not sure where to start. I have changed NIC's Cables, Switches and still no luck.. Any suggestions where to start would be apprecia...more >>

Hi everyone, We have the following setup: Windows 2003 Server Enterprise edition Cluster with 2 nodes. SQL Server 2000 Enterprise edition Virtual Server1 - currently Active/Passive Cluster. Shared storage and Quorum drive on SAN. Database1 on Virtual Server1. The goal is to set up a report...more >>

I have changed Ip address(e.g from 192.168.1.x to 172.16.1.x) on a cluster with a/p mode.When I have done this,I found the cluster is not work. Event view said instance cant bind with 1433,however 1433 is in listening state. ...more >>

I am trying to build an iscsi SAN using HP DL380 with 2 x Alacritech TOE cards Cisco 4948 Switch and Intransa 5000. If the server is booted with ethernet inserted into the alacritech Iscsi cards it hangs. The server will boot without the ethernet inserted. When ethernet inserted the initiato...more >>

Happy Christmas everyone, I have just visited an active/active win2K(sp2) and SQL 2000(sp3a) cluster that is not too happy. The virtual servers will not fail over between the nodes as the MSDTC will not restart if moved. Full text indexing exists only in one virtual server and needs to be...more >>

Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even if the MSDTC has its own IP Address and Network Name? In my planned multiple instance sql cluster, I can see giving up a physical disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC doesn't use ...more >>

I am trying to setup SQL server on MS Cluster Servers (with window 2003 OS). I am always get following error during installation "Setup failed to perform the required operation on the cluster nodes" Base on sqlstp.log file (see below), it looks like cause by 10:35:07 C:\WINNT\TEMP\SqlSetup\...more >>

I am wanting to set up a single quorum device server cluster on Windows 2003: 1. Does anybody have a simple document describing the hardware required, and the procedure? 2. Can this be upgraded to a multiple quorum cluster later? ...more >>

I inherited a 2000 Advanced Server SQL 2000 Ent, Active-Passive setup. The architect never got it working correctly, so he turned off the second node and just left it running of the primary. We've been having reporting errors in our application so I checked to see if everything was up-to-dat...more >>

My instance name on one server in a cluster is 'PSPSQL1\PSP1_INST1'. I have a linked server with another instance on another server - 'PSPSQL2\PSP2_INST2'. When I query a a table across server referenceing it as follows - PSPSQL1\PSP1_INST1.databasename.dbo.tablename - I get an error that ...more >>

I am planning to have two win2kservers in a cluster hosting two SQLServer (SQLA, SQLB) Instances. When both the Win2kServers are active, SQLA will be running on Win2kServer1 and SQLB will be running on win2kServer2. My question is, when an application from win2KServer1 connects to SQLB (run...more >>

Dear all, i am planing to implement a Windows 2003 Cluster with MS SQl 2000 Enterprise Edition. I have 2 Nodes (4 * XEON MP Processors) with 8 GB RAM per Node. I have the need for 6 SQL instances and would like to implement a active-active cluster. What do you think it the best way to confi...more >>

I have a load balancer, 2 web servers and I trying to determine the best backend database architecture, here are my 3 choices. 1. 2 Identical database servers running MS Windows Server, MS SQL Server 2000 and Double-Take (NSI Software) with Fail-Over capabilities 2. 2 Windows Serve...more >>

Right now I am working on a project that requires two active SQL servers with different local web servers accross geographic locations. I read an article on Active-Active SQL servers and am seeing some possiblity in SQL 2005 for this situation to work but in SQL 2000 is there any way to have ...more >>

Platform: Windows 2003 enterprise Ed. Failover Clustering SQL Server 2000 Enterprise SP3A. We followed the instruction and configured SQL cluster Failover Clustering. Quorum and TempDB drive are on the same physical disk drive but different logical partition. Can we perform the following...more >>

We are thinking of using failover clustering with SQL Server 2000 on Windows 2003 Server. One question we have is if a failover does happen, will users who are using the system need to re-establish their connections? Our app is written in Cold Fusion and uses CF DSNs to connect to SQL Server. ...more >>

Hi, I need to install the Veritas backup software on an SQL cluster. When installing Veritas it asks if you want Veritas to use the existing SQL database or create its own environment. Is it better for Veritas to use its own database, to keep things seperate and to ensure that the SQL c...more >>

MVPs i do not know if this is the right newsgroup, but i do not know where else to post this question. We have two t-node cluster environments W2k3 with sql200sp3. For disaster recovery we are running a named virtual sql instance on the second cluster which is the destination server for ...more >>

Are there any major issues in clustering SQL 2000 on a Windows 2003 cluster? Will with is also be fine for SQL 2005 on a Windows 2003 cluster? ...more >>

Hi , Can we convert the Active passive cluster to Active Active mode . Please advise . Thanks ARR ...more >>

It's too bad day. I deleted "sql server/sql agent/fulltext" three resources in the cluster management. How can i fix it? i try to reinstall virtual server,but it says : the default instance was existed.Help me plz! ...more >>

We have an Active-Passive SQl 2000 Cluster setup . While testing the failover , it only works when the primary Server is shut down . I want the failover also to happen if SQL Server Service is stopped on the primary or a shared disk is not available. However, on stopping SQL Service on P...more >>

Hi, we are running w2k3 2-node cluster with sql2000sp3. Both nodes have 4CPUs and 6GB RAM. The system has been running now for 12 days and commit charge has steadily increasing to no 5.5GB. The memory consumption from all users processes is far less than 1GB. How do I find out which proces...more >>

OK have drives set up on the hardware raid from dell perc card and cluster does not see them what could i have done wrong.....should they be dynamic or basic? Also i am having problems installing SQL on the same box and the sql.log says something about disk resources....more >>

Hi , Is ther any way to know which node am connecting to or which node the cluster is running on . Can we find out the same from Query Analyzer . Thanks ARR ...more >>

I have a SQL 7.0 Clustered Server with SP3. Sometimes a DB (16GB) becomes suspect and the only way to get it back online is to reboot the server and that gets it back to normal. This happens every week. Any ideas? Also can you tell me how to change the location where Microsoft Clustered ...more >>

Any 'words of wisdom' or pointers on how to get a custom extended stored procedure to work in a SQL 2000 clustered environment? Here's my error message: ODBC: Msg 0, Level 16, State 1 Cannot load the DLL D:\Program Files\Microsoft SQL Server\MSSQL\Binn\, or one of the DLLs it references. ...more >>

I have a clustered server with a clustered instance of SQL Server 2000 running on it. I'm attempting to restore several databases to the clustered server from our production, non-clustered database server. I also want to do a move of log files at the same time. On the production server, the...more >>

Hi, I have a clustered sql server with two instances. It looks like the disk on one instance is not large enough for the db, whilst the disk assigned to the other instance has plenty of room. I'd like to swap disks between instances. How can i move an instance between disks? Any ideas? ...more >>

Hi, i need to install sql 2000 cluster on win 2003. i have all the maluals but something is not clear for me . do i need to install MSDTC before !!! the sql set up via comclust.exe on each node (like i wrote the OS is win2k3) thank`s, Ronald. ...more >>

Hi , I have cluster with 2 nodes (sql 2000 on win 2003 ) and i want to install active/passive configuration . for that configuration for my understanding i need named instanced let say SQLPROD and my vitual server name is SQLPROD so the name instance will be SQLPROD\SQLPROD this is all very c...more >>

Is anyone running SQL 2000 using the Veritas cluster service vs. MSCS? For a simple two node SQL 2000 cluster (A/P), does Veritas add much value? Derek ...more >>

I have a Windows 2003 server running SQL 2000 with Tomcat 5.0. I need to have some kind of failover solution for SQL and a NLB for Tomcat. I came accross an article that states that NLB is not intended for SQL. My final goal is to have two clusterd servers, both running SQL and Tomcat. Doe...more >>

Platform: Window2003 ent Failover Clustering SQL Server 2k ent sp3a. I need change some registry keys regarding to SQL, such as: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer Do I need change on all the nodes one by one? Previously, after non-clustered default installation, I always refe...more >>

We have a 2 node active/passive SQL2000 cluster running on a Windows 2000 advance server cluster. The cluster cannot failover. The SQLagent crashes on a failover attepempt. The following event is generated in the application log of the node we are trying to failover to. Event Type: Error E...more >>

I have the two node cluster with SAN (msa 1000 with HP ml 580) that I want to install SQL server as virtual server in. The error meage in a log is : 18:10:26 Begin Setup 18:10:26 8.00.194 18:10:26 Mode = Normal 18:10:26 ModeType = NORMAL 18:10:26 GetDefinitionEx returned: 0, Extended: 0x0 ...more >>

Dear all, I tried to post this question yesterday but seems like didnt get thru, so I will again. If duplicate, please ignore this. Currently there I have a live production SQL server cluster (SQL2000) in non-Case sensitive mode. The server is rather powerful with 8 CPU. Now only running ...more >>

We have an active-active cluster on two 64-bit servers, with an instance of SQL Server running on each node. We installed the 64-bit oracle client and it works just fine using Oracle's "SQL Plus" app. But when we add it as a linked server in SQL Server, it hangs when we try to access it, whe...more >>

I have a SQL 2000 cluster running on W2K3 cluster. The firewall is showing that sql is receiving incoming traffic on the cluster IP, but responding with the IP of the primary node and not the sql cluster IP. Does anyone know why this is happening? Kevin ...more >>

Hi! I have Win Ent Server 2003 + MS SQL 2000 sp3 cluster. Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: ) My full text search does not populate catalogs on the na...more >>

I have the MSDTC group with resources in a SQL Server cluster. The MSDTC group and resources are all online from Cluster Administrator. If check SQL Server Support Service it show the service as stopped. The Server services shows the MSDTC to off. Please help me with these results. ...more >>

I need to setup a 2 node cluster for testing. I have 2 identical servers running Win2k3, but I have a question about the shared disk device. For the shared disk can I use a NAS device, one that connects thru a cat5, or do I need a device that uses scsi? Remember this is for a short term test....more >>

Hi, How many SQL 7.0 instances can you install on windows 2000 cluster? windows 2000 cluster supports a maximum of 4 nodes. Regards, AD...more >>