SQL Server Database installation common problem Solution collection _mssql

In this article we have summarized several solutions to common problems in installing SQL Server databases for beginners to learn, so let's take a look.

FAQ One:

When you install SQL Server 2000, "a previous program created a pending file operation, you must restart your computer before you run Setup," is still invalid after restarting.

Solution:

1. Do not exit the SQL Server 2000 installer and switch directly to the desktop.

2. Open Registry Editor (enter "regedit" after "Run"), and navigate to the registry hkey_local_machine/system/currentcontrolset/control/session The manager node.

3. Click the node for session Manager, and then locate the "pendingfilerenameoperations" option in the window on the right, double-click on (or right-click and choose Modify), and then remove the value from the blank column below (empty).

4. Turn off Registry Editor, switch back to SQL Server 2000 installer, take a step back, and then point to the next issue can be resolved!

FAQ Two :

The performance counter registry hive consistency check failed during installation of SQL Server 2005 or SQL Server 2008.

Solution:

1. Open Registry Editor and navigate to the registry Hkey_local_machine/software/microsoft/windows Nt/currentversion/perflib

2. Find the inside last counter and last help. The values for last counter and last help are dynamically allocated by Windows, and these two values vary by computer.

3. The value of last counter in the previous step must be with [Hkey_local_machine/software/microsoft/windows nt/currentversion/perflib/004] Match the maximum value of the counter entry, and the last help in the previous step must be associated with [Hkey_local_machine/software/microsoft/windows nt/currentversion/perflib/004] Match the maximum value of the last Help item.

Note: 004 is an example of Simplified Chinese, if the installation of the English version, the corresponding should be [Hkey_local_machine/software/microsoft/windows nt/currentversion/perflib/009]

4. Close the Registry Editor and run the SQL Server Setup program again without problems.

FAQ Three:

The service failed to start after SQL Server 2000 Setup was completed, and pop-up prompts the installer to configure the server. Refer to the server error log and C:\windows\sqlstp.log for more information.

Solution:

1. Open Registry Editor to remove all information about Microsoft SQL Server under Current_User and local_machine/software/microsoft/.

2. Delete the installation directory and the Microsoft SQL server folder under C:/Program files.

3. Change the computer name to all capitals. (This problem belongs to SQL Server Bug,getcomputername for obtaining the local computer name.) The Client network library component (DBMSLPCn.dll) converts the name to all uppercase. The Server network library component (SSMSLPCn.dll) retains the name when it returns. Installation fails when the Windows computer name contains both uppercase and lowercase letters or lowercase letters, prompting a general network error! The solution is to change the computer name to ALL caps! )

4. Reboot the computer, and then install it OK.

FAQ Four:

The database has an empty database that has no name in Enterprise Manager, no tables, no users, no roles ... Cannot be modified and cannot be deleted. With Enterprise Manager, the error message pops up when you create a new table:

An unexpected error occurred during the execution of this operation. [Microsoft SQL-DMO (ODBC sqlstate:42000)]-cannot use a blank object or column name. If necessary, use a space.

Solution:

1. Open the SQL Properties panel to allow the system directory to be directly modified before the check hook! Then click OK to exit.

2. Open the master database, find the inside of the Sysdatabase table, to find the problem of the database, delete the issue will be resolved!

Wonderful topic Sharing: SQL Server Installation Tutorial manual

About solutions to common problems with SQL Server database setup here, I hope this introduction can bring you some harvest.