 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / July 2008SQL 2000 Clustering on Win2K3
Two node cluster (Active/Passive) (SQL2000/WIN2K3). What should the services (sqlservice and sqlagent) be set to (Automatic or Manual) on the Active node? What should the services (sqlservice and sqlagent) be set to (Automatic or Manual) on the Passive node? Should these ever need to be changed for maintenance or rebooting a node? They should all be Manual since they are controlled by the cluster service. But you should NOT set them as the install will set them properly. You don't need to change them. Linchi > Two node cluster (Active/Passive) (SQL2000/WIN2K3). > [quoted text clipped - 5 lines] > > Should these ever need to be changed for maintenance or rebooting a node? That is what I thought..... thanks. > They should all be Manual since they are controlled by the cluster service. > But you should NOT set them as the install will set them properly. You don't [quoted text clipped - 11 lines] > > > > Should these ever need to be changed for maintenance or rebooting a node? Do you know if this is documented anyplace? I am getting conflicting information from another SQL MVP and I would like to verify that this is correct? > They should all be Manual since they are controlled by the cluster service. > But you should NOT set them as the install will set them properly. You don't [quoted text clipped - 11 lines] > > > > Should these ever need to be changed for maintenance or rebooting a node? This has been resolved...... Linchi you are correct. The sql server and sql agent services should not be touched/changed. When sql server 2000 (and maybe 2005) is installed it will default these services to start manually and the cluster services will start the necessary services when the server is rebooted. Thanks for everyone's help. > Do you know if this is documented anyplace? > [quoted text clipped - 16 lines] > > > > > > Should these ever need to be changed for maintenance or rebooting a node? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.