The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob - Blog

 

Home

No Ads ever, except search!
Thursday, November 21, 2024 Login
Public

Blog posts for the month of August,2016.
Always On Across Geographic Data Centers, Installation, notes 18/12/2016 4:10:02 PM

SQL 2012 multi-subnet cluster install 

Installing sql server 2012, clustered on windows 2012 with always-on across geographic data centers, these are my recent notes on setting this up:

Always challenging, and I've configured always-on across geographic data centers to single nodes in another data center, but this time we are installing SQL across geographic data centers where SQL Server itself is clustered with-in each data center.  This is to allow for local high-availability with-in each data center.

Here were some recent gotchas i ran into.

Make sure the service account is a full local admin, and has the rights to install .net 3.5.  Installation began and failed as .net 3.5 was not a feature.  It's pretty easy to add this feature on windows 2012, but the service account did not have access to the source media, so ensure your Windows administrator has added this feature.  The actual error doesn't say ".net 3.5 is missing, you get this cryptic message:"

The following error has occurred:

Error while enabling Windows feature : NetFx3, Error Code : -2146498298 , Please try enabling Windows feature : NetFx3 from Windows management tools and then run setup again. For more information on how to enable Windows features , see http://go.microsoft.com/fwlink/?linkid=227143

After that, ran the install again, and got a new error:

An error occurred creating the configuration section handler for userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings: Could not load file or assembly 'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. (C:\Users\{login removed}\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\11.0.0.0\user.config line 5)

This error it turns out is caused by the previous bombed install, and is documented here:
https://blogs.msdn.microsoft.com/smondal/2013/07/26/an-error-occurred-creating-the-configuration-section-handler-for-usersettingsmicrosoft-sqlserver-configuration-landingpage-properties-settings/

The fix is basically to delete the temporary and/or cached data, i used the following from a command prompt:   rd /s /q %localappdata%\Microsoft_Corporation

Next issue is the service account didn't have permissions to create the computer object in active directory.  This of course bombs the install, with no "retry", it just throws an error, than you are screwed, even if your active directory administrator adds the correct permission, it won't recover, install fails.

The error messages are:

Cluster network name resource 'SQL Network Name ({virtual name removed})' failed to create its associated computer object in domain '{this will be the AD Domain}' during: Resource online.

The cluster resource 'SQL Server' could not be brought online due to an error bringing the dependency resource 'SQL Network Name ({virtual name removed})' online.  Refer to the Cluster Events in the Failover Cluster Manager for more information.

Now you have to uninstall, there is an option to "remove a node from a cluster", and that is the option you must choose.  Of course this took me a bit to find, because for whatever reason the windows 2012 server do not show the "Remove Programs" in control panel.  The way around this is to go just run appwiz.cpl.

Now that you get the "remove a node from a cluster done", it won't prompt you that a reboot is required, but you will find when you run setup.exe again, it will fail because of a "Pending Restart", so reboot.  After reboot, your shared disk will now be on the other "node", so don't forget to go over there and move it back, i usually reboot the other node to force it and the quourum back, but there are powershell scripts you can use to move them as well.

Now that you got the clean reboot and your shared disk back, and you've removed your several failed attempts, clean up the disk, you may still see a directory created by the install, i usually rename it.

Now do the install again, and all will be good. 

Repeat on the other nodes in the other data center,


Blog Home