Cluster SQL Active-Active

My friends:
I need document information about the installation process of SQL in Cluster
with two instances, both active, one in each Server. In summary I want to
install a Cluster of SQL Active-Active, for take greater benefit of both
Cluster nodes.
Even though I have looked for in BOL (follow the recommendations of Maxi), I
had investigate and knock the same trouble, there are only information about
the Active-Pasive installation, and I'll wish a procedure or document about
Active-Active setup and installation.
If someone knows where I can find the information, or somebody understand
about Active-Active installation, please give it me know. Thanks a lot.
Regards,
Carlo Sorrel
Hello Carlo,
Once you have installed the first instance of virtual SQL Server 2000 then the steps for installing the second instance of virtual SQL Server 2000 is exactly the same. The second virtual instance of SQL Server 2000
will need a seperate shared drive (you cannot use the shared drive that you used for the first instance), unique SQL IP Address (again you cannot use the one you used for your windows cluster ip or the first sql
server ip) and unique SQL network name. Also, if the first virtual instance is a default instance then the second instance can ONLY be a named instance. You CANNOT have two default virtual SQL Server 2000
instance on the same cluster. To have both the instances similar, many customers install both instances of virtual SQL Server 2000 as named instances.
Since you have multiple instances (2 in your case), you will need to ensure that all server nodes have the same resources (processor, memory) and it is enough to handle the instances that could potentially fail to
that node. Another important consideration is to cap memory usage of the instance of SQL Server 2000 with max server memory. Especially if AWE memory is enabled, max server memory must be set in a
multiple-instance cluster to prevent starving the server node.
If you have a Windows Server 2003 EE cluster then you may find the following webcast useful
TechNet Support WebCast: How to install a Microsoft SQL Server 2000 virtual server on a Microsoft Windows Server 2003 cluster
Discusses how to install Microsoft SQL Server 2000 clustering on Microsoft Windows Server 2003 and differences between Microsoft Windows 2000 Server and Windows Server 2003.
http://support.microsoft.com/default...b;en-us;888121
For Win2K Adv Server cluster, you may find the following whitepaper useful
SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/pro.../failclus.mspx
Review the above and feel free to post any other qs that you may have.
Additional Information
=======================
Here is some other related links that you may find useful
INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings
http://support.microsoft.com/?kbid=254321
Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default...lurb051001.asp
Microsoft SQL Server 2000 Virtual Server: Things You Should Know
http://support.microsoft.com/default...lurb032602.asp
Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and Service Pack http://support.microsoft.com/default...lurb061002.asp
Microsoft SQL Server 2000 Failover Clustering Disaster Recovery Procedures
http://support.microsoft.com/default...lurb101802.asp
Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
http://support.microsoft.com/default...lurb020703.asp
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Hi
Just be aware, Active-Active does not mean load balancing. It means 2
instances of different databases, each running by default on one of the
nodes of a cluster.
The references Uttam has supplied are great and will help you along.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Carlo Sorrel" <csorrel@.hotmail.com> wrote in message
news:#nPFJo7AFHA.3576@.TK2MSFTNGP11.phx.gbl...
> My friends:
>
> I need document information about the installation process of SQL in
Cluster
> with two instances, both active, one in each Server. In summary I want to
> install a Cluster of SQL Active-Active, for take greater benefit of both
> Cluster nodes.
>
> Even though I have looked for in BOL (follow the recommendations of Maxi),
I
> had investigate and knock the same trouble, there are only information
about
> the Active-Pasive installation, and I'll wish a procedure or document
about
> Active-Active setup and installation.
>
> If someone knows where I can find the information, or somebody understand
> about Active-Active installation, please give it me know. Thanks a lot.
>
> Regards,
>
> Carlo Sorrel
>
|||first, sorry my english..., apears this error during instalattion the second instance on Cluster Windows 2003.
The description for Event ID ( 17052 ) in Source ( MSSQL$LASCAR ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 35; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Tahnk's.
Carlo Sorrel.
"Uttam Parui[MS]" <uttamkp@.online.microsoft.com> escribi en el mensaje news:uX597q8AFHA.1680@.cpmsftngxa10.phx.gbl...
> Hello Carlo,
> Once you have installed the first instance of virtual SQL Server 2000 then the steps for installing the second instance of virtual SQL Server 2000 is exactly the same. The second virtual instance of SQL Server 2000
> will need a seperate shared drive (you cannot use the shared drive that you used for the first instance), unique SQL IP Address (again you cannot use the one you used for your windows cluster ip or the first sql
> server ip) and unique SQL network name. Also, if the first virtual instance is a default instance then the second instance can ONLY be a named instance. You CANNOT have two default virtual SQL Server 2000
> instance on the same cluster. To have both the instances similar, many customers install both instances of virtual SQL Server 2000 as named instances.
> Since you have multiple instances (2 in your case), you will need to ensure that all server nodes have the same resources (processor, memory) and it is enough to handle the instances that could potentially fail to
> that node. Another important consideration is to cap memory usage of the instance of SQL Server 2000 with max server memory. Especially if AWE memory is enabled, max server memory must be set in a
> multiple-instance cluster to prevent starving the server node.
> If you have a Windows Server 2003 EE cluster then you may find the following webcast useful
> TechNet Support WebCast: How to install a Microsoft SQL Server 2000 virtual server on a Microsoft Windows Server 2003 cluster
> Discusses how to install Microsoft SQL Server 2000 clustering on Microsoft Windows Server 2003 and differences between Microsoft Windows 2000 Server and Windows Server 2003.
> http://support.microsoft.com/default...b;en-us;888121
>
> For Win2K Adv Server cluster, you may find the following whitepaper useful
> SQL Server 2000 Failover Clustering
> http://www.microsoft.com/technet/pro.../failclus.mspx
> Review the above and feel free to post any other qs that you may have.
> Additional Information
> =======================
> Here is some other related links that you may find useful
> INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings
> http://support.microsoft.com/?kbid=254321
> Introduction to Microsoft SQL Server 2000 Clustering
> http://support.microsoft.com/default...lurb051001.asp
> Microsoft SQL Server 2000 Virtual Server: Things You Should Know
> http://support.microsoft.com/default...lurb032602.asp
>
> Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and Service Pack http://support.microsoft.com/default...lurb061002.asp
> Microsoft SQL Server 2000 Failover Clustering Disaster Recovery Procedures
> http://support.microsoft.com/default...lurb101802.asp
> Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
> http://support.microsoft.com/default...lurb020703.asp
>
> HTH,
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>

cluster questions

Hi all, I had 2 questions regarding clusters:-
1. Is it possible to have an Active-Active configuration with 1 instance
running 2000 & 1 instance running 2005?
2. Is it recommended or required to have cluster servers part of an active
directory domain? Currently we have 2 servers that are part of our domain
and we are contemplating using them for a cluster. They meet all the
hardware & software requirements, but need to check on AD.
TIA!
Yes to both.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
<param@.community.nospam> wrote in message
news:OHeRQR$RGHA.440@.TK2MSFTNGP10.phx.gbl...
Hi all, I had 2 questions regarding clusters:-
1. Is it possible to have an Active-Active configuration with 1 instance
running 2000 & 1 instance running 2005?
2. Is it recommended or required to have cluster servers part of an active
directory domain? Currently we have 2 servers that are part of our domain
and we are contemplating using them for a cluster. They meet all the
hardware & software requirements, but need to check on AD.
TIA!
|||Yes to both. I have run side-by-side installations of 2000 and 2005 in both
clustered and non-clustered environments. Everything works, including both
sets of client tools.
As for #2, cluster nodes must be members of a domain, either NT4 or Active
Directory. They must be member servers, not domain controllers.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<param@.community.nospam> wrote in message
news:OHeRQR$RGHA.440@.TK2MSFTNGP10.phx.gbl...
> Hi all, I had 2 questions regarding clusters:-
> 1. Is it possible to have an Active-Active configuration with 1 instance
> running 2000 & 1 instance running 2005?
> 2. Is it recommended or required to have cluster servers part of an active
> directory domain? Currently we have 2 servers that are part of our domain
> and we are contemplating using them for a cluster. They meet all the
> hardware & software requirements, but need to check on AD.
> TIA!
>
|||So the consensus is that I would need the cluster servers to be member of a
domain... thanks
If I am new to setting up a cluster, is there a document/resource cheat
guide I can read to get up to speed?
TIA
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:eWMfUyESGHA.4920@.tk2msftngp13.phx.gbl...
> Yes to both. I have run side-by-side installations of 2000 and 2005 in
> both clustered and non-clustered environments. Everything works,
> including both sets of client tools.
> As for #2, cluster nodes must be members of a domain, either NT4 or
> Active Directory. They must be member servers, not domain controllers.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> <param@.community.nospam> wrote in message
> news:OHeRQR$RGHA.440@.TK2MSFTNGP10.phx.gbl...
>

Cluster MAS 2000

We are planning to cluster SQL Server 2005 (Active-Active). Can we also
cluster Microsoft Analysis Services 2000 on the same nodes ? If we can, what
are the issues we need to be aware ?
We are not ready to go to Analysis Services 2005 yet.
Thanks.Take a look at the following MS KB:
http://support.microsoft.com/kb/308023
--
Ekrem Ã?nsoy
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:1D7EABFE-1FCC-4C26-A211-3156A3E9E4DC@.microsoft.com...
> We are planning to cluster SQL Server 2005 (Active-Active). Can we also
> cluster Microsoft Analysis Services 2000 on the same nodes ? If we can,
> what
> are the issues we need to be aware ?
> We are not ready to go to Analysis Services 2005 yet.
>
> Thanks.

Cluster confusion, and instances?

Hey,
I am trying to setup a clustered SQL 2000 environement (active-active) with
3 instances UAT, DEV and PROD.
Should i be using 3 named instances ? Or do I install 3 virtual servers each
being a default instance? I know this is a newbie question but please some
help would be appreciated.
At the moment I would expect 3 virtual servers of SQL 2000 each with their
own IP and NETBIOS name? ie.
10.10.10.1
10.10.10.2
10.10.10.3
Or do i just create 3 named insstances?ie.
10.10.10.1\UAT
10.10.10.1\DEV
10.10.10.1\PROD
Any help is appreciated.
> I am trying to setup a clustered SQL 2000 environement (active-active) with
> 3 instances UAT, DEV and PROD.
Having PROD share a cluster with QA and DEV defeats the whole purpose of
having a cluster which is to provide high availability.

> Should i be using 3 named instances ? Or do I install 3 virtual servers each
> being a default instance?
You can use three named instances. You can't have three default instances in
the same cluster; you can have only one default instance in a cluster.
Linchi
"Daniel" wrote:

> Hey,
> I am trying to setup a clustered SQL 2000 environement (active-active) with
> 3 instances UAT, DEV and PROD.
> Should i be using 3 named instances ? Or do I install 3 virtual servers each
> being a default instance? I know this is a newbie question but please some
> help would be appreciated.
> At the moment I would expect 3 virtual servers of SQL 2000 each with their
> own IP and NETBIOS name? ie.
> 10.10.10.1
> 10.10.10.2
> 10.10.10.3
> Or do i just create 3 named insstances?ie.
> 10.10.10.1\UAT
> 10.10.10.1\DEV
> 10.10.10.1\PROD
> Any help is appreciated.

Cluster confusion, and instances?

Hey,
I am trying to setup a clustered SQL 2000 environement (active-active) with
3 instances UAT, DEV and PROD.
Should i be using 3 named instances ? Or do I install 3 virtual servers each
being a default instance? I know this is a newbie question but please some
help would be appreciated.
At the moment I would expect 3 virtual servers of SQL 2000 each with their
own IP and NETBIOS name? ie.
10.10.10.1
10.10.10.2
10.10.10.3
Or do i just create 3 named insstances?ie.
10.10.10.1\UAT
10.10.10.1\DEV
10.10.10.1\PROD
Any help is appreciated.> I am trying to setup a clustered SQL 2000 environement (active-active) with
> 3 instances UAT, DEV and PROD.
Having PROD share a cluster with QA and DEV defeats the whole purpose of
having a cluster which is to provide high availability.
> Should i be using 3 named instances ? Or do I install 3 virtual servers each
> being a default instance?
You can use three named instances. You can't have three default instances in
the same cluster; you can have only one default instance in a cluster.
Linchi
"Daniel" wrote:
> Hey,
> I am trying to setup a clustered SQL 2000 environement (active-active) with
> 3 instances UAT, DEV and PROD.
> Should i be using 3 named instances ? Or do I install 3 virtual servers each
> being a default instance? I know this is a newbie question but please some
> help would be appreciated.
> At the moment I would expect 3 virtual servers of SQL 2000 each with their
> own IP and NETBIOS name? ie.
> 10.10.10.1
> 10.10.10.2
> 10.10.10.3
> Or do i just create 3 named insstances?ie.
> 10.10.10.1\UAT
> 10.10.10.1\DEV
> 10.10.10.1\PROD
> Any help is appreciated.sqlsql

Cluster confusion, and instances?

Hey,
I am trying to setup a clustered SQL 2000 environement (active-active) with
3 instances UAT, DEV and PROD.
Should i be using 3 named instances ? Or do I install 3 virtual servers each
being a default instance? I know this is a newbie question but please some
help would be appreciated.
At the moment I would expect 3 virtual servers of SQL 2000 each with their
own IP and NETBIOS name? ie.
10.10.10.1
10.10.10.2
10.10.10.3
Or do i just create 3 named insstances?ie.
10.10.10.1\UAT
10.10.10.1\DEV
10.10.10.1\PROD
Any help is appreciated.> I am trying to setup a clustered SQL 2000 environement (active-active) with">
> 3 instances UAT, DEV and PROD.
Having PROD share a cluster with QA and DEV defeats the whole purpose of
having a cluster which is to provide high availability.

> Should i be using 3 named instances ? Or do I install 3 virtual servers ea
ch
> being a default instance?
You can use three named instances. You can't have three default instances in
the same cluster; you can have only one default instance in a cluster.
Linchi
"Daniel" wrote:

> Hey,
> I am trying to setup a clustered SQL 2000 environement (active-active) wit
h
> 3 instances UAT, DEV and PROD.
> Should i be using 3 named instances ? Or do I install 3 virtual servers ea
ch
> being a default instance? I know this is a newbie question but please some
> help would be appreciated.
> At the moment I would expect 3 virtual servers of SQL 2000 each with their
> own IP and NETBIOS name? ie.
> 10.10.10.1
> 10.10.10.2
> 10.10.10.3
> Or do i just create 3 named insstances?ie.
> 10.10.10.1\UAT
> 10.10.10.1\DEV
> 10.10.10.1\PROD
> Any help is appreciated.

Cluster Active-Active - Parallelism

Cluster active-active enviroment.
Memory: How can I determine how much memory I need to set ? If I leave
dynamically and one node falls down I receive message error about allocate
memory.
CPU: Processor - Parallelism - Use all available processors. There are 2
processors on each server. In this case I can set this option ON ? If the one
node falls down SQLserver will try to use 2 or 4 processors ?
thanks in advance
set max server memory on both servers so that fail over of either server does
not result in total memory greater than total server memory on each box.
Also with cpu if you have configured to use all available cpus then all
available cpus will be utilized. ie. sql will use only the number of
processors on the server.
HTH
"Shima" wrote:

> Cluster active-active enviroment.
> Memory: How can I determine how much memory I need to set ? If I leave
> dynamically and one node falls down I receive message error about allocate
> memory.
> CPU: Processor - Parallelism - Use all available processors. There are 2
> processors on each server. In this case I can set this option ON ? If the one
> node falls down SQLserver will try to use 2 or 4 processors ?
> thanks in advance
>
|||It is useful that resurces used by instances, does not be greater than one
node...
I
"Olu Adedeji" wrote:
[vbcol=seagreen]
> set max server memory on both servers so that fail over of either server does
> not result in total memory greater than total server memory on each box.
> Also with cpu if you have configured to use all available cpus then all
> available cpus will be utilized. ie. sql will use only the number of
> processors on the server.
>
> HTH
>
> "Shima" wrote:

Cluster Active-Active - Parallelism

Cluster active-active enviroment.
Memory: How can I determine how much memory I need to set ? If I leave
dynamically and one node falls down I receive message error about allocate
memory.
CPU: Processor - Parallelism - Use all available processors. There are 2
processors on each server. In this case I can set this option ON ? If the one
node falls down SQLserver will try to use 2 or 4 processors ?
thanks in advanceset max server memory on both servers so that fail over of either server does
not result in total memory greater than total server memory on each box.
Also with cpu if you have configured to use all available cpus then all
available cpus will be utilized. ie. sql will use only the number of
processors on the server.
HTH
"Shima" wrote:
> Cluster active-active enviroment.
> Memory: How can I determine how much memory I need to set ? If I leave
> dynamically and one node falls down I receive message error about allocate
> memory.
> CPU: Processor - Parallelism - Use all available processors. There are 2
> processors on each server. In this case I can set this option ON ? If the one
> node falls down SQLserver will try to use 2 or 4 processors ?
> thanks in advance
>|||It is useful that resurces used by instances, does not be greater than one
node...
I
"Olu Adedeji" wrote:
> set max server memory on both servers so that fail over of either server does
> not result in total memory greater than total server memory on each box.
> Also with cpu if you have configured to use all available cpus then all
> available cpus will be utilized. ie. sql will use only the number of
> processors on the server.
>
> HTH
>
> "Shima" wrote:
> > Cluster active-active enviroment.
> > Memory: How can I determine how much memory I need to set ? If I leave
> > dynamically and one node falls down I receive message error about allocate
> > memory.
> > CPU: Processor - Parallelism - Use all available processors. There are 2
> > processors on each server. In this case I can set this option ON ? If the one
> > node falls down SQLserver will try to use 2 or 4 processors ?
> > thanks in advance
> >

Cluster Active-Active - Parallelism

Cluster active-active enviroment.
Memory: How can I determine how much memory I need to set ? If I leave
dynamically and one node falls down I receive message error about allocate
memory.
CPU: Processor - Parallelism - Use all available processors. There are 2
processors on each server. In this case I can set this option ON ? If the on
e
node falls down SQLserver will try to use 2 or 4 processors ?
thanks in advanceset max server memory on both servers so that fail over of either server doe
s
not result in total memory greater than total server memory on each box.
Also with cpu if you have configured to use all available cpus then all
available cpus will be utilized. ie. sql will use only the number of
processors on the server.
HTH
"Shima" wrote:

> Cluster active-active enviroment.
> Memory: How can I determine how much memory I need to set ? If I leave
> dynamically and one node falls down I receive message error about allocate
> memory.
> CPU: Processor - Parallelism - Use all available processors. There are 2
> processors on each server. In this case I can set this option ON ? If the
one
> node falls down SQLserver will try to use 2 or 4 processors ?
> thanks in advance
>|||It is useful that resurces used by instances, does not be greater than one
node...
I
"Olu Adedeji" wrote:
[vbcol=seagreen]
> set max server memory on both servers so that fail over of either server d
oes
> not result in total memory greater than total server memory on each box.
> Also with cpu if you have configured to use all available cpus then all
> available cpus will be utilized. ie. sql will use only the number of
> processors on the server.
>
> HTH
>
> "Shima" wrote:
>sqlsql

Client EM produce OS "failed login errors"

hi all, have anyone else met with the following problem.

we've got a SQL2000SP3a on a 2 active-active node clusters of W2K3,
this cluster in using AD.

I've found that whenever I use Enterprise Manager on my local computer
to register the above instance, it will constantly produce "Failed
login for <Domain>\<DomainUser>" errors in the Windows Security Log of
the database server machine. There's no failed login in the SQL error
log and I can work normally with the Enterprise Manager. The OS failed
logins error are gone once I un-register the instance from my
Enterprise Manager.

Does anyone know or met with this before?"New MSSQL DBA" <boscong88@.gmail.com> wrote in message
news:1120635376.062877.121860@.z14g2000cwz.googlegr oups.com...
> hi all, have anyone else met with the following problem.
> we've got a SQL2000SP3a on a 2 active-active node clusters of W2K3,
> this cluster in using AD.
> I've found that whenever I use Enterprise Manager on my local computer
> to register the above instance, it will constantly produce "Failed
> login for <Domain>\<DomainUser>" errors in the Windows Security Log of
> the database server machine. There's no failed login in the SQL error
> log and I can work normally with the Enterprise Manager. The OS failed
> logins error are gone once I un-register the instance from my
> Enterprise Manager.
> Does anyone know or met with this before?

I don't really know, but as a complete guess, EM is trying to connect to the
operating system to get information about the MSSQL service state, and your
Windows account doesn't have those permissions. If this isn't helpful, you
might consider posting the full error details from the log.

Simon