New to Clustering - 2003 Server Enterprise & SQL 2000

I am new to clustering and would like to implement and active/active SQL
cluster, which would allow the functions of one of the nodes to fail over to
the other in the event of a problem.
I have two identrical servers in terms of hardware connected to a SAN and
running Windows Server 2003 Enterprise and will be using SQL 2000.
What are the steps for setting this up?
"john d" <johnd@.discussions.microsoft.com> wrote in message
news:5C2F1423-BD96-4B83-8D1A-E8346793B8A3@.microsoft.com...
> I am new to clustering and would like to implement and active/active SQL
> cluster, which would allow the functions of one of the nodes to fail over
> to
> the other in the event of a problem.
> I have two identrical servers in terms of hardware connected to a SAN and
> running Windows Server 2003 Enterprise and will be using SQL 2000.
> What are the steps for setting this up?
1. Attend training to support your extremely expensive cluster with
extremely important databases.
2. Build your cluster
3. Install SQL on your cluster
http://support.microsoft.com/Default.aspx?kbid=243218
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
|||What do "you" mean by Active/Active? In a clustered configuration, you
install SQL Server to all participating nodes, but then a virtual server is
hosted by only one of them at any given time. If, however, one of the nodes
becomes unavailable, one of the other nodes can host the resources.
Active/Active on Microsoft Clustering means you have multiple cluster
resource groups (i.e., virtual servers) running at the same time with
multiple nodes all hosting different resources.
Anthony Thomas

"john d" <johnd@.discussions.microsoft.com> wrote in message
news:5C2F1423-BD96-4B83-8D1A-E8346793B8A3@.microsoft.com...
> I am new to clustering and would like to implement and active/active SQL
> cluster, which would allow the functions of one of the nodes to fail over
to
> the other in the event of a problem.
> I have two identrical servers in terms of hardware connected to a SAN and
> running Windows Server 2003 Enterprise and will be using SQL 2000.
> What are the steps for setting this up?

new sql login using active directory

I have a sql admin who is not a domain admin and when he selects a new login for sql 2000 using the domain lookup it tells him he has no permission and can't see any user in active directory. He does have active directory users and computers on his desktop and can see them all there. Any suggestions' He is a local admin on the sql server box and can see local users.I would think you can't enumerate users and groups in
Active Directory unless you are given specific rights. I
know this is true for Open LDAP and IBM SecureWay bases
directory services. Ask him to enter NET USERS /DOMAIN
command on DOS command prompt and see if it lists all
users in the Domain. I would suggest you to post this
question to windows 2000 group, or ask your network admin.
This isn't a sql issue, if he is local admin then more
likely he has DBA privileges in server.
>--Original Message--
>I have a sql admin who is not a domain admin and when he
selects a new login for sql 2000 using the domain lookup
it tells him he has no permission and can't see any user
in active directory. He does have active directory users
and computers on his desktop and can see them all there.
Any suggestions' He is a local admin on the sql
server box and can see local users.
>.
>

New fresh 2005 cluster and SCC error

I am trying to setup an active/passive cluster (everything on 32bit
plateforme) on a virtualized environment. I followed several docs provided by
microsoft especially the one on /prodtechnol/virtualserver/deploy/cvs2005.mpx.
Regarding the w2k3 itself it seems everything is correct, I did all
necesary tests for testing the failover from one node to another and
evrything works correctly.
When I launch SQL 2005 setup on node1 (node 2 of course is on), Setup stops
indicating that some requirements are not met, an SCC Error.
I have an AMD Athlon 64 proc 3000 2.00GHz with and each VM was granted 512 G
of Ram.
I understand that min req is 600Htz for Procs and 512. When I open the
summary.txt file I have the following :
********************************************
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows Server 2003 family, Enterprise Edition
Service Pack 1 (Build 3790)
Time : Sat Mar 31 15:55:30 2007
SQLCLUST11 : The current system does not meet minimum hardware requirements
for this SQL Server release. For detailed hardware requirements, see the
readme file or SQL Server Books Online.
SQLCLUST11 : There was an unexpected failure during the setup wizard. You
may review the setup logs and/or click the help button for more information.
SQL Server Setup failed. For more information, review the Setup log file in
%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.
Time : Sat Mar 31 15:55:59 2007
List of log files:
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_Core(L ocal).log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_Datast ore.xml
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_.NET Framework 2.0.log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_Core.l og
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_.NET Framework 2.0 LangPack.log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_.NET Framework Upgrade Advisor.log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_.NET Framework Upgrade Advisor
LangPack.log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_.NET Framework Windows
Installer.log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_.NET Framework Windows Installer
LangPack.log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_Suppor t.log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_SCC.lo g
************************************************** ***
In fact I remember that I had an alert (! inside Yellow triangle) in the
final step of adding the second node. So the alert indicated the following :
**************************
Reanalyzing cluster
sqlclust12: c omparing cluster and node configurations...
sqlclust12: Collecting managed resources...
Triangle yellow : Status 0x00138f: The cluster resource could not be found
*****************************
As said, the cluster works like a charm (several failover tests)
Thank you for your help
"SalamElias" wrote:

> I am trying to setup an active/passive cluster (everything on 32bit
> plateforme) on a virtualized environment. I followed several docs provided by
> microsoft especially the one on /prodtechnol/virtualserver/deploy/cvs2005.mpx.
> Regarding the w2k3 itself it seems everything is correct, I did all
> necesary tests for testing the failover from one node to another and
> evrything works correctly.
> When I launch SQL 2005 setup on node1 (node 2 of course is on), Setup stops
> indicating that some requirements are not met, an SCC Error.
> I have an AMD Athlon 64 proc 3000 2.00GHz with and each VM was granted 512 G
> of Ram.
> I understand that min req is 600Htz for Procs and 512. When I open the
> summary.txt file I have the following :
> ********************************************
> Microsoft SQL Server 2005 9.00.1399.06
> ==============================
> OS Version : Microsoft Windows Server 2003 family, Enterprise Edition
> Service Pack 1 (Build 3790)
> Time : Sat Mar 31 15:55:30 2007
> SQLCLUST11 : The current system does not meet minimum hardware requirements
> for this SQL Server release. For detailed hardware requirements, see the
> readme file or SQL Server Books Online.
> SQLCLUST11 : There was an unexpected failure during the setup wizard. You
> may review the setup logs and/or click the help button for more information.
>
> SQL Server Setup failed. For more information, review the Setup log file in
> %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.
>
> Time : Sat Mar 31 15:55:59 2007
>
> List of log files:
> C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_Core(L ocal).log
> C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_Datast ore.xml
> C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_.NET Framework 2.0.log
> C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_Core.l og
> C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt
> C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_.NET Framework 2.0 LangPack.log
> C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_.NET Framework Upgrade Advisor.log
> C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_.NET Framework Upgrade Advisor
> LangPack.log
> C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_.NET Framework Windows
> Installer.log
> C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_.NET Framework Windows Installer
> LangPack.log
> C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_Suppor t.log
> C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0007_SQLCLUST11_SCC.lo g
> ************************************************** ***