Hello,
I have an A/P W2K3 Cluster with SQL 2K-SP3. When I fail it over to the
passive node, only the virtual server name is available, not the SQL IP Addr
I have a A/P NT 4 Cluster with SQL 7 and the name and Addr fail over..
In the cluster Admin, both servers are listed unbder the SQLIP addr...
Thoughts?
Thank You,
Tony B
Hi
Any errors in the OS event log?
If it does not fail-over correctly, it must be complaining about something.
Regards
Mike
"tbithoney" wrote:
> Hello,
> I have an A/P W2K3 Cluster with SQL 2K-SP3. When I fail it over to the
> passive node, only the virtual server name is available, not the SQL IP Addr
> I have a A/P NT 4 Cluster with SQL 7 and the name and Addr fail over..
> In the cluster Admin, both servers are listed unbder the SQLIP addr...
> Thoughts?
> Thank You,
> Tony B
|||Sorry, nothing on either node..
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Any errors in the OS event log?
> If it does not fail-over correctly, it must be complaining about something.
> Regards
> Mike
> "tbithoney" wrote:
|||Hello Tony,
Does all resources in the SQL group come online on the active node?
What happens when you move the SQL group to the passive node? From your statement above, you said that only the virtual server name is available, not SQL IP addr.
What do you mean? If any of the resources fail on the passive node then the default behavior will to retry 3 times and then it will move the full group to the other node. Is this
what is happening? Give more details.
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
|||hello,
yes, all the SQL comes on line.
When I attach to SQLSERVER in sql enterprise mgr, it attaches, however, If I
attach to 10.1.1.1, the addr of the SQLSERVER, it fails..
-Should the CLUSTER SERVICE be AUToMATIC startup on the passive node?
-SQLSERVER Also be AUTOMATIC startup on the passive node?
"Uttam Parui[MS]" wrote:
> Hello Tony,
> Does all resources in the SQL group come online on the active node?
> What happens when you move the SQL group to the passive node? From your statement above, you said that only the virtual server name is available, not SQL IP addr.
> What do you mean? If any of the resources fail on the passive node then the default behavior will to retry 3 times and then it will move the full group to the other node. Is this
> what is happening? Give more details.
> 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
>
>
|||Leave the services to manual. Are you using the virtual IP for the SQL
instance or the real IP of a node? Always use the Virtual IP of SQL.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"tbithoney" <tbithoney@.comcast.net> wrote in message
news:1797A08C-6A04-400B-9784-89CC5253E004@.microsoft.com...[vbcol=seagreen]
> hello,
> yes, all the SQL comes on line.
> When I attach to SQLSERVER in sql enterprise mgr, it attaches, however, If
> I
> attach to 10.1.1.1, the addr of the SQLSERVER, it fails..
> -Should the CLUSTER SERVICE be AUToMATIC startup on the passive node?
> -SQLSERVER Also be AUTOMATIC startup on the passive node?
>
>
>
> "Uttam Parui[MS]" wrote:
|||hello,
Vitrual IP.
The services will remain manual...
"Rodney R. Fournier [MVP]" wrote:
> Leave the services to manual. Are you using the virtual IP for the SQL
> instance or the real IP of a node? Always use the Virtual IP of SQL.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
> "tbithoney" <tbithoney@.comcast.net> wrote in message
> news:1797A08C-6A04-400B-9784-89CC5253E004@.microsoft.com...
>
>
|||Is 10.1.1.1 the virtual SQL Server IP Address? Can you paste the SQL Server Errorlog to get more information?
Also, the Cluster Service is AUTOMATIC on ALL nodes( active and passive) whereas the SQL Server and SQL Server Agent service accounts are MANUAL on ALL nodes (active and passive). This the correct
startup type and changing it can give you unexpalanable behaviors.
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
Showing posts with label w2k3. Show all posts
Showing posts with label w2k3. Show all posts
Thursday, March 22, 2012
Active/Active SQL Cluster
I have two new SQL 2000 instances on separate Win2K3 servers. Is there a way within W2K3 to set them up as an active/active cluster. And do I need to set it up just one one server(insert cd and it will recognize the other server to connect.
We cannot take standalone Win2K3 servers and form a cluster. We need to have a Certfied Cluster Solution listed in Microsoft Hardware Compatibility List (HCL).
A certified cluster does not consist simply of parts that individually reside on the Microsoft Hardware Compatibility List (HCL).
For example, suppose Server model S, HBA model H, storage frame F, and fibre switch W are all certified with Microsoft. This does not mean that a cluster built with S+H+F+W is supported - and customers
requiring support should not simply build a solution with these components.
Non-certified cluster solutions are not guaranteed to operate correctly. For example, the shared disks may be visible to multiple nodes and this can lead to corruption of application data or instability where the
connection to the disks is not reliable. You can waste a lot of time by attempting to troubleshoot perceived server cluster issues that are being caused by the cluster hardware that you are using.
How to locate qualified cluster solutions for Windows
http://support.microsoft.com/?id=828262
NOTE: If the cluster solution is not listed on the HCL or WSC in the Cluster category, the cluster solution is considered UNSUPPORTED. However, Microsoft PSS will offer troubleshooting tips if the customer
requests them. PSS does NOT guarantee that a resolution will be found for non-HCL or non-WSC Clusters. If no resolution is found, the incident is not refunded.
Q309395 The Microsoft Support Policy for Server Clusters and the HCL
http://support.microsoft.com/?kbid=309395
Q327518 The Microsoft Support Policy for Clustered SQL Servers
http://support.microsoft.com/?kbid=327518
Here are some links that will give a good understanding of Microsoft Cluster Server and SQL Server 2000 Failover Clustering
Support WebCast: Windows Clustering: An Overview of Microsoft Clustering Technologies
http://support.microsoft.com/?id=325423
Step-by-step instructions for creating and configuring a typical single quorum device multi-node server cluster using a shared disk on servers running the Microsoft Windows Server 2003 Enterprise Edition and
Windows Server 2003 Datacenter Edition operating systems.
http://www.microsoft.com/downloads/d...displaylang=en
Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/SQL/techinf...vercluster.asp
SQL Server 2000 Pricing and Licensing
http://www.microsoft.com/sql/howtobu...rlicensing.asp
Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
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
|||I have two w2k3 servers set up as active/passive cluster. Is it possible to set up an active/active cluster on the two SQL2K servers for them
"DBA" wrote:
> I have two new SQL 2000 instances on separate Win2K3 servers. Is there a way within W2K3 to set them up as an active/active cluster. And do I need to set it up just one one server(insert cd and it will recognize the other server to connect.
|||With 2000. the right terminology is single or multi instance.
Active/Active terminology doesnot apply to SQL 2000.
Yes it is possible.
"DBA" wrote:
[vbcol=seagreen]
> I have two w2k3 servers set up as active/passive cluster. Is it possible to set up an active/active cluster on the two SQL2K servers for them
> "DBA" wrote:
We cannot take standalone Win2K3 servers and form a cluster. We need to have a Certfied Cluster Solution listed in Microsoft Hardware Compatibility List (HCL).
A certified cluster does not consist simply of parts that individually reside on the Microsoft Hardware Compatibility List (HCL).
For example, suppose Server model S, HBA model H, storage frame F, and fibre switch W are all certified with Microsoft. This does not mean that a cluster built with S+H+F+W is supported - and customers
requiring support should not simply build a solution with these components.
Non-certified cluster solutions are not guaranteed to operate correctly. For example, the shared disks may be visible to multiple nodes and this can lead to corruption of application data or instability where the
connection to the disks is not reliable. You can waste a lot of time by attempting to troubleshoot perceived server cluster issues that are being caused by the cluster hardware that you are using.
How to locate qualified cluster solutions for Windows
http://support.microsoft.com/?id=828262
NOTE: If the cluster solution is not listed on the HCL or WSC in the Cluster category, the cluster solution is considered UNSUPPORTED. However, Microsoft PSS will offer troubleshooting tips if the customer
requests them. PSS does NOT guarantee that a resolution will be found for non-HCL or non-WSC Clusters. If no resolution is found, the incident is not refunded.
Q309395 The Microsoft Support Policy for Server Clusters and the HCL
http://support.microsoft.com/?kbid=309395
Q327518 The Microsoft Support Policy for Clustered SQL Servers
http://support.microsoft.com/?kbid=327518
Here are some links that will give a good understanding of Microsoft Cluster Server and SQL Server 2000 Failover Clustering
Support WebCast: Windows Clustering: An Overview of Microsoft Clustering Technologies
http://support.microsoft.com/?id=325423
Step-by-step instructions for creating and configuring a typical single quorum device multi-node server cluster using a shared disk on servers running the Microsoft Windows Server 2003 Enterprise Edition and
Windows Server 2003 Datacenter Edition operating systems.
http://www.microsoft.com/downloads/d...displaylang=en
Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/SQL/techinf...vercluster.asp
SQL Server 2000 Pricing and Licensing
http://www.microsoft.com/sql/howtobu...rlicensing.asp
Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
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
|||I have two w2k3 servers set up as active/passive cluster. Is it possible to set up an active/active cluster on the two SQL2K servers for them
"DBA" wrote:
> I have two new SQL 2000 instances on separate Win2K3 servers. Is there a way within W2K3 to set them up as an active/active cluster. And do I need to set it up just one one server(insert cd and it will recognize the other server to connect.
|||With 2000. the right terminology is single or multi instance.
Active/Active terminology doesnot apply to SQL 2000.
Yes it is possible.
"DBA" wrote:
[vbcol=seagreen]
> I have two w2k3 servers set up as active/passive cluster. Is it possible to set up an active/active cluster on the two SQL2K servers for them
> "DBA" wrote:
Tuesday, March 20, 2012
Active/Active Cluster
I have two w2k3 servers set up as active/passive cluster. Is it possible to set up an active/active cluster on the two SQL2K servers for them
I am sorry but I don't fully understand your question. Please give more details for us to help you with you qs.
You said "I have two w2k3 servers set up as active/passive cluster. Is it possible to set up an active/active cluster on the two SQL2K servers for them". I am assuming you
have two node w2k3 active/passive cluster. Active/passive meaning one node of the cluster has all the resources available, while the other node is idle and waiting in
case of a failover. Is that what you mean? What resources do you have on the active node?
Also you want o set up an active/active cluster on the two SQL2K server? Do you mean by this that you want one instance of SQL2K virtual server on each node? If yes,
then yes - you can set up acive/active cluster with one instance of sql 2k server.
Here is a link to Microsoft SQL 2K Failover Clustering whitepaper that will give you more information
SQL Server 2000 Failover Clustering
http://www.microsoft.com/SQL/techinf...vercluster.asp
Feel free to ask any related qs that you may have. Please give as much details as possible to get a better answer.
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
sql
I am sorry but I don't fully understand your question. Please give more details for us to help you with you qs.
You said "I have two w2k3 servers set up as active/passive cluster. Is it possible to set up an active/active cluster on the two SQL2K servers for them". I am assuming you
have two node w2k3 active/passive cluster. Active/passive meaning one node of the cluster has all the resources available, while the other node is idle and waiting in
case of a failover. Is that what you mean? What resources do you have on the active node?
Also you want o set up an active/active cluster on the two SQL2K server? Do you mean by this that you want one instance of SQL2K virtual server on each node? If yes,
then yes - you can set up acive/active cluster with one instance of sql 2k server.
Here is a link to Microsoft SQL 2K Failover Clustering whitepaper that will give you more information
SQL Server 2000 Failover Clustering
http://www.microsoft.com/SQL/techinf...vercluster.asp
Feel free to ask any related qs that you may have. Please give as much details as possible to get a better answer.
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
sql
Subscribe to:
Posts (Atom)