When I install a SQL instance on all nodes at one the ImagePath Reg key at localmachine/...../services/mssql$instance looks...

Hans de Bruin

04-14-2005 12:29 PM
Hans de Bruin

Hello Franco, THX a lot for information. Did you had any problems in installation or dayly bussiness? Regards Franz

Franz Steppe

04-14-2005 12:03 PM
Gary Hope

I strongly prefer to have a console and management server for a big cluster. That server hosts management and monitoring tools, backup file shares,...

Rodney R. Fournier [MVP]

04-14-2005 11:52 AM
Gary Hope

Hi all, I'm new to clustering. Is there any website on how i could learn to configure clustering. I have 2 new servers(Svr1 & Svr2) and san...

Mohd via SQLMonster.com

04-13-2005 10:35 AM
Rodney R. Fournier [MVP]

This is a quick one: does the domain account that is installing SQL Server on a cluster need to also be a domain administrator? If it weren't, would...

A. Robinson

04-12-2005 10:48 AM
R P

We've been struggling with a problem for a while now. If anyone has has a similiar issue, I'd appreciate it if you could share it here as it may...

Joel

04-12-2005 10:39 AM
R P

Hello All, I need to move a SQL Server Cluster from one subnet to another subnet so I need to update 5 cluster IP addresses (node a, node b,...

Benjamin Nevarez

04-12-2005 10:12 AM
Geoff N. Hiten

You get a limited-scale version in Standard Edition http://www.microsoft.com/sql/2005/productinfo/sql2005features.asp Geoff N. Hiten Microsoft SQL...

Jorge Martinez

04-11-2005 02:23 PM
Geoff N. Hiten

I have recently implimented a Windows active/passive cluster with SQL 2000. I have also setup a Share Point Farm with its databases on the cluster. ...

ehr_m@msn.com

04-09-2005 12:36 AM
ehr_m@msn.com

Hi all, Does anybody know if the XPSMTP extended procedure (or any mail sending functionality for that matter) works (safely) in a...

Ville Tuomola

04-07-2005 10:15 AM
Mike Metcalf

First, put the cluster back the way it was originally. The following steps MUST be done from the node controlling the SQL server resources. Using...

Geoff N. Hiten

04-07-2005 09:16 AM
Geoff N. Hiten

I need to move the transaction logs for all the sql db's (including master, model and user db's etc) to a seperate drive. Does anyone have any...

Scan le Gentil

04-07-2005 06:29 AM
Scan le Gentil

after unplugging the public network of both nodes, waiting alittle bit and replugging them, there was a major problem in the cluster administrator -...

liorhal@gmail.com

04-06-2005 02:26 PM
Rodney R. Fournier [MVP]

We have a 2 node active/passive SQL2K cluster running on Windows 2003 server. I would like to upgrade the cluster to SP3a for SQL2K, but my...

FullGUI

04-05-2005 09:51 AM
Peter Sun

I have a F drive which located at a SCSI Disk Array, it's the default instance SQL's data drive, now I just switch the cluster from the SCSI array to...

Peter Sun

04-05-2005 09:47 AM
Peter Sun

Hi all I have a SQL Server cluster running active/passive. Over the weekend due to a network problem, both machines lost connectivity on the public...

Krissi

04-05-2005 07:23 AM
Rodney R. Fournier [MVP]

Hello All, I have a SQL Server 2000/Windows 2003 2-node Cluster single-instance (active-passive) and it is working perfectly. I also implemented log...

Benjamin Nevarez

04-05-2005 04:20 AM
Krissi

I am migrating from NT4.0 SQL 7.0 Legato cluster to a baby step of Win2k cluster with 7.0. I have the cluster up and running and able to failover...

Thom

04-04-2005 03:11 PM
Thom

You will also need a heartbeat IP for each node. This IP can be whatever you want. For example: 192.168.1.1 - Node 1 Heartbeat 192.168.1.2 - Node...

Peter

04-02-2005 06:44 PM
Peter

I have an active-active cluster env. The servers were migrated to new servers, but the storage is the same. The serves were installed and...

Shima

04-01-2005 03:16 AM
Luca Bianchi

Hello! Month ago we installed the did cluster for Microsoft server. It is 3 machines under Windows Server 2003 Enterprise. 1 and 2 are cluster...

Serdge Petroff

03-31-2005 05:55 PM
Mike Epprecht \(SQL MVP\)

Okay go ahead and shred me now, and then please see if you can answer my question. I have a client that is living in the dark ages. Currently they...

Thom

03-31-2005 02:05 PM
Geoff N. Hiten

Hi, In out production clustering server, installed SQL Server 2000 and sp3 applied. Around 2:00 a.m. this morning, during the database loading, the...

Chen

03-31-2005 10:20 AM
Geoff N. Hiten

Hi all I have Sql Server 2k configured in active/passive Cluster on Win2k3. Now because the passive is just ideal and sitting there doing nothing, i...

Nik

03-29-2005 06:05 PM
Nik

I have a 2 node cluster running Win2000 enterprise and MS clustering. Also SQL server. Would there be a problem using the same domain password for...

Dave

03-29-2005 05:40 PM
Nik

Hi, I already have one virtual SQL server in the cluster, it's owned by only one node. Now I added another node into the cluster, and we don't want...

Koarla SUN

03-29-2005 04:39 PM
Peter Sun

All, I am in the process of upgrading windows 2003 ent with SQL2000 ENT stand alone server to a clustered environment. The servers that I am using...

Bryan

03-29-2005 10:16 AM
Geoff N. Hiten

Hi There, Trying via NNTP as I have posted 3 messages via the web interface and they vanish ? I am trying to cluster SQL2K on W2K. Have done this...

Tim Bicknelle

03-29-2005 08:06 AM
deadwood

My question is : What would happen to the jobs which are running,while failover occurs? I have a Active \ Passive SQL Server 2000 EE SP3a with...

Siva Prasad [SIVA]

03-28-2005 01:45 AM
S Siva Prasad [SIVA]

what's the meaning of taking the sql-server resource offline ? what is happning behind the scenes ? is it the virtual server offline ? is it the...

liorhal@gmail.com

03-27-2005 11:25 AM
Mike Epprecht \(SQL MVP\)

Hi, I have a Windows Server 2003 Cluster with two nodes. I needed restart the second node for maintenance, after that the Cluster Service on second...

Rubens Luque Sanches Junior

03-24-2005 08:09 PM
Rubens Luque Sanches Junior

We have SQL Server cluster setted and running, yesterday, we moved servers to another location, and assigned cluster servers to new IP address, now...

Yong Zou \(SearchIgnite\)

03-24-2005 03:08 PM
Yong Zou \(SearchIgnite\)

Hi, When I installed a SQL 2000 Cluster Active/Active I defined one default instance as SERVER01 and the other instance as SERVER02/I2. Is...

Rubens Sanches

03-24-2005 08:57 AM
Mike Epprecht (SQL MVP)

Hi, I finished the installation of the SQL 2000 Server with one default instance on a new cluster. After that my boss asked for a new name to...

Rubens Luque Sanches Jr.

03-24-2005 07:04 AM
Tom Moreau

Currently have a 2 node windows 2000 cluster, active/passive, with sql 2000 running a data vault that's controlled by node a. Would like to upgrade...

Scott

03-23-2005 07:25 AM
Scott

We would like to restrict the number of records returned in a LEFT JOIN query but we find that it doesn't work as it supposed to be. Query: select...

Daniel

03-23-2005 06:11 AM
Mike Epprecht (SQL MVP)

I'm looknig to set up a miniature clustering lab at home and looking for some advice. I would like to hopefully keep the price tag to around...

A. Robinson

03-22-2005 11:43 AM
Nik

I have recently had to rebuild my SQL Server 2000 sp3a 2 node active/passive cluster running on Windows 2000 AS SP4. We ran into issues about two...

Justin Hoffmann

03-22-2005 08:57 AM
Geoff N. Hiten

SQL Server 2000 running on W2K3 Advanced Server Cluster with 2 nodes. We have a domain level account which the MSSQLSERVER and...

bill

03-21-2005 04:26 PM
Geoff N. Hiten

I have a setup of SQL Server 2000 Active \ Passive Cluster on Windows 2003 Environment. Maintenance plans were created when the Node-1 was...

Siva Prasad [SIVA]

03-21-2005 05:43 AM
Siva Prasad [SIVA]

Hello, I have read through a lot of the info on how to perform this type of operation, but the more I read, the more confused I became. Here is what...

dasmoove

03-21-2005 03:46 AM
dasmoove

Hi, I a a two node win 2003 cluster running active / active with serveral SQL 2000 virtual servers between them. I have noticed the following and...

Jon

03-19-2005 01:34 PM
Hansde Bruin

Anyone here with hands on experience with SQL Clustering and using IPSEC? Perhaps we could exchange information... -Arnie Rowland

Arnie Rowland

03-18-2005 05:21 PM
Rodney R. Fournier [MVP]

We're in the process of designing a 2 node sql cluster for a client. I want to know the best way to backup/restore the cluster using Veritas Backup...

Shawn Winters

03-18-2005 12:02 PM
Rodney R. Fournier [MVP]

Can the Named Pipes protocol be removed from a SQL Cluster (SQL2000/Win2003)? And it still function properly, of course... -Arnie Rowland

Arnie Rowland

03-17-2005 07:07 PM
Dave Whitney [MS]

Hi, I've 3 PC. 2 x Win2K AS and 1 Win2K Pro. Is it possible to cluster the 2 Win2K AS as Primary & Secondary while the Win2K Pro serves as the...

Desmond

03-17-2005 07:03 PM
Dave Whitney [MS]

Hi all, I have a SQL Server cluster running which one database server machine is active and one database server machine is standby. But once I...

Carlos

03-17-2005 06:53 PM
Dave Whitney [MS]

I am new to MS clustering. What is the cause of certain shared resources showing on both NodeA and NodeB. Cluster administration showing resource is...

Ketan

03-17-2005 11:55 AM
Ketan

I would like to know the group's experiences on that topic. I had several issues in the past but antiviruses had changed a lot and maybe you...

Christian Castro

03-16-2005 10:51 AM
Rodney R. Fournier [MVP]

Hi, After a few frustrating hours yesterday of continually seeing this error message when trying to install an instance of SQL2000a on to Windows...

Gareth

03-15-2005 10:37 PM
Uhway