 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Clustering / March 2005Can I create another one virtual SQL Server at the same cluster
Hi, I already have one virtual SQL server in the cluster, it's owned by only one node. Now I added another node into the cluster, and we don't want this node to be a passive node, and don't want go to multi-instance . So, the question is if I can create another one virtual SQL server on the new node, give it new SQL IP, SQL Network Name, SQL Server... Please advise. Thanks you so much. Peter You sure can, you can have 16 instances per cluster when running on Windows Server 2003. Cheers, Rod MVP - Windows Server - Clustering http://www.nw-america.com - Clustering http://msmvps.com/clustering - Blog > Hi, > [quoted text clipped - 12 lines] > > Peter Thank you so much, Rod !! So, I can do the same steps on the new node to create the new virtual SQL as what I did on the older node before. Thanks, Peter > Hi, > [quoted text clipped - 10 lines] > > Peter Yes, only thing to watch out is that you can only have 1 default instance, the rest are named. Or you can have all named instances, either way 16 is the limit. Cheers, Rod MVP - Windows Server - Clustering http://www.nw-america.com - Clustering http://msmvps.com/clustering - Blog > Thank you so much, Rod !! > So, I can do the same steps on the new node to create the new virtual SQL [quoted text clipped - 21 lines] >> >> Peter That's mean I had to uncheck the default box and enter the instance name in the [Instance Name] step. So, new virtual SQL name will be "preview default instance name\instance name" And I can still use the default TCP port for the new virtual SQL instance. Thank you, Rod. Peter > Yes, only thing to watch out is that you can only have 1 default instance, > the rest are named. Or you can have all named instances, either way 16 is [quoted text clipped - 33 lines] > >> > >> Peter Correct. Remember its a new name and IP so the ports will rename the same. Cheers, Rod MVP - Windows Server - Clustering http://www.nw-america.com - Clustering http://msmvps.com/clustering - Blog > That's mean I had to uncheck the default box and enter the instance name > in [quoted text clipped - 51 lines] >> >> >> >> Peter I was confused with the multi-instance, I was think I can go ahead to create a another one virtual SQL server, just put these virtual SQL servers under the same cluster. So, I was thinking I enter a different viirtual SQL server name at the first step, and still check default box in the [instance name} step. Then we will have kind of virtual SQL server naming, Node1 , Node 2, ...Node 16 As I assign a new IP with the new virtual SQL server, I should be able to use the default SQL tcp port : 1433. I appreciate yoou got me clear. Thank you so much. Peter > Correct. Remember its a new name and IP so the ports will rename the same. > [quoted text clipped - 61 lines] > >> >> > >> >> Peter |
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.