September 12, 2013 at 3:34 am
Hi,
I am working with a cluster with 2 nodes, active-active.
The nodes have several instances and in total 3 different SQL server versions (SQL2005, SQL2008 and SQL2008R2); not an ideal situations but when I setup the cluster I needed a SQL2005 for one specific applications. Now I want to remove versions SQL2005 and SQL2008 so that I can install an extra instance 2008R2 and the new 2012 and that the end result is only 2 different SQL versions.
The SQL Server Browser that is used is the one that is installed with 2005.
What is the best way to install and configure the browser for 2008R2 and remove the browser that runs now on 2005?
Can this be done while the cluster is working?
When I failover all instances to one node, can I perform the install and uninstall on the passive node, fail over again and repeat everything for the other node? Or is it better to do this past working hours?
I suppose I cannot have 2 browsers working at the same time since they would use the same port to listen.
Any advise is welcome. Thanks.
Vera
September 12, 2013 at 11:12 am
One browser service of any version of SQL is suffice to allow incoming connection to multiple instances that listen on the default port 1434, if you're going to remove SQL Server 2005/2008 then the browser service of that version will also get removed, you can disable the additional browser service if any and have one running on each node all the time.
Regards,
September 19, 2013 at 12:09 am
I was confused by the location of the sqlbrowser.exe.
I had expected that the location that comes with 2008R2 would be ":\Program Files\Microsoft SQL Server\100\Shared\sqlbrowser.exe".
In reality it's in C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe"
see this link for mor information:
Vera
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply