When using any SQL Server 2008 or later version there is a possibility of getting the following error: Element not found. (Exception from HRESULT: 0x80070490) – 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 […]
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 […]
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 Tools, and then click Failover Cluster Management. […]
