Tried to install SQL 2008 R2 on Windows 2016 = fails, cluster verification fails
SQL 2014 was a-okay
Error to install SQL Server 2008 on Windows 2012 – Marcelo's Spaces
https://marcelodba.wordpress.com/2014/08/17/error-to-install-sql-server-2008-on-windows-2012/
SQL Server Newbie
Tuesday, April 17, 2018
Tuesday, August 15, 2017
SQL Server 2008 Add Cluster Node workarounds
I haven't installed/added SQL 2008 cluster node for so long, but just today I had to use 2 workarounds just to get it working. Whew
First workaround, Cluster Validation was good but SQL installer still complained
https://support.microsoft.com/en-ca/help/953748/error-message-when-you-install-sql-server-2008-on-a-windows-server-200
Setup /SkipRules=Cluster_VerifyForErrors /Action=AddNode
Second Workaround is actuall a MS Bug, where I had to comment out the pre-saved license key in the installer folder and entered it manually instead
https://digitaljive.wordpress.com/2009/06/22/%E2%80%9Cthe-current-sku-is-invalid%E2%80%9D-when-adding-second-node-to-sql-2008-cluster/
First workaround, Cluster Validation was good but SQL installer still complained
https://support.microsoft.com/en-ca/help/953748/error-message-when-you-install-sql-server-2008-on-a-windows-server-200
Setup /SkipRules=Cluster_VerifyForErrors /Action=AddNode
Second Workaround is actuall a MS Bug, where I had to comment out the pre-saved license key in the installer folder and entered it manually instead
https://digitaljive.wordpress.com/2009/06/22/%E2%80%9Cthe-current-sku-is-invalid%E2%80%9D-when-adding-second-node-to-sql-2008-cluster/
Thursday, February 16, 2017
Wednesday, November 26, 2014
Set DEADLOCK_PRIORITY to update Database in Single_User mode
If you need to access a Database in Single_user mode, to either take it offline or change to MULTI_USER, change the DEADLOCK_PRIORITY so your process does not get picked as deadlock victirm.
SET DEADLOCK_PRIORITY HIGH--KILL 58 -- kill the session using the databaseALTER DATABASE [DB_NAME] SET OFFLINE WITH ROLLBACK IMMEDIATE--ALTER DATABASE [DB_NAME] SET MULTI_USER WITH ROLLBACK IMMEDIATESET DEADLOCK_PRIORITY NORMAL
Wednesday, August 13, 2014
Unable to manage cluster using failover cluster manager = Start the Server service
I had trouble connecting to my cluster in Failover Cluster Manager today and Google found me this
Easy resolution
Open services console and start the Server service.
Unable to manage cluster using failover cluster manager. Error Received: "Connection to the cluster is not allowed since you are not an administrator on the clu...
Easy resolution
Open services console and start the Server service.
Unable to manage cluster using failover cluster manager. Error Received: "Connection to the cluster is not allowed since you are not an administrator on the clu...
Subscribe to:
Posts (Atom)