安裝常見問題

Error 1
=====

執行

setup.exe /Q /action=install /features=SSMS

沒有成功安裝

HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\100\Bootstrap

C:\Users\<USER>\AppData\Local\Temp\SqlSetup.log

08/02/2013 16:39:41.323 Setup closed with exit code: 0x80070003

inconsistent or corrupt Windows Update databases

在新增移除把有關 MSSQL Remove 它即可

Error 2
======

Could not load file or assembly 'Microsoft.SqlServer.Sqm, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The module was expected to contain an assembly manifest. (SqlMgmt)

把 C:\Program Files\Microsoft SQL Server\100\Shared 內所有 file Copy 到

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE
 

Failover cluster 安裝常見問題

Rule "M$ MSCS cluster verification errors" - KB953748

Setup.exe /SkipRules=Cluster_VerifyForErrors /Action=InstallFailoverCluster

Setup.exe /SkipRules=Cluster_VerifyForErrors /Action=AddNode

rule"cluster shared disk available check" failed

The shared disks are known as a resource group. This resource group is owned by a single node in the cluster.

The failover clustering installation will fail if any one of the following conditions is true:
The disk resource is not owned by the local node.
The disk resource is a cluster quorum disk.
The disk resource has non-disk dependencies.
The disk resource has dependencies outside of the same resource group.
The disk resource has dependents outside of the same resource group.

Trun on amintenance for this disk
==================================

chkdsk

When maintenance mode is on, the disk maintenance tool can finish running without triggering a failover.
(specified resource in a mode that will disable health checking.)