I am trying to setup an active/passive cluster (everything on 32bit plateforme) on a virtualized environment. I followed several docs provided by microsoft especially the one on /prodtechnol/virtualserver/deploy/cvs2005.mpx. Regarding the w2k3 itself it seems everything is correct, I did all ...more >>

Does anyone have a link for the essential local security policy settings that are needed by the domain account that is used to start a clustered MS SQL Server 2000 instance? I have been to MS Technet and not found a really explicit list of privs as they relate to my problem. Of course thi...more >>

We plan to retire two existing 2-node Prod clusters running Windows 2000 Ad and Windows 2003 respectively and hosting 4 SQL Server 2000 instances each, with one new 2-node cluster with latest hardware running Windows 2003 SP2. We want to keep the same name and IPs for Virtual SQL servers and mig...more >>

I am presently trying to install a windows cluster on windows 2003 enterprise edition. After i configure the cluster service on the windows server. I will require to install a default instance of SQL 2000 although the version is old i will update it with sp4. My client then wants to have a ...more >>

Hello Just wondered what peoples opinions were on the advantages of using clustering over DB mirroring introduced in SQL 2005? From what I can see having briefly looked into things is that the mirroring offers potentially a less complex and cheaper solution not to mention the fact that you ...more >>

I turned off the passive part of the cluster. When I try to connect via DSN, to an instance of SQL ServerI receive the error "SQL Server does not exist". Is this due to the fact that the passive cluster is shutdown?...more >>

I have a 2-node active/active cluster (SQL2KSP4 on Win2003sp1) supporting 3 instances (2 on one node, 1 on the other). I've received funding to upgrade the instances by adding new host nodes with better/faster hardware (Yay!). The end-result should be the 3 instances running active on the t...more >>

Hello, I can seem to find any official Microsoft info on upgrading a SQl 2005 cluster to server 2003 sp2. The release notes dont mention an upgrade in a cluster. I've done a few SP upgrades in a cluster before and the steps I would take are: -install SP on passive node, reboot -move r...more >>

I have three SQL2000 Instances running on a two node cluster. Instance A runs fine on Node 1 and Instances B and C run on Node2. All of these listen successfully on TCP, Shared Memory and Named Pipes. However, if Instances B or C are moved to Node 1 they fail to start and Event Log has SQLS...more >>

I was reading the Microsoft white paper (http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx) on clustering and noticed something I didn't expect. It seems to say that only one node of a cluster may be used at a time and that it is not for (any kind of) load balancing...more >>

Hi, I having a problem starting sql server in a cluster. The error has the description; 17113: initconfig: Error 2(the system cannot find the file specified.) opening 'master.mdf' for configuration information...more >>

I want to know how to install the JDBC XA driver in a cluster and make i cluster aware. Thanks, Padron...more >>

I have a windows 2000 advanced server with SQL Server 2000. Should the disks drives that store databases in them be in the dependencies property within the SQL IP Address? Thanks, Joe K....more >>

Is there a way to readd the startup options for a server after removing them? The server will not connect without them and without being able to connect the properties sheet does not come up. ...more >>

I'm running a SQL Server 2000 SP4 2-node active/acitve cluster on Windows 2003 Server Enterprise Edition SP1. I changed the subnet mask of my public network config, as well as the MCS virtual subnet and two database resource subnets (all are using the same subnet). DNS is correctly resolving to ...more >>

I've a problem trying to execute a SSIS package inside a SQL Job that uses a credential/proxy account. The sql job hist error msg is: Message Unable to start execution of step 1 (reason: Error authenticating proxy DOMAIN\USER, system error: Logon failure: unknown user name or bad passwo...more >>

I'm looking at MSFT press book for SQL 2005 and they say and active / active cluster needs two virtual server names. Can anyone confirm or deny if this is true for SQL 2000?...more >>

We have a two node cluster with two groups on them (W2K3). Each group has a sql 2k instance running and the groups each reside on a node, failing over to the other if necessary. My question is that we were looking to upgrade, but are only able to upgrade the one instance to 2K5. I assume th...more >>

I have a problem with a Windows 2000 two node active/active cluster. TCP/IP connectivity to one of the nodes fails with "Cannot generate SSPI context." The other node is fine. I know this is typically an SPN error, but I'm unsure what the SPN listings should look like in active directory ...more >>

I'd like to run a SQL 2000 instance and a SQL2005 instance on the same two node windows cluster. Each would have it's own disk groups. Basically mixed versions of instances on a cluster. Does anyone know where I can get Microsoft's official statement on this? Has anyone done this before?...more >>

Hi, We have a fail-over cluster with a SQL Server 2000 instance installed on it. There are 6GB memory available on the cluster, and we have the /PAE switch turned on. I want to enable AWE in SQL Server and allocate 3-4GB to SQL server. but from what I read about turn on AWE, some paper warn...more >>

What is the Cluster setting if the present node has 3 failures (default) to stay on the same server node? What is the Cluster setting if the present node has 3 failures (default) to move to another server node? Thanks, Joe K....more >>

I need a sql failover cluster box with 10 instances, how big the quorum drive size that I need --estimate Thanks ...more >>

hi, How many instances could have in an active/passive and an active/active cluster box ? Thanks, ...more >>

Hi, Is it a good ideas for sql server 2k to put 15-20 databases in one cluster box. Create like 10 instances. If something wrong we could just restrat the service for that instance..... othewr dbs won't be affected. Any ideas? drawbacks? Thanks ...more >>

We would like to do MSS 2005 cluster failover testing with out Application, however we do not have a SAN (or shared disk storage). Oracle provide the ablity to create a 10G cluster using 2 Virtual Machines, so we were wondering if Micrsoosft provides a a similiar solution for MSS 2005 and if s...more >>

Hi support, The cluster need around 10 mins to complete failover process. i would like to know it is normal case or whether healthy ? if not healthy, how to check and resolve it ? pls advise. The system configure: Windows 2003 + MSCS +SQL 2000 (virtual server) .. And also, where can i fo...more >>

Customer is running a SQL 2000 system single instance, this SQL 2000 is installed on a cluster of 2 nodes but they are not clustering the SQL instance, easier even they are running SQL 2000 on a cluster, SQL is not clustered. They want to upgrade to a real SQL 2005 cluster using the sam...more >>

Hi (I send one before but looklike it did not pass through) I have questions as below. 1) On production server win 2003 64 bits, I can not see Cluster by ClusterAdmin, Quarum is the folder in C:\Drive, SAN is only shared drive, SQL logon by local system account, Sql connect as (local) or Com...more >>

Hello group, I am building a SQL 2005 Standard failover cluster on Windows 2003 Enterprise. Everything looks alright; dual HBAs, dual NICs, MSDTC as part of the Cluster Group, all hotfixes applied. The server setup completes successfully, however, the remote workstation components fail. Sp...more >>

Hello group, I have been testing out SQL 2005 clusters. I noticed that putting the "Distributed Transaction Coordinator" resource (i.e., MSDTC) in either its own cluster resource group or in the default Cluster Group with the quorum works. The latter would be my preference because it saves an...more >>

I've setup a Windows 2003 Enterprise Edition cluster of 2 nodes, with sql2000 cluster and analysis services cluster. I must install sql 2005 and analysis services 2005 without upgrade 2000 instances. can you help me ? ...more >>

All, I've setup a Windows 2003 Enterprise Edition cluster of 3 nodes. Everything is attached to a san (CX500). Just installed SQL 2005 and all works fine. Is it possible to have this cluster with 2 active nodes and 1 passive node? i've setup a drive (r:\) and it's online but only avaiabl...more >>

I am preparing for the installation of SQL Server 2005 Standard on a two-node cluster. The SQL Server books Online" topic named "Before Installing Failover Clustering" indicates that you must install MSDTC if you are installing the Database Engine and SSIS, Notification Services or Workstat...more >>

Hi, I have a two node Windows 2003 Adv. Cluster setup. I have also installed a clustered instance of SQL2000 Ent as well as SQL 2005 Ent each on this cluster. Each of my nodes has 16GB RAM. My goal is to setup 7GB RAM for each of the SQL servers and leave 2 for OS and other Apps etc. I a...more >>

Hi GUYS, Currently i am having two seperate 2 node clusters of sql 2000 one for OLTP and other for Reporting each having seperate MSA.in the new environment I am planning to have two 2 node clusters of sql 2005 but both clusters will use same MSA . is it advisable or better to go for seperat...more >>

Hello, Last Friday we recycled all our production servers including a 2 node SQL 2000 Cluster. Eversince I'm unable to establish connection between one of the SQL Node and a webserver. The webserver is located outside the firewall. Appraently the webserver is able to establish connection to the...more >>

I created a single node SQL 2000 cluster for testing purposes on Windows 2003 SP1 box. In time, the application folks wanted to test failover and requested a failover node. I added the failover node to the cluster group and to the SQL cluster. I verified failover to the new node of the quoru...more >>

We have a 2 node A/P cluster running Server 2003 and SQL 2000 SP4. Our DBA and I moved all of the database and log files (including master) to new LUNs on the SAN. Everything is fine on the node we were using at the time, but when we try to move the SQL resource to the other node it will not...more >>

I have a two node cluster running W2K3 EE SP1 and MSSQL 2000 SP4. IBM 366 Quad duo core w/ hyperthreading and 16 GB RAM each. I am hosting 5 instances "Multi-instance" of MSSQL combining a total of 120 Databases - Eggs in one basket for sure. MSDTC separated from the instance resources and f...more >>

I was trying to install SQL 2005 64 bit on a cluster . the install half way and when I uninstalled SQL I still have the services in Computer Managment. Is there any way to get read of them to be able to do another install? Help ...more >>

Hi, We're having a SAN outage & I've noticed some **flakiness with regard to a 'clean' shutdown of our SQL 2000(active/active) & 2005(active/passive) clusters. **In the past when we've disconnected storage and had to cold boot all the cluster nodes, we've had trouble starting the cluster...more >>

I am going to install SQL 2000 SP-4 on Active/Active & Active/Passive. we cannot have down time as it is 24/7. i need help to install SP-4 with some good steps & what are the things to be consider before & after installing SP-4. Any help is appreciated & thanking in advance. ...more >>

Hello , I have couple of questions on clustering as well as on hardware. 1) Is the license for SQL Server 2005 Enterprise edition ( Production) on active/active and active/passive is same? 2) Is the license for sql server 2005 is socket based or processor based, is there any differnce b...more >>

I just setup my first 2 node Active/Active SQL Cluster and from what I can tell you can have only one (1) default instance in an Active/Active cluster. The other instance has to be a named instance. Is this correct, or am I crazy? If so, I don't undertand why this limitation. Since the 2 SQL ...more >>

I am installing SQL 2005 64 bit on a cluster Active/passive . I am getting an error when I am giving SQL install path of D drive which is a local Drive .. I am getting this error any idea? Could not access network location D: (x86)\. ...more >>

We are upgrading our current clusters to new hardware HP DL 380 G5 with 2 clusters each with 2 nodes. but for both sql clusters we need to use same MSA 1000 with 2 controllers (having 4 arrays Array1,2,3,4(with 2 arrays(1,2) for Cluster1 and remaining two arrays arrays(3,4) for cluster 2 . i...more >>

Hi, I am a newbie to Clustering. I dont know how to decide how many number of nodes I need to install. For example, if I have 4 SQL database servers and all 4 servers should be highly availabe and automatically failover. In this case how can I configure clustering? ...more >>

Hi Apologies if this isn't the right forum. I have an instance of sql (2005) setup called SQL1\SQL1 I am trying to connect to a database (hm1) using the following connection string in my web.config: server=SQL1\SQL1;database=hm1;uid=hm1;pwd=hm1; ...but it can't find it. I need to k...more >>

Hello, What is the SQL Server 2000 supportability..? Can i get any KB which explains that. Is SQL Server 2000 with SP3 supported. I hope this is the right group....to post... Thanks...more >>