hi all , I tried several times to install sql clustering on two sql nodes but when it tries to configure the resources on virtual server after configuring sql server resource. then I tried to configure it with single node it succeeded. but when I want to add the 2nd node again it cannot configu...more >>

We recently set up an Active/passive SQL Server 2000 Windows 2003 Cluster for our customer. They ran their SQL client application which was doing bulk inserts and some reads (using an ADO stored procedure?). When we induced a failure (pulled network cable), the failover took about 90 se...more >>

Hi Folks: How do you script-o-matically set processor affinity on SQL after a cluster failure? The purpose is that I'll be failing to a machine with a different amount of CPU's (4 instead of 8). I want to control what SQL instances take what amounts of processor. Is this even possible? ...more >>

I have to determine the best (affordable) physical architecture for the following scenario. We will have an eCommerce solution that has 200+ SQLServer databases running on Windows 2000 server (normal server, not the Advanced or Datacentre editions) and I need to determine the best solution for...more >>

Hi This is sort of a repost of my previous posting, but I think the problem is better explained in this one. I have a windows 2003 cluster with two machines, SKADB01 and SKADB02. There are two clusternames that both contain these two machines: SKABIZCLU (For Microsoft BizTalk Server) and SK...more >>

Hi, Our customer wants to go from a standalone SQL server implementation to a clustered one. We recommended Active/Passive for them since they do not have a heavy load, they just wnat redundancy. When they tested their client application against the Active/Passive cluster server they ...more >>

Hi, Would it be safe to say that SQL server does not allow me to do load balancing of a single database? We have an application that uses a single database. Currently I have a setup of 2 decent servers (HP ML570). They are setup with Windows 2003 server failover clustering. I wanted to find...more >>

Hi I have to machines (SKADB01 and SKADB02) which are in a Windows 2003 Cluster. The cluster has two groups - one for Microsoft BizTalk Server 2002 and one for SQL Server 2000. The cluster is an actice/passive cluster, and the SQL Server Group runs on one of the machines and the BizTalk group...more >>

I have a SQL Server 2000 with SP3 in a Active / Active Cluster. I would like to write a SQL query to receive database table data from the other side of the Active cluster. Node A - Virtual Server Name: HGFOPKLD\ERT - Database Name: NewOrleans_Sales - Table - June_2004 Node B - Vir...more >>

I have Windows 2000 Advanced Server with SQL Server 2000 with SP3A in a Active\Active Cluster. When I loaded Windows 2000 SP4 on the server it changed SQL Server 2000 version to "Microsoft SQL Server 2000 - 8.00.194 (Intel X86)". If the Active (Node A)\ Active (Node B) cluster was m...more >>

Hi all: I have a clustering SQL Server on Node1 and Node2, the Node1 has named Instance1 and Node2 has named Instance2, no default instance. We tested it that everthing is OK, then we decide to move to DR location. The relocation kept the same virtual and phusical server name, and we did no...more >>

We have a cluster server with 2 nodes, both running Win2000 Advanced Server. However the second cluster had to be wiped and rebuilt from scratch. We have rebuilt the server now and everything fails over apart from SQL Server. I have installed it correctly using a Virtual Server etc. Howeve...more >>

Win2003, SQL2000 Sp03a We have had several cases of a DTS package failing where it appears that the dtsrun process dropped dead in its tracks. Anyone seen one of these ? We get one of the standard Microsoft error reports popups - the only part of this that I can make sense of includes t...more >>

Hi All: I am upgrading to SQL SP3a from SQL SP2 in a SQL2K dual node cluster environment W2K SP4 is the current OS. I have no test environment so I was hoping for a little advice before I attempted this. My understanding is that SP3a will stop the service on one node box initializing a fail...more >>

I have a system configured with Windows 2000 and SQL Server 2000 Clustering (active/passive). Both SQL Servers have a local E:\ drive with the same directory structure. I would like to move the tempdb off of the shared SAN and on to the E:\ drive. I don't foresee any issues with this but wanted...more >>

I would like to know the kind of test to be done after the fresh installation of SQL Server on cluster environment. This to ensure the fail over is happening successfully and confirm the SQL Server Installation on cluster environment. This includes both for Active / Active and Active / Pa...more >>

Hi I am looking for some good online resources for Clustering for SQL Server boxes. Any links or MVP sites tell about Clustering,Replications & LogShipping are highly appreciated. Thanks Chip...more >>

I have multilple web servers running classic asp and asp.net applications that all connect to a single MS SQL2000 database server with multiple databases via SQL db connection strings defined their global.asa or web.config files. If I need to restart the SQL server or take it offline for ...more >>

Hello ! I have installed an active/passive MSSQL 2000 Cluster on W2K3 EE and applied successfully SP3a to both nodes (Failover to second node still works at this time !) Before going to test phase, I would like to patch the SQL Server with Ms03-031 cummulative patch. Wenn applying the patc...more >>

Is this true that Active Directory is needed in order to cluster the SQL2000. I have 2 Dell 6000 series with a shared Dell RAID.... Any articles or links to see how can I set this up correctly?...more >>

Hi, We are looking for failover strategy when primary server failed using log shipping method. We are not using sql server clustering. What is the best way to redirect the web application to new server? We used change in DNS , but due to its caching at client is no longer a viable option. Any...more >>

Hi all, in our current environment we have 1 server running sql. After making a review of our disaster recovery strategy and readiness we have decided to bring in a 2nd server to function as a standby failover. Due to the price limitations with SQL2KEE we have decided to stick with Standard Edit...more >>

this is an error which i happen to encounter..can you guys help me out here.. cursor type should be :rdopenForwardonly lock type should be :rdConcurReadonly Rowsetsize should be : 1 how do i solve this error.i tried the isql/w script but its not working either..any chance you guys know.. ...more >>

I'm attempting to validate whether it makes any sense to have more than two nodes in a Win2003 / SQL 2000 cluster. If so, how would it be configured and how would failover work? I've checked most of the Microsoft online resources and can't find specific examples, etc. related to this. ...more >>

Someone attempted to change the partition layout of our SQL cluster, then we recieved an error: "Could not start the MSSQLSERVER service on local computer. The service did not return an error. This could be an internal Windows error or an internal service error. . . ." in event log, we ha...more >>

The Window Server team would like to invite you to an upcoming chat: Title: How to write a cluster resource DLL This chat focuses on how to write cluster resource DLLs for making applications cluster aware. The topics will include when to create a cluster resource DLL, how to use Cluster Res...more >>

Hi, SQL is cluster-aware, so you install it on shared drive (quorum), correct? Then do data files and program files live on that quorum, or on each node individually? Thanks...more >>

I want to store Database files and Log files for the QA environment on NAS. But I am getting the following error: Server: Msg 5184, Level 16, State 2, Line 1 Cannot use file '\\QASQL02\QASQL\test_data.mdf' for clustered server. Only formatted files on which the cluster resource of the server...more >>

Hi all, Does anyone know if it possible to have active/passive instances of SQL on a single virtual server? I'm thinking not but if anyone has any info it would be much appreciated. Cheers, Dave....more >>

When we create SQL Agent jobs on a clustered machine we always get the physical machine name as the source (originating server). We get the same result if we create the job in Enterprise manager and using sp_add_job. exec msdb..sp_add_job @job_name = N'Testjob' select * from msdb..sysjob...more >>

I am trying to install SQL 2K onto a Win 2003 Ent. Ed. machine to create an Active-Passive node. The installation gets as far as the Remote Information dialog for me to provide a valid administrator account. After putting in valid details the setup crashes with no error. The only clues I ha...more >>

I have a active/passive cluster with W2K Adv. and SQL 2000. I was having the issue with setting up SQL on the second node. I fixed issue by installing directly onto the second node. But their is no option with the sp3a to install onto the second node locally. The same issue that happened with tryin...more >>

Hi, We are going to configure a 2-node active/passive SQL server cluster using W2003 Server Enterprise. A requirement is that both nodes be a member of the same domain. We want to make one of these nodes the Primary Domain Controller. Obviously if you lose that node in the cluster...more >>

Hi, Is it possible to use windows NLB for Sql 2000 enterprise edition servers. We are using 300gb database in one server and the performance is very slow. Any how we can't get load balancing in SQL clustering, If it is possible with NLB please let me know how to configure it. We are plan...more >>

Hi there, Does any know a way of backing up to a share from an sql 2000 active/active cluster. I have no problems doing this for stand alone installtions of sql 2000, but just can't seem to get it to work from a cluster. any help appreciated Shaun...more >>

Can SQL server be mirrored between two drives in the same box, and can this be used as a backup strategy? Thanks Vince...more >>

Does anyone know if SQL 2005 will be able to reside in a cluster with SQL 2000?...more >>

How do I found if a SQL 7.0 installation is on a StandAlone or a Cluster? In other words is there any equivelant for SQL2K function SERVERPROPERTY (IsClustered) in SQL 7.0 -- TIA Satish Balusa Corillian Corp. ...more >>

Hi, In a 2-node SQL Server 2000 Active/Passive cluster running under Windows 2003 Enterprise, can both computers be member if a workgroup (i.e. "WORKGROUP") or do they "have" to be members of a domain? Thanks....more >>

I have a clustered SQL installed but never added the Replication feature along with the initial setup. Now I ned to configure replication and thought I could just go back to the origianl setup files, modify the installation, add the componenets I need....and I'd be done. No such luck! ...more >>

Node A and Node B (sql server 2000) are being replicated to each other serving data partitioning. What are the options to set up HA clustering and which one is the most economic one? Appreciate any help....more >>

Hi - Recently I added some additional memory to a sever thats part of an active passive cluster (for a total of 8GB). After which we started receiving an error message when trying to move the cluster over to the passive server: Source:ClusSvc Event ID: 1117 Description: Cluster r...more >>

has any one tested sql 2000 enterprise edition clustering with a cracked licensed. I am trying test one but all the times the installation fails with some funny errors like file not found ( in the sql virtual server log I mean) . has any body seen the similar situation. ...more >>

test...more >>

Hi, Our customer has is runnning SQL server standard and they have clients that access the database. We are moving them to SQL Server Enterprise in an Active/Passive configuration. My questions is what happens when the application connects to the database, it starts doing a series of...more >>

Is there a limit to the number of databases exposed through a virtual server? I'm looking at porting over 200 databases from 12 different servers into a clustered environment and want to minimize the number of SQL Server installs that need to be performed on the cluster. Thanks in advance....more >>

Hello: I have two server which I want to configure as an Active/Active cluster. In doing so, I am trying to determine all the necessary IP addresses required for this setup. I understand that each node will have two NICs (one PRIVATE and the other PUBLIC), and as such would require t...more >>

I am trying to install SQL 2000 on a Cluster Server Node 1. MS - Support informed me that I should install this as a Virtual Server. However, Virtual server is grayed out. This is a SQL 2000 Standard edition. I do have SLQ Developer Edition. Does the Version matter here? I understan...more >>

I have an active/passive cluster on Windows 2000 SP4 and SQL is SP3a that gets 17052 EventIDs in the form of: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][ODBC SQL Server Driver] Communication link failure every Sunday Morning at 6 a.m. and at 8 a.m...more >>

hi everyone I am installing SQL 2000 on a single node cluster but after sometime that the virtual server resource installation message shows up, an error occures and the installation rolls back. during the installation as I notice in cluster administrator, all the required resources are instal...more >>