Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007


all groups > sql server clustering > april 2006 > threads for april 1 - 7, 2006

Filter by week: 1 2 3 4 5

adding a sql2k5 instance to 2-sql2k instances
Posted by Aylmer at 4/7/2006 5:47:01 AM
We currently have a win2k3 2-node cluster is configured as Active/Passive. On each node has 2 instances of SQL2K. We now need to add a SQL2k5 instance to this cluster. Would the right way to go about this: 1. create a new cluster resource group which has disks not been used by SQL2k 2. creat...more >>

SQL 2005 Cluster Installation Issue
Posted by Alex at 4/6/2006 4:16:08 PM
Hi, My SQL 2005 fail over cluster installation fails with the following error: Machine : PrimaryNode Product : Microsoft SQL Server 2005 Product Version : 9.00.1399.06 Install : Failed Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\...more >>

clustering and "My Computer"
Posted by Cristiano Trebian at 4/6/2006 3:45:37 PM
hi all! i installed the windows 2000 cluster services on 2 machines.. every thing is ok, i can move groups, the resources are moved correctly... i installed sql 2000 in the virtual server and is all ok, both servers see the same databases, i can shut down one server, create a table in a db wi...more >>

Changing SQL Domain Account
Posted by Sam at 4/6/2006 3:26:24 PM
I need to change the domain account our SQL cluster is running under. The cluster is Win2k with a single instance of SQL 2000. I looked in the cluster Administrator and I don't see where it is specified. Do I use the services applet in control panel to specify the user for cluster service? I...more >>

One node Cluster for SQL 2005
Posted by Craig Gibb at 4/6/2006 12:37:02 PM
Hi anyone know if you can cluster sql on a one node cluster in Windows 2003 ? Regards Craig ...more >>

configuring ODBC to connecto to sql cluster server
Posted by lenasanz NO[at]SPAM gmail.com at 4/6/2006 8:38:35 AM
I need to connect to a sql server (in cluster) using my Enterprise Manager , i mean i need to do a New SQL Server Registration of an instance of a sql server (that belongs to another windows domain) If i am not wrong, i need first of all , to configure a new data source. It is that right?? ...more >>

Additional SQL Name on SQL Cluster
Posted by sivak at 4/6/2006 6:00:36 AM
Is there anyway to add an additional netbios name to a SQL Cluster? I am trying to consolidate some of our older SQL servers onto a pair of SQL Cluster servers, and am not able to risk losing the old SQL names due to some hard coding and the basic size of the network we are on. I have tried g...more >>

Can 2K5 Cluster can have 2 instances on each node?
Posted by DeBe at 4/5/2006 10:24:12 PM
Hi, We have sql 2005 standard installed as cluster on win2k3 cluster with GB memory on each node. We have one virtual sql server named instance o first node. Can we create one more instance on the same node an similarly 2 more instances on the second node. The cluster will be i active\activ...more >>



rebuild master db in cluster env
Posted by mecn at 4/5/2006 3:55:16 PM
Hi, Anyone knows howto rebuild master db in active/passive notes cluster env sql2005/ win2003? Thansk ...more >>

SQL Server 2005 Cluster Setup X Active Directory on Windows 2000
Posted by George Luiz Bittencourt at 4/4/2006 1:24:02 PM
Hi, I think i have found a bug when installing SQL Server 2005 in a cluster environment that is member of a Windows 2000 Active Directory domain. The bug comes in the screen where setup asks for groups in domain to services. It doesn´t matter what group its informed, i always get a messag...more >>

Moving sys db in cluster server
Posted by mecn at 4/4/2006 12:22:21 PM
Hi, I ran the following script to move the sys logs to diff location in the Active/passive notes cluster server. ALTER DATABASE msdb MODIFY FILE (NAME = msdblog, FILENAME = 'j:\Data\MSSQL.1\MSSQL\Data\msdblog.ldf'); and also for msdblog file Both ran OK with no problems. When I s...more >>

SQL 2000 SP4 installation questions in Failover cluster
Posted by suga at 4/4/2006 12:11:07 PM
Hi everyone, I am about to upgrade my SQL server from 2000 SP3 to SP4 and they are setup in a 2 node cluster environment. Are there any services that I would need to take it offline or stop before I install SQL 2000 SP4 on the cluster environment? I understand that we need to leave SQL serv...more >>

Analysis Services will not start after failover
Posted by Benny at 4/4/2006 8:58:22 AM
On Thursday, everything was fine. On Friday my second virtual instance of SQL Server was now on Node 2 for some reason. I tried to move it back to Node 1 and it failed and continued to go back to Node 2. I looked for errors in the SQL Error log and the system error logs and no information why...more >>

sql2k / w2k3 active/active/passive
Posted by dave stalling at 4/4/2006 6:30:50 AM
I want to use ONE (passive) SQL2k server with 2 instances of SQL running to be the backup to TWO active servers. Each active server is in it's own cluster....so can the passive server belong to each active cluster and can it handle a major failover of each primary (active) server? These db ...more >>

Evict cluster node BEFORE running SQL setup
Posted by Staffy at 4/3/2006 5:40:02 AM
Have a two node SQL cluster. Node one has failed and has been evicted from the cluster i.e. before running the SQL setup and removing the failed node from SQL and cleaniing the SQL binaries. What would the best way to proceed? Can the SQL setup be run after the node has been evicted? (T...more >>

SQL 2005 - Installation Fails 2k3 x64 Cluster - EventID 7004
Posted by sqlclusterhelp at 4/1/2006 4:31:52 AM
Hi Everyone, I am trying to install SQL 2005 (x64 version) on a 2 node clustered environment, using Windows Server 2003. After entering all the information for the setup, it begins and around a minute after it displays the window "Setup failed to start on the remote machine. Check the Task...more >>


DevelopmentNow Blog