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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|