Thursday, March 22, 2012

Active/Passive failover-Failed?

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

No comments:

Post a Comment