dbTalk Databases Forums  

SQL Server instance naming

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


Discuss SQL Server instance naming in the microsoft.public.sqlserver.clustering forum.



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

Default SQL Server instance naming - 07-21-2008 , 03:35 PM






In a two node cluster (active/active), I have installed two SQL Server 2005
instances in order to use both nodes. The virtual server name of the first
SQL instance owned by the node A is like SQLN1 (default instance) and the
second SQL instance owned by the node B is like SQLN2 with a named instance
SQLN2.
Now I have seen that it is not possible a default instance for the instance
owned by node B with the virtual server name SQLN2, isn't it?
My customer would like to access the first instance with the virtual server
name SQLN1 and to access the second instance with the virtual server name
SQLN2:
is it possible? How?
Many thanks

Reply With Quote
  #2  
Old   
Russ Kaufmann
 
Posts: n/a

Default Re: SQL Server instance naming - 07-21-2008 , 04:02 PM






"Pasquale" <Pasquale (AT) discussions (DOT) microsoft.com> wrote

Quote:
In a two node cluster (active/active), I have installed two SQL Server
2005
instances in order to use both nodes. The virtual server name of the first
SQL instance owned by the node A is like SQLN1 (default instance) and the
second SQL instance owned by the node B is like SQLN2 with a named
instance
SQLN2.
Now I have seen that it is not possible a default instance for the
instance
owned by node B with the virtual server name SQLN2, isn't it?
There can only be one default instance in a SQL server cluster. I recommend,
though, that you don't use a default instance and instead use only named
instances.


--
Russ Kaufmann,
MCSE: Messaging and Security, MCT, MCITP, MCTS and other stuff

ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
July 28-31 in Pittsburgh
Oct 13-16 in New York



Reply With Quote
  #3  
Old   
Russ Kaufmann
 
Posts: n/a

Default Re: SQL Server instance naming - 07-21-2008 , 04:02 PM



"Pasquale" <Pasquale (AT) discussions (DOT) microsoft.com> wrote

Quote:
In a two node cluster (active/active), I have installed two SQL Server
2005
instances in order to use both nodes. The virtual server name of the first
SQL instance owned by the node A is like SQLN1 (default instance) and the
second SQL instance owned by the node B is like SQLN2 with a named
instance
SQLN2.
Now I have seen that it is not possible a default instance for the
instance
owned by node B with the virtual server name SQLN2, isn't it?
There can only be one default instance in a SQL server cluster. I recommend,
though, that you don't use a default instance and instead use only named
instances.


--
Russ Kaufmann,
MCSE: Messaging and Security, MCT, MCITP, MCTS and other stuff

ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
July 28-31 in Pittsburgh
Oct 13-16 in New York



Reply With Quote
  #4  
Old   
Russ Kaufmann
 
Posts: n/a

Default Re: SQL Server instance naming - 07-21-2008 , 04:02 PM



"Pasquale" <Pasquale (AT) discussions (DOT) microsoft.com> wrote

Quote:
In a two node cluster (active/active), I have installed two SQL Server
2005
instances in order to use both nodes. The virtual server name of the first
SQL instance owned by the node A is like SQLN1 (default instance) and the
second SQL instance owned by the node B is like SQLN2 with a named
instance
SQLN2.
Now I have seen that it is not possible a default instance for the
instance
owned by node B with the virtual server name SQLN2, isn't it?
There can only be one default instance in a SQL server cluster. I recommend,
though, that you don't use a default instance and instead use only named
instances.


--
Russ Kaufmann,
MCSE: Messaging and Security, MCT, MCITP, MCTS and other stuff

ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
July 28-31 in Pittsburgh
Oct 13-16 in New York



Reply With Quote
  #5  
Old   
Russ Kaufmann
 
Posts: n/a

Default Re: SQL Server instance naming - 07-21-2008 , 04:02 PM



"Pasquale" <Pasquale (AT) discussions (DOT) microsoft.com> wrote

Quote:
In a two node cluster (active/active), I have installed two SQL Server
2005
instances in order to use both nodes. The virtual server name of the first
SQL instance owned by the node A is like SQLN1 (default instance) and the
second SQL instance owned by the node B is like SQLN2 with a named
instance
SQLN2.
Now I have seen that it is not possible a default instance for the
instance
owned by node B with the virtual server name SQLN2, isn't it?
There can only be one default instance in a SQL server cluster. I recommend,
though, that you don't use a default instance and instead use only named
instances.


--
Russ Kaufmann,
MCSE: Messaging and Security, MCT, MCITP, MCTS and other stuff

ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
July 28-31 in Pittsburgh
Oct 13-16 in New York



Reply With Quote
  #6  
Old   
Russ Kaufmann
 
Posts: n/a

Default Re: SQL Server instance naming - 07-21-2008 , 04:02 PM



"Pasquale" <Pasquale (AT) discussions (DOT) microsoft.com> wrote

Quote:
In a two node cluster (active/active), I have installed two SQL Server
2005
instances in order to use both nodes. The virtual server name of the first
SQL instance owned by the node A is like SQLN1 (default instance) and the
second SQL instance owned by the node B is like SQLN2 with a named
instance
SQLN2.
Now I have seen that it is not possible a default instance for the
instance
owned by node B with the virtual server name SQLN2, isn't it?
There can only be one default instance in a SQL server cluster. I recommend,
though, that you don't use a default instance and instead use only named
instances.


--
Russ Kaufmann,
MCSE: Messaging and Security, MCT, MCITP, MCTS and other stuff

ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
July 28-31 in Pittsburgh
Oct 13-16 in New York



Reply With Quote
  #7  
Old   
Russ Kaufmann
 
Posts: n/a

Default Re: SQL Server instance naming - 07-21-2008 , 04:02 PM



"Pasquale" <Pasquale (AT) discussions (DOT) microsoft.com> wrote

Quote:
In a two node cluster (active/active), I have installed two SQL Server
2005
instances in order to use both nodes. The virtual server name of the first
SQL instance owned by the node A is like SQLN1 (default instance) and the
second SQL instance owned by the node B is like SQLN2 with a named
instance
SQLN2.
Now I have seen that it is not possible a default instance for the
instance
owned by node B with the virtual server name SQLN2, isn't it?
There can only be one default instance in a SQL server cluster. I recommend,
though, that you don't use a default instance and instead use only named
instances.


--
Russ Kaufmann,
MCSE: Messaging and Security, MCT, MCITP, MCTS and other stuff

ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
July 28-31 in Pittsburgh
Oct 13-16 in New York



Reply With Quote
  #8  
Old   
Russ Kaufmann
 
Posts: n/a

Default Re: SQL Server instance naming - 07-21-2008 , 04:02 PM



"Pasquale" <Pasquale (AT) discussions (DOT) microsoft.com> wrote

Quote:
In a two node cluster (active/active), I have installed two SQL Server
2005
instances in order to use both nodes. The virtual server name of the first
SQL instance owned by the node A is like SQLN1 (default instance) and the
second SQL instance owned by the node B is like SQLN2 with a named
instance
SQLN2.
Now I have seen that it is not possible a default instance for the
instance
owned by node B with the virtual server name SQLN2, isn't it?
There can only be one default instance in a SQL server cluster. I recommend,
though, that you don't use a default instance and instead use only named
instances.


--
Russ Kaufmann,
MCSE: Messaging and Security, MCT, MCITP, MCTS and other stuff

ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
July 28-31 in Pittsburgh
Oct 13-16 in New York



Reply With Quote
  #9  
Old   
Russ Kaufmann
 
Posts: n/a

Default Re: SQL Server instance naming - 07-21-2008 , 04:02 PM



"Pasquale" <Pasquale (AT) discussions (DOT) microsoft.com> wrote

Quote:
In a two node cluster (active/active), I have installed two SQL Server
2005
instances in order to use both nodes. The virtual server name of the first
SQL instance owned by the node A is like SQLN1 (default instance) and the
second SQL instance owned by the node B is like SQLN2 with a named
instance
SQLN2.
Now I have seen that it is not possible a default instance for the
instance
owned by node B with the virtual server name SQLN2, isn't it?
There can only be one default instance in a SQL server cluster. I recommend,
though, that you don't use a default instance and instead use only named
instances.


--
Russ Kaufmann,
MCSE: Messaging and Security, MCT, MCITP, MCTS and other stuff

ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
July 28-31 in Pittsburgh
Oct 13-16 in New York



Reply With Quote
  #10  
Old   
Russ Kaufmann
 
Posts: n/a

Default Re: SQL Server instance naming - 07-21-2008 , 04:02 PM



"Pasquale" <Pasquale (AT) discussions (DOT) microsoft.com> wrote

Quote:
In a two node cluster (active/active), I have installed two SQL Server
2005
instances in order to use both nodes. The virtual server name of the first
SQL instance owned by the node A is like SQLN1 (default instance) and the
second SQL instance owned by the node B is like SQLN2 with a named
instance
SQLN2.
Now I have seen that it is not possible a default instance for the
instance
owned by node B with the virtual server name SQLN2, isn't it?
There can only be one default instance in a SQL server cluster. I recommend,
though, that you don't use a default instance and instead use only named
instances.


--
Russ Kaufmann,
MCSE: Messaging and Security, MCT, MCITP, MCTS and other stuff

ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
July 28-31 in Pittsburgh
Oct 13-16 in New York



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.