The instance name that I was describing is Admin guide P.197-198. -New SQL Server Instance -Instance Startup Name dialog box
Moreover, the alias that I described is Admin guide P.196. -New SQL Server Instance - Node Alias Selection dialog box
The phenomenon will occur if the physical node name is input.
Because service starts by Node1 when the SQL Server service starts.
When starting with node2, this starts service with node1.
Therefore, if Server Manegement console is started, it becomes red status.
Following Event log is sure to be displayed.
Event Type: Information Event Source: EventLog Event Category: None Event ID: 6011 Date: 11/18/2008 Time: 4:09:35 PM User: N/A Computer: node2 Description: The NetBIOS name and DNS host name of this machine have been changed from node2 to node1.
Thanks for your quick response. I did use the SQL 2005 module to create the resource group. I am still a little confuse. Did you mean the "instance name" dialog box in admin guide page 199? This is a required information from 5.3SP1, and I fill in the SQL instance name as server name of node one(default instance name is server name). Is it correct? Or what instance name should I input?
Thanks a lot. I think I may know what the problem is. The root cause should be that there are different instance name between two nodes. Do you know how to change instance name in SQL?
Finally, I found the root cause of my problem. I install two SQL with default instance name, and that will be the server name. That makes two servers with different instance name. I found a way to make them identically.
1.select @@servername 2. sp_dropserver 'old_name' GO sp_addserver 'alias_server_name', 'local' GO 3. --restart services..... 4.select @@servername 5.change the script content you taught.
After these, I can failover SQL resource group with correct service icon. Thanks for your fully help.
yito1
262 Posts
0
November 17th, 2008 23:00
The instance name that I was describing is Admin guide P.197-198.
-New SQL Server Instance -Instance Startup Name dialog box
Moreover, the alias that I described is Admin guide P.196.
-New SQL Server Instance - Node Alias Selection dialog box
The phenomenon will occur if the physical node name is input.
Because service starts by Node1 when the SQL Server service starts.
When starting with node2, this starts service with node1.
Therefore, if Server Manegement console is started, it becomes red status.
Following Event log is sure to be displayed.
Event Type: Information
Event Source: EventLog
Event Category: None
Event ID: 6011
Date: 11/18/2008
Time: 4:09:35 PM
User: N/A
Computer: node2
Description:
The NetBIOS name and DNS host name of this machine have been changed from node2 to node1.
yito1
262 Posts
0
November 17th, 2008 20:00
Did you use and compose SQL2005 Module?
Did you input the alias to module wizard's Instance name?
This phenomenon occurs if the alias is not input to Instance name when composed of Module.
Correct the following if you correct it.
Resource group--settings tab--Startup Sequence--Startup scan Script
$errorCode = &ft::SetActiveComputerName("alias"); <-----
Fill in the alias that you made in the part of Alias.
power3
31 Posts
0
November 17th, 2008 22:00
I did use the SQL 2005 module to create the resource group.
I am still a little confuse.
Did you mean the "instance name" dialog box in admin guide page 199?
This is a required information from 5.3SP1, and I fill in the SQL instance name as server name of node one(default instance name is server name).
Is it correct? Or what instance name should I input?
power3
31 Posts
0
November 18th, 2008 01:00
I think I may know what the problem is.
The root cause should be that there are different instance name between two nodes.
Do you know how to change instance name in SQL?
yito1
262 Posts
0
November 18th, 2008 02:00
The instance of SQL is default.
The setup of your SQLServer is correct.
It only has to make alias with AutoStart and to input the alias to "Instance Startup Name dialog box".
Anyway, test the method taught by me.
power3
31 Posts
0
November 23rd, 2008 20:00
I install two SQL with default instance name, and that will be the server name.
That makes two servers with different instance name.
I found a way to make them identically.
1.select @@servername
2.
sp_dropserver 'old_name'
GO
sp_addserver 'alias_server_name', 'local'
GO
3. --restart services.....
4.select @@servername
5.change the script content you taught.
After these, I can failover SQL resource group with correct service icon.
Thanks for your fully help.