August 5, 2014 at 12:55 am
Hi,
Please give the cluster Installation Differences from 2005 to 2008/R2 for a SQLDBA.
& What are the changes.
Thanks in advance.
August 5, 2014 at 3:51 am
jamessdba (8/5/2014)
Hi,Please give the cluster Installation Differences from 2005 to 2008/R2 for a SQLDBA.
& What are the changes.
Thanks in advance.
Cluster installation has changed radically. SQL server cluster installations are now completed in multiple parts. You run the install wizard for a new clustered instance, you then run the add node wizard for each node you wish to join to the new clustered instance.
This is done as many times as the number of clustered instances you require.
Have you ever completed a clustered install of sql 2005?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 5, 2014 at 4:59 am
Hi,
Could you please list the few difference points
August 5, 2014 at 8:36 am
the most notable are
sql server 2008 now supports service based SIDs for clustered installations when installing on Windows 2008 and above, instead of the old AD based group config used by SQL 2005
sql server 2008 installer now runs the node join operations as separate actions. SQL 2005 used to install to all selected nodes simultaneously and was not without its problems.
SQL Server 2008 installer no longer installs builtin\admins as sysadmin users in the sql instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2014 at 7:30 am
Things to add to Perry's list...
You no longer need to specify the ADMINPASSWORD parameter. This is because each node is processed independently.
MSDTC no longer needs to be clustered or even active during the SQL install, although you may still need MSDTC for your applications.
Everything that Perry and I have listed also applies to SQL2012 / SQL 2014 when compared to SQL2005 for cluster install.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 6, 2014 at 9:07 am
EdVassie (8/6/2014)
MSDTC no longer needs to be clustered or even active during the SQL install
Although if you don't have one clustered the installer stills bitches and moans and produces a little warning triangle on the setup support rules status detail
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply