1. When installing SQL server 2008, the system prompts "failed to restart the computer"
On Windows Server 2003, when SQL server 2008 express is installed, the system prompts "failed to restart the computer"
Solution:
Open the registration table editor (regedit.exe), locate the PendingFileRenameOperations project in HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSession Manager, and delete it. After modification, you do not need to restart the server. You can continue the installation!
2. When SQL server 2008 is installed to around 80%, the system prompts "SQL browser cannot be started"
For a clean Windows Server 2003 system, all patches are installed. When it is installed around 80%, the system prompts that SQL browser cannot be started and installation fails. After careful analysis of the installation log, we found that the database installation failed due to the XML 6.0 sp1 (KB933579) installation failure. Check that the system has already installed XML 6.0 sp2, so the system prompts an updated version when installing sp1.
Solution:
Uninstall XML 6.0 sp2 or later, and then install SQL Server 2008. For sql2008 installation, the newest patch is a version later than XML 6.0 sp1.
3. You cannot create a database.
After installing SQL Server 2008, you cannot create a new database. The prompt is: Failed to load file or assembly "Microsoft. sqlServer. sqm, Version = 10.0.0.0, Culture = neutral, PublicKeyToken = 89845dcd8080cc91 "or one of its dependencies. The system cannot find the specified file.
Solution:
Copy C: Program FilesMicrosoft SQL Server100SharedMicrosoft. SqlServer. Sqm. dll to the following two folders:
C: Program FilesMicrosoft SQL Server100ToolsBinnVSShellCommon7IDE
C: Program Files (x86) Microsoft SQL Server100ToolsBinnVSShellCommon7IDE
If the system does not have the (x86) folder, just copy it to the previous folder.
