In my previous article “Building a SQL 2012 Always-On Cluster – Part 1” we examined the deployment of a SQL Server 2012 by deploying the first cluster node. The idea was to explore both the process of SQL Server 2012 clustering for a failover cluster, but also to see how different the installation process might [...]
READ MORE »
Over the past few weeks I have been involved in a major SQL cluster roll-out and as such got my hands dirty with getting SQL 2008 R2 clusters built. With the release of SQL Server 2012 I decided I might just was well contrast the two builds for the fun of it. As it turns [...]
READ MORE »When using any SQL Server 2008 or later version there is a possibility of getting the following error: Element not found. (Exception from HRESULT: 0×80070490) – SQL Server 2008 R2 This appears right after feature selection (with the installer failing – or the installer hangs). There are no specific logs that provide adequate information as [...]
READ MORE »
This morning when applying SQL Server 2008 R2 SP1 i came across the following error during the installation “Check File In Use” page: The ‘WmiPrvSE.exe’ process is not controlled by the update wizard. You have to manually stop this process to avoid a computer restart. There where two theads being identified by the SQL SP1 [...]
READ MORE »
One of the primary requirements for a proper Microsoft SQL Server environment is MSDTC (Microsoft Distributed Transaction Coordinator). When installing a SQL Server clustered environment it is required to add this clustered resource before installing you SQL Server instances. To procedure to do this: To start the Failover Cluster Management program, click Start, Programs, Administrative [...]
READ MORE »
I recently was required to set up a two-way SQL Server 2008 failover cluster for ILM 2007. During the setup process I did run into an issue of two with the installation and thought it would be a good idea to share – it might help if you run into the same issue. Note that [...]
READ MORE »EvoLve theme by Theme4Press • Powered by WordPress Puttyq.com
trying to address a crisis in identity
