 | |
SQL 2005 Active/Passive
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
SQL 2005 Active/Passive -
12-20-2007
, 10:48 AM
#2
| |||
| |||
|
|
We have a sql2005 active/passive win2003 x64 cluster. when the db's are on the active node..we see all of the sql tools available. on the passive node, we don't. is this by design as we did a complete install. any help is appreciated. thx. steve |
#3
| |||
| |||
|
|
That's by design. Linchi "Steve" wrote: We have a sql2005 active/passive win2003 x64 cluster. when the db's are on the active node..we see all of the sql tools available. on the passive node, we don't. is this by design as we did a complete install. any help is appreciated. thx. steve |
#4
| |||
| |||
|
|
Thanks--so we need to fail it back to the active to get the full performance tools, etc.? "Linchi Shea" wrote: That's by design. Linchi "Steve" wrote: We have a sql2005 active/passive win2003 x64 cluster. when the db's are on the active node..we see all of the sql tools available. on the passive node, we don't. is this by design as we did a complete install. any help is appreciated. thx. steve |
#5
| |||
| |||
|
|
You can do a workstation components only install on the "other" node. The tools installation component is not cluster-aware. There is no problem with adding the tools to additional cluster nodes. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:7AD7D09F-90CA-413F-B4B8-17C67827704C (AT) microsoft (DOT) com... Thanks--so we need to fail it back to the active to get the full performance tools, etc.? "Linchi Shea" wrote: That's by design. Linchi "Steve" wrote: We have a sql2005 active/passive win2003 x64 cluster. when the db's are on the active node..we see all of the sql tools available. on the passive node, we don't. is this by design as we did a complete install. any help is appreciated. thx. steve |
#6
| |||
| |||
|
|
Do you have a link to the instructions..and should it be failed over to the other node when doing this? Thanks. Steve "Geoff N. Hiten" wrote: You can do a workstation components only install on the "other" node. The tools installation component is not cluster-aware. There is no problem with adding the tools to additional cluster nodes. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:7AD7D09F-90CA-413F-B4B8-17C67827704C (AT) microsoft (DOT) com... Thanks--so we need to fail it back to the active to get the full performance tools, etc.? "Linchi Shea" wrote: That's by design. Linchi "Steve" wrote: We have a sql2005 active/passive win2003 x64 cluster. when the db's are on the active node..we see all of the sql tools available. on the passive node, we don't. is this by design as we did a complete install. any help is appreciated. thx. steve |
#7
| |||
| |||
|
|
Do you have a link to the instructions..and should it be failed over to the other node when doing this? Thanks. Steve "Geoff N. Hiten" wrote: You can do a workstation components only install on the "other" node. The tools installation component is not cluster-aware. There is no problem with adding the tools to additional cluster nodes. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:7AD7D09F-90CA-413F-B4B8-17C67827704C (AT) microsoft (DOT) com... Thanks--so we need to fail it back to the active to get the full performance tools, etc.? "Linchi Shea" wrote: That's by design. Linchi "Steve" wrote: We have a sql2005 active/passive win2003 x64 cluster. when the db's are on the active node..we see all of the sql tools available. on the passive node, we don't. is this by design as we did a complete install. any help is appreciated. thx. steve |
#8
| |||
| |||
|
|
Do you have a link to the instructions..and should it be failed over to the other node when doing this? Thanks. Steve "Geoff N. Hiten" wrote: You can do a workstation components only install on the "other" node. The tools installation component is not cluster-aware. There is no problem with adding the tools to additional cluster nodes. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:7AD7D09F-90CA-413F-B4B8-17C67827704C (AT) microsoft (DOT) com... Thanks--so we need to fail it back to the active to get the full performance tools, etc.? "Linchi Shea" wrote: That's by design. Linchi "Steve" wrote: We have a sql2005 active/passive win2003 x64 cluster. when the db's are on the active node..we see all of the sql tools available. on the passive node, we don't. is this by design as we did a complete install. any help is appreciated. thx. steve |
#9
| |||
| |||
|
|
Do you have a link to the instructions..and should it be failed over to the other node when doing this? Thanks. Steve "Geoff N. Hiten" wrote: You can do a workstation components only install on the "other" node. The tools installation component is not cluster-aware. There is no problem with adding the tools to additional cluster nodes. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:7AD7D09F-90CA-413F-B4B8-17C67827704C (AT) microsoft (DOT) com... Thanks--so we need to fail it back to the active to get the full performance tools, etc.? "Linchi Shea" wrote: That's by design. Linchi "Steve" wrote: We have a sql2005 active/passive win2003 x64 cluster. when the db's are on the active node..we see all of the sql tools available. on the passive node, we don't. is this by design as we did a complete install. any help is appreciated. thx. steve |
#10
| |||
| |||
|
|
Do you have a link to the instructions..and should it be failed over to the other node when doing this? Thanks. Steve "Geoff N. Hiten" wrote: You can do a workstation components only install on the "other" node. The tools installation component is not cluster-aware. There is no problem with adding the tools to additional cluster nodes. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:7AD7D09F-90CA-413F-B4B8-17C67827704C (AT) microsoft (DOT) com... Thanks--so we need to fail it back to the active to get the full performance tools, etc.? "Linchi Shea" wrote: That's by design. Linchi "Steve" wrote: We have a sql2005 active/passive win2003 x64 cluster. when the db's are on the active node..we see all of the sql tools available. on the passive node, we don't. is this by design as we did a complete install. any help is appreciated. thx. steve |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.