 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Clustering / July 2008SQL Server instance naming
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 > In a two node cluster (active/active), I have installed two SQL Server > 2005 [quoted text clipped - 6 lines] > 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.  SignatureRuss 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 The second instance on the cluster has to have a different name. One trick you can use is to tell the names instance to listen on port 1433 and stop the SQL Broker. This "should" allow the users to connect without putting in a name. You'll need to make sure that both instances on listening only on there specific IP Addresses otherwise you'll get port conflicts if the instances end up on the same node at any point. Another trick you can use is to use the Client Network Utility (c:\windows\system32\cliconfg.exe) and setup an alias so that SQLN2 actually points to SQLn2\InstanceName. This will need to be done on each users PC who needs to connect to the SQL Server. It is recommended that you simply connect to the instance name. Denny >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 [quoted text clipped - 8 lines] >is it possible? How? >Many thanks In according with your first trick, I have to use the specific IP addresses instead of the virtual server name (without or with the instance name) for the client connectivity, isn't it? Thanks > The second instance on the cluster has to have a different name. > [quoted text clipped - 26 lines] > >is it possible? How? > >Many thanks No, you would be able to connect to the virtual server name of the second instance. Don't forget that when you install SQL in a cluster each instance get's it's own hostname to go along with it's own IP address. >In according with your first trick, I have to use the specific IP addresses >instead of the virtual server name (without or with the instance name) for [quoted text clipped - 31 lines] >> >is it possible? How? >> >Many thanks So I can connect to the second instance by using only the related virtual server name without the name of this instance, isn't it? Thanks > No, you would be able to connect to the virtual server name of the > second instance. Don't forget that when you install SQL in a cluster [quoted text clipped - 36 lines] > >> >is it possible? How? > >> >Many thanks Correct. Denny >So I can connect to the second instance by using only the related >virtual server name without the name of this instance, isn't it? [quoted text clipped - 40 lines] >> >> >is it possible? How? >> >> >Many thanks What you can do is come up with a new, abstract name for the SQL instance like SQLI2or SQLZ2. YOu then create a DNS record pointing that name to the IP address of the virtual server, thus substituting DNS for the SQL Browser service. I generally do this at system build time so I cna move SQL servers underneath the DNS names without the client systems being any the wiser. SignatureGeoff N. Hiten Principal SQL Infrastructure Consultant Microsoft SQL Server MVP > In a two node cluster (active/active), I have installed two SQL Server > 2005 [quoted text clipped - 12 lines] > is it possible? How? > Many thanks |
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
|
©2008 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.