Hello all, I have been trying to install a single node cluster on Win2003 for about a week with pretty much the same results as I have seen all over the web. "Setup failed to perform required operations on the clustered nodes" I have a CD in front of me labeled "Part No. 810-01148" and the rea...more >>

Ok, I've got the cluster setup and running, but having never done this, I'm not sure if I'm setting up SQL right... We're trying to migrate our multitude of SQL Server running on older hardware to the new cluster, but I want to make sure we don't shoot ourselves in the foot. Here is what we've ...more >>

Hi, I have HP 5000 EVA SAN & Microsoft 2003 based cluster servers. I was trying to install SQL 2000 on my cluster as per the instructions given on your webcast (How to install SQL 200 on Windows 2003). I created named pipe alias & run the setup & at the end got message saying Virtual server ...more >>

hello, I'd like to configure an actif/actif/ sql cluster I've done a actif/passif which works well ! But my "actif/actif" cluster works like an actif/passif I dont understand clearely, how the pc client application (for exemple access 2000) it's possible to keep active a session odbc w...more >>

Hello I want to implement Sql Server Clustering. And I have a software that does only SQL Authentication to Sql Server Database. I read that only trusted connection is possible in Sql sever clustered database. Any help plz? ...more >>

In document "Installation order for SQL Server 2000 Enterprise Edition on Microsoft Cluster Server" (http://support.microsoft.com/kb/q243218/), as one of the pre-installation checklist tasks it states "You have disabled NetBIOS for all private network cards before you start the SQL Server Setup ...more >>

Hello, We are looking to implement (finally) some redundancy into our SQL Server setup. We are interested in failover clustering, but from what we've seen so far most people use a SAN to implement it. We'd prefer using independent servers, each with their own RAID array (similar to replication...more >>

I have to setup a SQL cluster using a direct attach SAN configuration in a different subnet to it's final "live" environment subnet. I have read documentation that warns against changing IP configuration once the cluster is setup. Can I go ahead and change the IP address after it has been co...more >>

hi everyone, Am presenlty Testing the I/o performance on the new CX-500 San From Emc And Hba From Emulex,The LUn Size is 1 TB and when doing the Testing with SQlIO Tool with a I/o block size-8 i get 39.3 MB/sec for Random write requestes but when doing the same with Random Read req...more >>

Hi, I am planning to move a SQL server to use another hard drive resource of the same cluster, Could we find some easy way without re-install? Thanks. Peter ...more >>

I am trying to setup a MSDTC on Windows 2003 Cluster. I have done the steps in Q301600 and KB 817064. However the MSDTC Resource will start on one of the cluster nodes but not on the other. (2 node cluster). I have checked that both nodes have access to the disk that is used for the MSDTC fi...more >>

I just want to make sure I understand this correctly... If you are running only one database (one instance?), and are clustered, then you must be running in an "active / passive" configuration. There is no way that both nodes can "share" the single database instance across both nodes for i...more >>

I have a sql 2000 cluster act/pas - i want to attach a dlt to backup the databases. Is there any docmentation for this? which server do i attach it to etc? Thanks Lap ...more >>

I have installed 16 gigs of ram in 2 servers that each house a virtual server\instance of SQL. I have the /3gb sw and the /pae switch in the boot.ini and before failing over the group i ran the following script: sp_configure ’show advanced options’, 1 RECONFIGURE GO sp_configure ’awe enab...more >>

We are looking at setting up the following cluster: 3 Active nodes: Each server needs to be completely distinct with its own unique database and its own virtual server and ip. These nodes do not share the same storage with the other active nodes. Active nodes must only process for their own ...more >>

Ever since installing W2K3 SP1 on our SQL 2000 cluster out performance has detiorated dramatically. We're seeing execution times 100 to 200% longer (slower) and huge increase in the amount of blocking and overall locks. We've tried updating statictics and are working with MS now but they d...more >>

Try to install Sql 2005 in 2 node cluster, however, it does not show up share drive, only comes up Q drive, anyone knows how to install it? or any ideas?...more >>

SQL 2000 Ent. on 2003 sp1 Cluster. -Installation & Service accounts are both domain admins -NetBIOS disabled on NICs -CLuster service & failover running properly -Cluster resource names contain no spaces -User PATH for TEMP and TMP set to c:\temp -AVScanner Services stopped -Licensing Mode ...more >>

Hi! I have two sql servers. One raid rack in the middle for them both. I installe two cluster groups, with two sql installation. Now I can put a db on one server and it can fail over to the other one and the other way around. Fine. But how can I set it up so the same db is located one ...more >>

Hi! I'm currently prepairing a SQL Server Cluster on Virtual Server 2005 according the documentation on http://www.sql-server-performance.com/installing_sql_clustering_virtual_server1.asp But when I've added the shared SCSI disk as described I can only start the first node in the cluster...more >>

I'm trying to build a new cluster with SQL Server 2K Enterprise on Windows 2003 server. When I run the install, I tell it to put the program files on the D: (local) drive and the data/log files on shared drives. However, after the installation is complete, almost all the files go in the C: drive...more >>

A change in networking if forcing all of our IPs to change. I have found KB articles 230356 and 244980 with the processes for changing the IP addresses of the network adapters and SQL virtual servers separately, but I would like to make sure I have the overall process order correct. Is there ...more >>

Dear Sir, I have a cluster Active/Passive cluster setting, Win2003. I would like to know the normal procedures for shuting down the SQL Server on both nodes. Is that needed to disable the passive node before using SQL Manager to shutdown SQL Server?Please kindly advise! Many thanks! From, ...more >>

I've searched everywhere on the internet and now this newsgroup for an answer to this problem and haven't managed to find a solution. I've built an Active/Passive cluster with two nodes, the cluster runs SQL Server and IIS. IIS Session state has been configured to run from SQL Server using ...more >>

Environment: SQL Server 2000 (with SP3a) and Windows Server 2003 If a SQL Agent job is running on the active node when a failover occurs, what happens to it? Will it restart on the formerly passive node (that then becomes active)? If yes, will it restart at the same Job step that it was exe...more >>

Hi, when attempting to apply SP4 to a SQL cluster, we are getting the following message. Buffer Overrun detected! A buffer overrun has been detected which has corrupted the programs internal state. The program cannot safely continue execution and must now be terminated. This happens just ...more >>

I have a two node cluster. Node 1 has the SQL instance running on it and Node 2 has the cluster group and msdtc running on it. I can ping the SQL virtual name and access SQL successfully. If I move the SQL group to Node 2, then I can no longer ping the virtual name or access the database. ...more >>

I read that its possible to implement an Active/Active/Active with SQL 2000 on Win Server 2003 Ent without SAN but could not find a good step by step howtos to it. Could some kind gentlemen point me to a good article ? please and thanks in advance. ...more >>

Hi, If I install SQL RS Enterprise on SQL Cluster , do I have to create IIS Cluster Resource for the "Reports" and "Report Server " web virtual directory ? Norman ...more >>

Hello all.. We have a Win2000 Advanced server running SQL 2000 Standard. In order to convert this to a clustered setup, is it possible to do an in-place upgrade of SQL? What should my steps be to make this a clustered config? Thanks, David Fusfeld ...more >>

I have a 2 node Windows 2000 Active/Passive Cluster running SQL Server 2000 Enterprise Edition. The cluster supports a 24x365, mission critical application. The nodes are currently members of a Windows NT4 domain which trusts a Windows 2003 Active Directory Domain. All user and service ac...more >>

Hi i have sql2k sp3 cluster installed on w2k3 server cluster. I can't find exact match KBs, only found 243218 for install sql2k cluster on w2k. followed the doc. but why the virtual server name not shown in AD as a server after install? is this normal? I remember in w2k cluster, the SQL VS wi...more >>

Hi can't find much on whether can SQL 2000 Enterpise server be installed in a windows 2003 cluster majority node set. Some forum say that SQL 2000 will not run on ms cluster mns need to verify these thank you ...more >>

Hello everybody, We are trying to consolidate our servers, by moving databases to instances (3 nodes) running under Active /Active /Passive mode. My doubts here are (1) Can we ever do this? I said "Yes", it may be possible but never tried. (2) If yes, how many virtual servers would we n...more >>

We have A-A cluster with two server but I would like to have another cluster. How could I connect both cluster? Thanks a lot,...more >>

With the same application concurrency and volume, we are experiencing more spikes in latency than before enabling the priority boost option. We are not experiencing any buffer latch time out errors. Processor utilization is below 45%. IO is not an issue for this system throughput is. There is ...more >>

Newbe question; how to connect to a remote cluster over VPN (Cisco) with Enterprise Manager (EM)? Client connectivity installed locally and failover cluster running remote with Cisco software VPN-client between. I successfully registered the server in EM, but when trying to connect, I g...more >>

I've 2 box servers with sql 2000 in cluster, I look for solutions this problem in KB but without sucessfully. I'd like to know what I can make to solve this problem, because I need to use this counters to make report capacity this box machine. Tks for some help. Fabricio...more >>

SQL 2000 - 8.00.878 - cluster environment. The application and database are in Internet. There is a linkedserver to access a db in Intranet. Sometimes shows up the message below: OLE/DB Provider 'SQLOLEDB' IRowset::GatherStats returned 0x80004005: OLE DB provider SQLOLEDB returned 0x8000400...more >>

I'm currently designing an active/passive clustered SQL environment which will involve not only the migration of existing apps/databases, but also new ones in the future. Hence, there'll also be an environment for testing new apps before they go onto the live cluster. What I'm trying to fin...more >>

HI, I would like to build a SQL 2000 failover clustering to improve my network knowledge. For testing and learning purpose, what's the minimal hareware requirment? -- Best Regards, Lynn...more >>

Does anyone have any thoughts on how to setup and configure a SQL cluster of three ACTIVE servers. I'm familiar with a 2 node, active/passive and active/active cluster but have not seen much published on a 3 or 4 node active(n) cluster. Thanks! - Mike...more >>

Good day, There is a 2-node microsoft sql 2000 cluster in active/active mode. . Default instance is on node A, another named instance is on node B. Client uses BDE while connecting. When the node A fails over to the node B, it's not possible to connect to the default instance while using trust...more >>

MS points us away from IPSEC with this article due to the failover implications. Other than SSL, what technologies are you implementing in it's place? Is OpenSSH viable on a cluster? Cheers....more >>

My site have two HP server are install SQL 2K Cluster Server (MSCS) on Windows 2003 Server are running smoothly but when I upgrade both Windows 2003 to SP1 the problem was appear, when I reboot Passive B cluster server it will take over the SAN disk(the database disk) but it doesn't failover t...more >>

Hi, I am trying to practice to build a failover clustering for SQL 2000. Does anyone know the minimal hardware request for a testing clutering? thank you for your help. -- Best Regards, Lynn...more >>