Is setting a static port for SQL server possible on a cluster? I tried this and the service would not start, so I had to run the cluster recovery utility to get the service to start again. ...more >>

Maybe Friday isn't the best time to ask, but here goes... To improve our single instance sql2000 to High Availability standards, I'm looking into clustering, log shipping, etc. We are totally sql2k now, so we would tend to stay there. Are there any HA features in Sql2005 that are not in...more >>

Hi all, i have a 2-node cluster with SQL 2000. I've received many complaints about the performance. My users tell me that the server is very slow. The boxes are new (2 cPu Intel Xeon 2'8 GHZ and 4 Gb RAM, ...) I have used PerfMon to see tipical counters and have seen about 100 page error/sec i...more >>

Is there a manual procedure whereby I could get a replacement node up to SP1 binaries without having to interrupt service by failing the cluster over just to apply SP1 to the newly rebuilt node? Hopefully I'm making sense - the node that went down was a passive node and it's been rebuilt - ...more >>

Trying to install oe instance of SQL Server 2000 Enterprise (32-bit) on a Windows Server 2003 R2 Enterprise two node cluster. I am installing on the node which the cluster group is currently on. Cluster group only contains disk drives. I have an IP set aside for SQL. Go through the insta...more >>

Hi I've a challenge of upgrading the curent cluster hardware. my current config: node1 and node2 with a vs1\sql1 and vs2\sql2 respectively attached to SAN It's important to keep the same IP address and preferred the instance name because of my ERP database that is on node1 vs1\sql1 option 1: ...more >>

I currently have an active/passive cluster acting as our OLTP TX database server that is replicating to another active/passive cluster acting as a Reporting database server. I have heard that if the database is read-only (e.g. reporting server) that it is possible to set the sql server appl...more >>

Hi My configuration is Windows 2000 Adv. server SP4 and two istances of SQL 2000 sP3. I just updated the OS from sp3 to SP4 last night and now when i open Ent. Mgr from any desktop or console pc and when opening the Database folder on node2 comes up with no items " i don't see any databases"...more >>

Hi All, I really need some guidance on how to restore this. Your help will be very much appreciated. Setup: 2 node clustering on Windows 2000 Advance Server with MS SQL 2000 Enterprise Edition. Diaster: Both the hard disks in the RAID 1 configuration failed on 1 of the nodes and the wh...more >>

We have a 3rd party vendor application that runs on IIS and connects to a back end SQL Cluster. Sometimes a user will try and run a commission report and the SQL server takes a big hit on the CPU's (Dual 2.0 Ghz Xeon's) and I will get a error in MOM 2005 that the "Server Performance Threshol...more >>

I haven't used Microsoft (or Veritas) clustering software before, and I would like to understand better whether certain disk configurations are allowed, or recommended. When working with a stand-alone server that is not going to be clustered, and the storage is mission critical, my normal inst...more >>

I will have to move a 2-node SQL2005 MSCS cluster to new servers. Wonder if I could just - remove node1 from cluster - add node3 to cluster - remove node2 from cluster - add node4 to cluster Is this a valid plan? Ole Thomsen ...more >>

What are the reasons that you are not allowed to install the SQL Server program files on a shared disk that's accessible from all cluster nodes? We have a custom notification application that's written as a windows service. We want to add it to the same resource group as the SQL Server ins...more >>

Dear All I am facing problem of recurring corruptions with sql 2000 server sp3a windows 2000 advanced server failover cluster. is it wise to apply sp4? or is it risky at this stage rgds Biju ...more >>

Hello all... What is the proper procedure to applying the SQL 2000 SP4 AWE Hotfix on a cluster? Also, has anyone had any issues with this hotfix on a cluster? Thanks... Michael...more >>

We are running Windows 2003 Cluster with SQL Enterprise 2000. We have 10 Cluster Groups setup on the server, each having two drives and a sql instance. In cluster admin, I can see the two physical drives in each group, but from SQL enterpise manager, on a given sql instance, I can only see one ...more >>

A few days a fail over occurred due to a network outage. After this the event log filled with Error 823 messages. After reading books on line I got worried since it talks about disk problems. I kind of figured out what is going on but have not found a solution yet. Just before the outage a ...more >>

I have a two node cluster, and both nodes are up (this is a testing environment) - both Virtual SQL servers are up as well. The cluster resources are in their own group (ie, cluster IP, cluster name, Q drive, etc). The question is... How do you restore this Cluster Resource Group if it...more >>

hello, I'm about to install a 2-nodes Windows 2003 Cluster, with 2 SQL Server 2005 instances: I've read in MS documentation that clustering MS-DTC is recommended, but I can't find how much disk space shoud I reserve for it group: can you tell me what is the recommended disk space for it ? ...more >>

Hi I am settingup 2 servers with Network load balancing and wanted to know how can I make the SQL databases to Synchronize between my 2 servers is it even possible and if yes how? Thanks -- Tony Zarafshar...more >>

Can anyone help? SQL 2005 has been installed on Server A, when trying to add a second node, using these instructions http://msdn2.microsoft.com/en-us/library/ms191545.aspx no error messages are given, but the node is not added. The summary.txt is as follows Microsoft SQL Server 20...more >>

To solve corruption issues i will be rebuilding my database sql 2000 enterprise edition sp3a on windows 2000 advanced sevrer clusterusing DBCC CHECKDB (<database name>, REPAIR_REBUILD) . database size is 7 gb does it require any additional space in harddisk? Is it a safe procedure or do i ne...more >>

Hi all, I have a 2-Node Active/Active SQL2000/SQL2005 Cluster sitting behind an ISA box. The SQL2000 which is a non-named intance i.e. default uses port 1433. I checked this through the SQL 2000 Server Network Utility. I then checked the SQL2005 named instance using the SQL Server Configur...more >>

Hello, I have a question about settings on a clustered instance of SQL Server 2005 Standard on Windows 2003 Enterprise. In "Cluster Administrator", it is clear that our groups are not set up for best practices. Currently, we have the following "Groups" defined: 1.) "virtual server name" ...more >>

We have recently done an SQL Server 2005 Cluster install. On the secondary node we also installed the client tools as well as integration services using these intructions: http://msdn2.microsoft.com/en-us/library/ms345193.aspx We could not find instructions for installing Reporting Service...more >>

Hi, We have Windows Services serving Client Applications. The data is stored in MS-SQL Server 2000. For high availability of our Windows Services to client apps, We are looking for a Shared-nothing cluster (node 1/node 2)configuration. From Microsoft articles we know that we could inst...more >>

we have installed SQL 2005 on a two node Windows Server 2003 cluster. the cluster is configured with two instances, each using it's own resource group (virtual name , IP address, physical disk). the first instance is installed as the default instance VirtualSQLA now we want to install the s...more >>

Trying to monitor NT event viewer for cluster failover events... Can anyone suggest event IDs to watch for that SQL 2000 failes over one to the other.... TIA ...more >>

I am having difficulties getting this install to take. I have a fully functional Win2k3 SP1 Enterprise Ed. 2 Node Cluster w/the cluster group, the msdtc group, and the sql group already built. The SQL group only contains the SAN disk resource at this time. This cluster is running all the l...more >>

We have a standalone SQL server and want to setup clustered SQL server. Is it necessary to re-install the SQL server or just run the SQL server setup with 'create a SQL server failover cluster'? Do we need to re-attach/restore the DB after the clustered SQL server setup? Thanks in advance...more >>

I have had some new SAN LUNS made available to add to my SQL 2000 failover Cluster (two nodes) running on Windows 2000 Advanced Server. They were put in some time ago and have been showing in the Windows Disk Management list. They were in a virgin state with no signature and unformatted. Today...more >>

Does SQL Server require the /3GB boot.ini switch on a /PAE on a 16gb Win 2003 Server? What will happen if you don't? I know you do not use the /3GB when memory is over 16gb (With PAE...). Thanks... ...more >>

We have a SQL Server 2005 Standard environment with 4 instances of SQL 2005 running on it. Everyone connects to these instances with the machine name\instance i.e. server1\instancea, server1\instanceb etc. We are now attempting to cluster this machine in order to do active/passive failover...more >>

Hi, re: SQL Server 2005 Standard on Windows 2003 My question: The SQL Server service failed on our primary node last night. However, the node did *not* failover to the secondary node. Is it supposed to? If so, is there something missing in our configuration settings that prevented t...more >>

In a sql cluster environment I inherited: Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1) Microsoft SQL Server 2000 - 8.00.760 (Intel X86) I forced a failover to find out that full-text search isn't working. The queries fail with Full-Text Search is not installed, or a ...more >>

I have an SQL Enterprise 2005 Cluster that should have been setup as 2005 Standard Cluster. Mainly for licensing and $$ reasons I need to convert this. It is running on Win2K3 with just some small production databases on it (not heavy use). I am not using any special features for 2005 Enterp...more >>

Since the beginning of the week, we get strange errors in our event log: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]TCP Provider: An existing connection was forcibly closed...more >>

I have a question about what happens in the event that the cluster completely breaks (whatever this may mean) - is it possible to get SQL Server up and running on just one box? I realize that this is an overly simplified question, and that many factors could be involved. But, I am wondering if h...more >>

Hello, I am trying to get people's opinions, experience, etc with SQL Server 2005 clustering ? We are making some critical business decisions this morning about whether or not to move ahead with our plan to use clustering... We've been having some major issues with our 2 node active/passi...more >>

Hi, My partner Loren had raised a question yesterday about some services only being installed on the active side of an SQL2005 cluster at setup. We are using clusters for development/acceptance and production. What is the effect of say SSIS only being installed on one node of an SQL2005 cl...more >>