SQL Server 2008 R2 系统配置检查器的检查参数和妨碍性问题的解决办法
在安装SQL Server的时候经常会遇到安装失败，这是很伤脑筋的事情，花费很多时间和精力也不一定能够解决。 针对于规则检查导致的安
在安装SQL Server的时候经常会遇到安装失败，这是很伤脑筋的事情，花费很多时间和精力也不一定能够解决。 针对于规则检查导致的安装错误，如果有一份列表能够说明规则以及解决办法将会给我们提高极大的帮助。微软其实已经帮助我们提供了类似的文档。
安装操作完成之前，SQL Server 安装程序会验证您的计算机配置。下表描述了系统配置检查器的检查参数和妨碍性问题的解决办法。
检查项
说明
用户操作
AclPermissionsFacet
检查 SQL Server 注册表项是否一致
SQL Server 注册表项必须保持一致，才能支持 SQL Server 安装或升级
MediaPathLength
检查 SQL Server 安装介质是否过长。
确保 SQL Server 安装介质不过长
OsVersionCheck
检查计算机是否满足最低操作系统版本要求。
操作系统必须满足此产品的最低要求。有关详细信息，请参阅 Hardware and Software Requirements for Installing SQL Server 2008 R2（安装 SQL Server 2008 R2 的硬件和软件要求）。
RebootRequiredCheck
检查是否需要挂起计算机重新启动。挂起重新启动会导致安装程序失败。
需要计算机重新启动。安装 SQL Server 之前，必须重新启动计算机。
ThreadHasAdminPrivilegeCheck
检查运行 SQL Server 安装程序的帐户是否具有计算机的管理权限。
请确保运行 SQL Server 安装程序的帐户具有计算机的管理权限。
WmiServiceStateCheck
检查是否已在计算机上启动并正在运行 WMI 服务。
必须正在运行 WMI 服务。
Bids2005InstalledCheck
检查是否存在 BI Development Studio 的先前版本。
在安装 SQL Server 2008 R2 之前，必须先升级至 Visual Studio 2008 SP1。
ConfiguredDownlevelFeaturesCheck
检查是否安装了不支持 SysPrep 的任何 SQL Server 版本。
FacetDomainControllerCheck
检查计算机是否为域控制器。建议不要将 SQL Server 2008 R2 安装在域控制器上。
确保此计算机不是域控制器。
FacetWOW64PlatformCheck
确定此操作系统平台是否支持 SQL Server 安装程序。
这将阻止在 64 位平台上进行任何不受支持的安装。对于 SysPrep，不支持 WOW 安装。
FusionRebootCheck
检查是否由于断开的合成 ATL 而必须进行计算机重新启动。挂起重新启动会导致 SQL Server 安装程序失败。
需要计算机重新启动。在安装 SQL Server 之前，，必须重新启动计算机。
SqlUnsupportedProductBlocker
检查是否安装了 SQL Server 7.0 或 SQL Server 7.0 OLAP 服务。SQL Server 2008 R2 不支持与 SQL Server 7.0 并行安装。
删除 SQL Server 7.0 或将 SQL Server 2008 R2 安装到其他计算机上。
SSMS_IsInternetConnected
检查计算机是否已连接到 Internet。基于 .NET Framework 技术的 SQL Server 管理工具必须在启动时检查证书吊销列表。
请确保计算机已连接到 Internet。
Sql2005SsmsExpressFacet
检查是否安装了 SQL Server 2005 Express Edition 工具。
Unconfigured_AsFeatureStateCheck
检查 SQL Server SSAS 功能是否处于未配置状态。
VSShellInstalledRule
检查是否存在 Visual Studio 2008 的先前版本。
在安装 SQL Server 2008 R2 之前，必须先升级至 Visual Studio 2008 SP1。
BlockCrossLanguageInstall
检查安装语言是否与现有 SQL Server 功能的语言相同。
必须使用与现有 SQL Server 实例相同的语言版本来升级 SQL Server。
BlockMixedArchitectureInstall
检查要安装的功能是否与指定实例具有相同的 CPU 体系结构。
安装或升级时所使用的 SQL Server 安装介质必须与要修改的 SQL Server 实例具有相同的体系结构。
FAT32FileSystemCheck
检查指定的驱动器是否为 FAT32 文件系统卷。支持但建议不要在 FAT32 文件系统上进行安装，因为它没有 NTFS 文件系统安全。
确保您指定用于安装 SQL Server 的驱动器不是 FAT32 文件系统。
Unconfigured_RsFeatureStateCheck
检查 Reporting Services 功能是否处于未配置状态。
Unconfigured_SqlFeatureStateCheck
检查 SQL Server 数据库引擎 功能是否处于未配置状态。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
What is the difference between HQL and SQL in Hibernate framework?
Apr 17, 2024 pm 02:57 PM
HQL and SQL are compared in the Hibernate framework: HQL (1. Object-oriented syntax, 2. Database-independent queries, 3. Type safety), while SQL directly operates the database (1. Database-independent standards, 2. Complex executable queries and data manipulation).
Usage of division operation in Oracle SQL
Mar 10, 2024 pm 03:06 PM
"Usage of Division Operation in OracleSQL" In OracleSQL, division operation is one of the common mathematical operations. During data query and processing, division operations can help us calculate the ratio between fields or derive the logical relationship between specific values. This article will introduce the usage of division operation in OracleSQL and provide specific code examples. 1. Two ways of division operations in OracleSQL In OracleSQL, division operations can be performed in two different ways.
Comparison and differences of SQL syntax between Oracle and DB2
Mar 11, 2024 pm 12:09 PM
Oracle and DB2 are two commonly used relational database management systems, each of which has its own unique SQL syntax and characteristics. This article will compare and differ between the SQL syntax of Oracle and DB2, and provide specific code examples. Database connection In Oracle, use the following statement to connect to the database: CONNECTusername/password@database. In DB2, the statement to connect to the database is as follows: CONNECTTOdataba
What does the identity attribute in SQL mean?
Feb 19, 2024 am 11:24 AM
What is Identity in SQL? Specific code examples are needed. In SQL, Identity is a special data type used to generate auto-incrementing numbers. It is often used to uniquely identify each row of data in a table. The Identity column is often used in conjunction with the primary key column to ensure that each record has a unique identifier. This article will detail how to use Identity and some practical code examples. The basic way to use Identity is to use Identit when creating a table.
Detailed explanation of the Set tag function in MyBatis dynamic SQL tags
Feb 26, 2024 pm 07:48 PM
Interpretation of MyBatis dynamic SQL tags: Detailed explanation of Set tag usage MyBatis is an excellent persistence layer framework. It provides a wealth of dynamic SQL tags and can flexibly construct database operation statements. Among them, the Set tag is used to generate the SET clause in the UPDATE statement, which is very commonly used in update operations. This article will explain in detail the usage of the Set tag in MyBatis and demonstrate its functionality through specific code examples. What is Set tag Set tag is used in MyBati
How to solve the 5120 error in SQL
Mar 06, 2024 pm 04:33 PM
Solution: 1. Check whether the logged-in user has sufficient permissions to access or operate the database, and ensure that the user has the correct permissions; 2. Check whether the account of the SQL Server service has permission to access the specified file or folder, and ensure that the account Have sufficient permissions to read and write the file or folder; 3. Check whether the specified database file has been opened or locked by other processes, try to close or release the file, and rerun the query; 4. Try as administrator Run Management Studio as etc.
How to use SQL statements for data aggregation and statistics in MySQL?
Dec 17, 2023 am 08:41 AM
How to use SQL statements for data aggregation and statistics in MySQL? Data aggregation and statistics are very important steps when performing data analysis and statistics. As a powerful relational database management system, MySQL provides a wealth of aggregation and statistical functions, which can easily perform data aggregation and statistical operations. This article will introduce the method of using SQL statements to perform data aggregation and statistics in MySQL, and provide specific code examples. 1. Use the COUNT function for counting. The COUNT function is the most commonly used
How to implement Springboot+Mybatis-plus without using SQL statements to add multiple tables
Jun 02, 2023 am 11:07 AM
When Springboot+Mybatis-plus does not use SQL statements to perform multi-table adding operations, the problems I encountered are decomposed by simulating thinking in the test environment: Create a BrandDTO object with parameters to simulate passing parameters to the background. We all know that it is extremely difficult to perform multi-table operations in Mybatis-plus. If you do not use tools such as Mybatis-plus-join, you can only configure the corresponding Mapper.xml file and configure The smelly and long ResultMap, and then write the corresponding sql statement. Although this method seems cumbersome, it is highly flexible and allows us to
