Hi All, I'm pretty experienced in Windows Server and clustering, but little experience of SQL and just want to check a couple of details before I...

Wayne

01-15-2008 12:29 PM
Wayne

Hi, I am trying to install multiple SQL 2005 instances onto one machine, which has been configured as a single node cluster. Multiple virtual...

SQL Question

01-15-2008 10:35 AM
SQL Question

We're going to have to move data to a new 2000 SP4 server. We want to cluster it down the road, probably Q4 of 2008, but can't do it right now. ...

CLM

01-14-2008 03:52 PM
Geoff N. Hiten

Hi, Is there a detailed walkthrought on how to setup SQL2005 with ms clustering? The SAN storage already available to both nodes. Prefer a video. ...

sluo

01-10-2008 04:54 PM
Geoff N. Hiten

Dear All, We are installating an acive/passive sql server 2000 cluster. One of my friend recommended to configure the max server memory as total...

Balaji

01-10-2008 09:21 AM
Uri Dimant

I am new on both SQL and windows cluster. Our company is trying to deploy a HA SQL system, which I need to install SQL2005 to windows cluster....

jinshuang

01-07-2008 06:39 PM
Uttam Parui[MS]

I am installing a SQL 2005 active/active cluster. The system consistency checker is reporting that a "pending system restart" is needed, but I...

GaTech_Geek

01-07-2008 11:48 AM
Ayad Shammout

Recently, I was in a training course about the new features of 2005. The trainer said that 2005 dealt with active/active memory differently during a...

M Bourgon

01-07-2008 11:20 AM
M Bourgon

We have a sql2005 active/passive win2003 x64 cluster. when the db's are on the active node..we see all of the sql tools available. on the passive...

Steve

01-07-2008 10:00 AM
Geoff N. Hiten

I am Sql server administrator in a company and I don't have experience of sql server 2005 failedover cluster. Recently my company decides to use...

Iter

01-07-2008 08:24 AM
Geoff N. Hiten

Hi All: I have an active/passive SQL 2005 Cluster set up on a subnet that with a local Active Directory domain. Any computers in the domain...

geek-y-guy

01-07-2008 08:18 AM
Geoff N. Hiten

I have two nodes (active/passive) in my cluster that I am trying to upgrade from 64-bit SQL 2005 SP1 to SP2. I followed Microsoft's instructions...

Michael Kuzminski

01-04-2008 01:11 AM
RichardT

Hi, We have a default clusterd SQL server 2005 with sp2 installed in one cluster group and then I have installed a default SSAS clustered instance in...

dp

01-01-2008 12:38 AM
Jason Rupard

Hi All, Environment:windows2003 sp1 SQl server 2000, sp2, and It is clustered(2 nodes) I need to uninstall SQL server2000 . When i tried to...

Suchi

12-31-2007 10:30 AM
Geoff N. Hiten

HI All, As HIten said,(in my previous post) I am able to remove all the registry entries except hklm\software\microsoft\mssqlserver after couple of...

Suchi

12-30-2007 11:17 PM
Tom Moreau

Hi, We have 2 node sql failover cluster configuration ( Server 2003 +SP2, MSSQL2000 ) We can succesfully query the data from other MSSQL Server...

Dreamer

12-27-2007 12:57 PM
Exe_Vaz

We have a single instance cluster on 2 nodes say SQL1. We want to do a side-by-side upgrade of the underlying hardware and we have another...

Hassan

12-26-2007 05:26 PM
Tom Moreau

Hi we are having SQL 2000 for Sharepoint, wss and .net applications in Cluster (Active / passive mode) but we feel that it slow, is it anyway to do...

Gopi

12-24-2007 05:37 AM
Uri Dimant

I am trying to see if named pipes connection works on my cluster, sql server 2K. I have tryied the 2 utilities, makepipe and readpipe. The...

Franco

12-20-2007 12:12 PM
Linchi Shea

I have a 2 node cluster active/passive 2003 SP2 cluster. I have 4...

Carla

12-20-2007 12:04 PM
Linchi Shea

We are going to be setting up a new SS2k5 2 node/2active instance cluster and I have a question about Integration Services. We do use some...

Nancy Lytle

12-19-2007 04:28 PM
Geoff N. Hiten

= = = > Please forward profiles to michael.vigie (AT) pyramidconsultinginc (DOT) com Hi, Please let me know if you have any suitable references for...

Mike

12-19-2007 01:14 PM
Mike

From what I'm given to understand, a re-install of SQL Server is required to return to an un-clustered mode. We do not plan any other changes: o/s...

alfamale

12-19-2007 12:56 PM
alfamale

Hello everyone, I am running in a cluster setup (this is working ok). I cannot get the mssqlserver service to start. Here is the error log...

pithhelmet

12-19-2007 11:58 AM
pithhelmet

Hello, everyone. I installed a 2-node SQL 2005 Standard Edition with SP2 cluster (active/passive). I realized that the Management Studio was not...

Windows W2K3 User

12-19-2007 09:24 AM
Geoff N. Hiten

An installation of sql2k5 sp2 to one node of a three node active/active/active cluster has failed. It cannot proceed beyond the beginning of the...

Robert Hindla

12-18-2007 04:27 PM
Russ Kaufmann [MVP]

I have a two node active/passive windows 2003 SP2 cluster. I have three cluster groups created. One with MSDTC, the other with SQL Server 2000 (I...

Miguel Araujo

12-16-2007 10:59 AM
Miguel Araujo

I have a cluster sql server 2005 with 2 nodes. Now My users going to log to SSMS with the console installed in the theirs console and ask me to...

Gianni

12-13-2007 09:29 AM
Geoff N. Hiten

S it possible to set up SQL cluster like MNS, without having common share drives ? or without vendor specific solution. Target is to have...

Mr.B

12-13-2007 08:34 AM
Mr.B

Anyone? Thanks. "Dragon" <noSpam_Badill (AT) hotmail (DOT) com> wrote

Dragon

12-12-2007 03:56 PM
Dragon

We are currently at build 3042. I will install build 3050 and the 3175 and then try rebuilding the master database again. Perhaps it will work with...

Loren Z

12-12-2007 12:57 PM
Loren Z

On a stand alone server, our naming convention for multiple instances is: server (default instance) server\IN1 (first named...

Stu

12-12-2007 06:53 AM
Edwin vMierlo [MVP]

I have a statement in the sp which does something like this. @sql = 'SELECT OrderDate,CustID,Total,Balance from ' + @Remoteserver +...

Shiju Samuel

12-11-2007 09:54 AM
Shiju Samuel

I am attempting to configure SIS in a clustered environment using the instructions found at http://msdn2.microsoft.com/en-us/library/ms345193.aspx. I...

Fayven Wren

12-10-2007 11:22 AM
Fayven Wren

Is it possible to have a stretched cluster (MNS) across 2 datacenters running SQL? For example, a SAN in each datacenter with replication, and 1...

daesimps

12-08-2007 08:53 PM
daveberm

Hi, I am sure that someone has managed to do this. We have a 64_bit Clustered SQL2005 SP2 build 3175 server that we created as Latin1_General_Bin....

Chris Wood

12-07-2007 09:57 AM
Chris Wood

Hello there, I'm currently building up a SQL 2005 Active/Standby cluster in a DMZ. I have three NIC's in each server. Each NIC is connected to a...

chrismk

12-06-2007 09:08 AM
Tom Moreau

I have two node cluster (active-pasive) and two instances of SQL server 2005 running on that cluster. Default SQL instance was installed as...

Bogdan S.

12-05-2007 04:18 PM
Geoff N. Hiten

Hi: I'm trying to install MS SQL 2005 Standard x64 to a two node Windows Server 2003 R2 SP2 cluster. I've setup the cluster as per MS requirements...

Paul Hons

12-05-2007 12:46 AM
Jeffrey Williams

Is there a utility (and if so where can I get it) to compare 2 MS Windows 2003 cluster nodes. Basically, I want to be able to compare drivers...

GMG

12-04-2007 03:51 PM
Chuck [MSFT]

Have got multiple SQL environments, both 2000 & 2005. Of these two are clusters, one 2000 & one 2005. Over remote VPN connection I can connect to...

AndyT

12-04-2007 09:45 AM
Geoff N. Hiten

Hi I'm a little confused how best to setup a new 2005 deployment. I'm moving from a 2000 environment, which used Legato's AAM software to support...

steve

12-04-2007 05:01 AM
steve

Build 2187 is a cummulative hotfix package. My understanding of this is that it contains all hotfixes post SP4 up to the point of the package...

RayAtTheBeach

12-03-2007 10:11 AM
RayAtTheBeach

I got an interesting post yesterday on this site where the person pointed out that with Mirroring you could apply a service pack on the Mirror, take...

CLM

12-03-2007 08:30 AM
Russ Kaufmann [MVP]

Hi, I know this is a generic error and there is alot of info but i can't seem to find this error anywhere. (Please look at the bottom of the...

drumdave

12-02-2007 10:26 PM
drumdave

Overview: We are planning a 2 node cluster. The Active node will be 8 GB RAM with one instance of SQL 2005 and 150 GB of SAN disk. This is...

Don.Ramler

12-01-2007 06:02 PM
Tom Moreau

how to find out if a TSQL table is being updated? for example if someone does an update to a table that takes a long time, is there anyway for me to...

DR

12-01-2007 10:30 AM
Linchi Shea

Most likely, you'll get the first value (BTW, remove the OREDER BY clause). But that is not guaranteed at all. BOL explicitly documents this scenario...

Linchi Shea

12-01-2007 10:25 AM
Linchi Shea

I recently added an additional node to a 2 node cluster hopeing to achieve N+1 I am running win2k3SP1, SQL2000SP3. I can fail over clustering and...

Brian L

11-29-2007 12:10 PM
Geoff N. Hiten

We are interested in Active/Active/Active/Passive model. Best practices etc. Thanks in advance!

tc

11-29-2007 01:04 AM
tc