dbTalk Databases Forums  

Move SQL 2005 instance to new node

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


Discuss Move SQL 2005 instance to new node in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Robert
 
Posts: n/a

Default Move SQL 2005 instance to new node - 03-05-2009 , 02:54 PM






Hi.
Can you help me with moving from old hardware to new. I have 2 node A/A SQL
cluster.
node 1 - win 2003 x64 SP2 Ent. Ed., SQL 2005 SP2 Standard, default instance
node 2 - win 2003 x64 SP2 Ent. Ed, SQL 2005 SP2 Standard, named instance
node 3 - win 2003 x64 SP2 Ent. Ed, SQL 2005 SP2 Standard
node 4 - win 2003 x64 SP2 Ent. Ed, SQL 2005 SP2 Standard
I want to replace old hardware so I joined third node and fourth to existing
cluster. I have installed workstation components. Then I have succesfully
changed virtual server and removed first instance from node one. After
reboot of node 1 I went to change virtual server and start to add it to
fresh new node 3, but I cant get past remote account security. I'm using
domain admin account or account under wich is running sql server service or
cluster service - I'm stuck and unable to continue with setup.

Can you help me, please.

Best regards, Robert


Reply With Quote
  #2  
Old   
Mohit K. Gupta
 
Posts: n/a

Default RE: Move SQL 2005 instance to new node - 03-07-2009 , 10:12 PM






What error message do you get Rob?

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Robert" wrote:

Quote:
Hi.
Can you help me with moving from old hardware to new. I have 2 node A/A SQL
cluster.
node 1 - win 2003 x64 SP2 Ent. Ed., SQL 2005 SP2 Standard, default instance
node 2 - win 2003 x64 SP2 Ent. Ed, SQL 2005 SP2 Standard, named instance
node 3 - win 2003 x64 SP2 Ent. Ed, SQL 2005 SP2 Standard
node 4 - win 2003 x64 SP2 Ent. Ed, SQL 2005 SP2 Standard
I want to replace old hardware so I joined third node and fourth to existing
cluster. I have installed workstation components. Then I have succesfully
changed virtual server and removed first instance from node one. After
reboot of node 1 I went to change virtual server and start to add it to
fresh new node 3, but I cant get past remote account security. I'm using
domain admin account or account under wich is running sql server service or
cluster service - I'm stuck and unable to continue with setup.

Can you help me, please.

Best regards, Robert


Reply With Quote
  #3  
Old   
Robert
 
Posts: n/a

Default RE: Move SQL 2005 instance to new node - 03-09-2009 , 02:42 AM



This is my error
---------
SQL Server 2005 Setup requires administrator permission on every cluster
node. To continue, update permission for the account currenty running Setup,
or log in with an account that has administrator permissions on every cluster
node, and then run SQL Server Setup again.
----------

I'm using admin account and I can log in on every node with this account.
But setup wont continue.

Do you have any suggestion?

Regards, Robert

"Mohit K. Gupta" wrote:

Quote:
What error message do you get Rob?

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Robert" wrote:

Hi.
Can you help me with moving from old hardware to new. I have 2 node A/A SQL
cluster.
node 1 - win 2003 x64 SP2 Ent. Ed., SQL 2005 SP2 Standard, default instance
node 2 - win 2003 x64 SP2 Ent. Ed, SQL 2005 SP2 Standard, named instance
node 3 - win 2003 x64 SP2 Ent. Ed, SQL 2005 SP2 Standard
node 4 - win 2003 x64 SP2 Ent. Ed, SQL 2005 SP2 Standard
I want to replace old hardware so I joined third node and fourth to existing
cluster. I have installed workstation components. Then I have succesfully
changed virtual server and removed first instance from node one. After
reboot of node 1 I went to change virtual server and start to add it to
fresh new node 3, but I cant get past remote account security. I'm using
domain admin account or account under wich is running sql server service or
cluster service - I'm stuck and unable to continue with setup.

Can you help me, please.

Best regards, Robert


Reply With Quote
  #4  
Old   
Mohit K. Gupta
 
Posts: n/a

Default RE: Move SQL 2005 instance to new node - 03-09-2009 , 12:09 PM



Hmm that is a strange error; did you try using the SA account when doing the
setup?

I am confused about the setups? WHen you say you changed the virtual
server? What did you mean?

You shouldn't have to remove any instances to add new new node; if you go to
add/remove programs to manage the SQL Install you should be able to add any
available node to the SQL Instance you altered.

Ref: http://msdn.microsoft.com/en-us/libr...5(SQL.90).aspx
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Robert" wrote:

Quote:
This is my error
---------
SQL Server 2005 Setup requires administrator permission on every cluster
node. To continue, update permission for the account currenty running Setup,
or log in with an account that has administrator permissions on every cluster
node, and then run SQL Server Setup again.
----------

I'm using admin account and I can log in on every node with this account.
But setup wont continue.

Do you have any suggestion?

Regards, Robert

"Mohit K. Gupta" wrote:

What error message do you get Rob?

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Robert" wrote:

Hi.
Can you help me with moving from old hardware to new. I have 2 node A/A SQL
cluster.
node 1 - win 2003 x64 SP2 Ent. Ed., SQL 2005 SP2 Standard, default instance
node 2 - win 2003 x64 SP2 Ent. Ed, SQL 2005 SP2 Standard, named instance
node 3 - win 2003 x64 SP2 Ent. Ed, SQL 2005 SP2 Standard
node 4 - win 2003 x64 SP2 Ent. Ed, SQL 2005 SP2 Standard
I want to replace old hardware so I joined third node and fourth to existing
cluster. I have installed workstation components. Then I have succesfully
changed virtual server and removed first instance from node one. After
reboot of node 1 I went to change virtual server and start to add it to
fresh new node 3, but I cant get past remote account security. I'm using
domain admin account or account under wich is running sql server service or
cluster service - I'm stuck and unable to continue with setup.

Can you help me, please.

Best regards, Robert


Reply With Quote
Reply




Thread Tools
Display Modes

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.