Hi George and the rest I'm planning to add another instance. My previous instance name is "MSSQLSERVER" So in a cluster environment, i'm planning to...

Amirullail

02-02-2009 02:56 PM
Geoff N. Hiten

Sorry, I'm a newbie to clustering. We also have a SQL Server 2008 standard cluster on Windows 2008 64-bit, 2-node Node with Disk Majority...

Nicole G.

01-30-2009 06:58 PM
Russ Kaufmann

Cluster resource 'SQL IP Address 1 (SQLCluster)' in clustered service or application 'SQL Server (MSSQLSERVER)' failed. I receive this error when i...

Amirullail

01-30-2009 11:34 AM
Dooges

Does anyone know the proper way to install MSDTC on a windows 2008 cluster? In Windows 2003 and SQL 2005, I would just put the MSDTC resource in...

Steven

01-29-2009 06:15 PM
Geoff N. Hiten

Thanks Ole for sharing your experience. I am surprise to know there isn't much info logged on fail over...

light_wt

01-29-2009 11:26 AM
Nicole G.

so i setup the cluster and all is well but it will only see the drive that i originally gave the SQL cluster, how do i add other drives? i'd like my...

Justin Rich

01-28-2009 03:22 PM
Justin Rich

Will have to apply SP3 to an active/passive SQL Server 2005 cluster pretty soon and really need some advice. As far as I understand it, I have to...

JB

01-28-2009 01:45 AM
Uri Dimant

I'm having a problem attaching a database on a server using Veritas Cluster Server. The process works when I do it on a standalone server, but when...

Jim Mimlitsch

01-25-2009 01:51 AM
Uri Dimant

Thanks for your reply, turns out the install's on hold...gives me time to read up. ST

Stuscotland

01-23-2009 10:23 AM
Stuscotland

We have SQL 2005 cluster on two nodes with Windows 2003 server. I want to replace disk "x" with new one disk "y". Disk "x" shared and is used...

Lehrovsk

01-22-2009 11:43 PM
Russ Kaufmann

Now everyone can develop their own website. Its easy even for newbies. I have worked out and found only a few vendors providing this service. Visit...

Computer Guru

01-22-2009 03:56 PM
Computer Guru

We built a SQL Server 2008 two node failover cluster (Operating System: Windows Server 2008). The SQL Server Resource is working but the SQL Server...

werner

01-22-2009 10:17 AM
werner

Hi Everyone, I'm having a heck of a time trying to get KB954606 to install on our two SQL 2005 clusters. First it wouldn't install via WU so I...

Brian Day

01-20-2009 01:30 PM
James Fecteau

"On the Cluster Network Selection page, specify the network resources for your failover cluster instance: * SQL Server Failover Cluster Network Name...

Amirullail

01-19-2009 11:32 PM
Karen O.

Sucess, I guess I should have tested this before posing my last question. I have sucessfully build my sql cluster and tested failover from one server...

Bartek

01-19-2009 03:22 PM
Geoff N. Hiten

Hi Ole TQ for the thought..i'm thinking the same way to. I mean, i just can get the report generated during the prerequisite check to determine the...

Amirullail

01-19-2009 03:30 AM
Amirullail

Hi we are having SQL 2000 in Cluster (Active / Passive) mode. and now we like to have SQL 2005 instant also in the same cluster. i do understand, we...

Gopi

01-15-2009 08:49 AM
Gopi

Hi all, I'm still reading around this and hoping to test in the lab, but I thought I'd get a quick pointer in the right direction first by someone...

Elissa

01-14-2009 10:02 PM
Elissa

What steps are needed to implement active active clustering, we currently have active passive? From...

user

01-14-2009 11:30 AM
Edwin vMierlo [MVP]

I have a 2 Node SQL 2000 Cluster using Dell Servers and a SAN. I would like to add two HP Servers to the Cluster and then eventually fail over to...

Marc

01-14-2009 11:09 AM
Geoff N. Hiten

hello, I already wrote last week about db mirroring. I've setup a mirroring lab with principal-mirror-witness SQL 2005 std. Everything seems to be...

Luca

01-13-2009 09:18 AM
Geoff N. Hiten

Hi, Should we have two identical machines(i.e. same model, memory size...etc.) for SQL Server clustering? Thanks.

Praetorian Guard

01-13-2009 09:16 AM
Geoff N. Hiten

Dear all, I'm a "newbie" on SQL2005 mirroring and I need some help. I'm going to set up a db mirroring with high availability, I mean...

Luca

01-13-2009 09:15 AM
Geoff N. Hiten

I have 2005 mirroring working fine with a 3rd witness server. but I don't see how to alert from Mirroring Monitor running on the witness. A technet...

bilmar

01-09-2009 03:53 PM
bilmar

I'm trying to run SQL Server 2005 Best Practices Analyzer against a SQL Server 2005 clustered instance. The processing finishes, but the results are...

Carlos Felipe França da Fonseca

01-07-2009 11:54 PM
Carlos Felipe França da Fonseca

So, it is possible that we can install SQL Server 2005 on active/passive cluster where already SQL server 2000 lies? Please give me some brief idea...

Sneha Shah

01-07-2009 10:47 PM
Geoff N. Hiten

Can someone tell me if when using an Default instance or(MSSQLSERVER) with SPN's does it still use Kerberos .I ask this question because if you...

William

01-07-2009 02:32 PM
William

Hi All.. I've done "create cluster" and "add cluster" for 2 node in sql 2008 Now what is the best advise or link that i can refer in order to do...

Amirullail

01-05-2009 10:22 AM
Geoff N. Hiten

Should the SQL Server Service resource be set to "affect the group"? The SQL resource group has a failover threshold and period, and the SQL Server...

JB

01-05-2009 10:10 AM
Geoff N. Hiten

Hi Can somebody show me (step by step) on how to create account to assign to every service in sql 2008 clustering... I find many notes but there...

Amirullail

01-05-2009 10:04 AM
Geoff N. Hiten

Hi All Can someone suggest me a book that i can refer to? I find this book : http://www.mhprofessional.com/product.php?isbn=0071498133 But the...

Amirullail

01-04-2009 10:56 PM
Amirullail

For a 2 node cluster, does the "preferred owner" have any meaning? Under what setting does the cluster automatically failback once the failed node is...

JB

12-29-2008 12:12 PM
Geoff N. Hiten

Hi Alllll I dont know what else IP need i to enter in order to fill up this part. Previously this is the IP setting that i used for my 2 node...

Amirullail

12-23-2008 10:39 PM
Amirullail

Hi Could you help me fix following problem please? I have new SQL Server 2008 fail over cluster and need to migrate system from stand alone SQL...

Piotr

12-23-2008 06:29 AM
Piotr

Could someone point me to any articles so that I can initiate an exiction and rebuild / rejoin of one of our nodes in a 2 node w2003 cluster running...

Mark B

12-23-2008 05:37 AM
Mark B

Hi everybody, SCENARIO An SQL2000 or SQL2005 2-node cluster (based on Windows2003 ENT) with an iSCSI Shared Storage ISSUE I need to replace the...

Pierluigi

12-19-2008 03:08 PM
John Toner [MVP]

The Cluster service account login was removed from SQL Server. I don't know when. Considering that the account was removed while SQL Server resource...

Carlos Felipe França da Fonseca

12-18-2008 10:25 AM
Carlos Felipe França da Fonseca

Hello we are having SQL 2000 Ent in cluster mode (active passive), now we are planning to upgrade to SQL 2005, any idea? Regards Gopi

Gopi

12-17-2008 05:10 PM
NathanB

I'm using GfI Network Server Monitor to monitor our network. No problem with our W2003 servers and clusters, but problem on a Windows 2008 x64...

pher

12-17-2008 06:35 AM
Edwin vMierlo [MVP]

Hello , I installed an SQL 2008 2-nodes cluster on windows server 2003 sp2 Successfully. Later, it turned out the 3rd party application does not...

Miled

12-16-2008 12:22 PM
Miled

Hello everybody, I have a one-node Windows 2008 cluster and I want to install SQL 2005 (cluster). the point is that I have to wait for a month to...

Javier

12-16-2008 11:56 AM
Geoff N. Hiten

Hi Ruben, Thanks for the reply, however I don't think you've read my question. As I mentioned I don't want to cluster it - can you be more...

Jon

12-12-2008 11:29 AM
Jon

Hi, I have created a cluster with Cluster IP Address "192.168.7.72" with following properties Cluster operation mode : Multicast Affinity: Single and...

Suseethra Rajasekaran

12-12-2008 09:02 AM
Russ Kaufmann

I added a node to my cluster and now I can't install Service Pack 4. I am running one node on Windows 2000 Advanced Server and the new node on...

LastChance

12-11-2008 02:07 PM
Marc

Is it possible to have 2 different versions of SQL running on the same physical box for a cluster? If so, am I correct in assuming that you need a...

DML

12-09-2008 09:09 PM
Geoff N. Hiten

Hi, We have a sql server 2005 cluster on Windows 2003 64 Bit Machine. From our whole network we can connect to the sql server fine. TCP/IP, Named...

Sazzad

12-06-2008 06:16 PM
Peter Gibbons

Is it possible to set up a active/active SQL Cluster?

Markus

12-04-2008 10:36 AM
Tom Moreau

Hello, I am desiging a SQl 2005 2 node cluster both nodes active with multiples instances of SQL. Has anyone had any problems with the QUOROM...

Sean John

12-03-2008 06:42 AM
Russ Kaufmann

Dear All, This knowledge center http://test-guru.blogspot.com/2008/10/test-2.html combines the results of consulting, research and writing work. ...

Computer Guru

11-30-2008 07:00 AM
Computer Guru

Hey Guys!!!! As you know that you are utilizing 5 % of total capacity of your CPU and facing a lot problems of space/storage. You can deploy...

Computer Guru

11-28-2008 02:19 PM
Computer Guru