dbTalk Databases Forums  

Add new nodes to existing SQL instances.

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clustering Add new nodes to existing SQL instances.

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Add new nodes to existing SQL instances. in the microsoft.public.sqlserver.clustering forum.



Reply
Page 2 of 2 < 1 2
 
Thread Tools Display Modes
  #11  
Old   
Linchi Shea
 
Posts: n/a

Default RE: Add new nodes to existing SQL instances. - 09-16-2008 , 09:07 AM





Assume that a new node is already added to the cluster at the OS level, to
add that node for SQL2005, you just need to run SQL Setup and select the
cluster maintenance option, and follow the instructions. The steps are
documented in the Books Online
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/30e06a7d-75e9-44e2-bca3-b3b0c4a33f61.htm).

You do not use the sa SQL login for this. You'll need to use a domain
account that is local admin on all nodes.

Linchi

"Chen" wrote:

Quote:
Hi All,
Currently, our Prod databases located in the 3 SQL instances on the 2
physical nodes cluster servers. I need add three new (powerful) nodes to
existing 3 instances. These instances installed SQL Server 2005 Enterprise
Edition with Post SP2 (3161) version. For the security purpose, I change the
sa password regularly.
Now, I have two following questions:
1) If I use sa account to add those 3 new nodes, will be any problem occur
since sa password changed?
2) What kind procedures (processes) I can follow to add those new nodes?
Regards!
Chen

Reply With Quote
Reply
Page 2 of 2 < 1 2

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top