SQL Server database installation often see the problem solution highlights, SQL Server

SQL Server database installation often see the problem solution highlights, SQL Server

This article summarizes several solutions that often encounter problems when installing SQL Server databases for beginners to learn. Let's take a look at them.

FAQ 1:

When installing SQL Server 2000, the following error occurs: "The previously executed program has created a suspended file. Before running the installer, you must restart the computer.

Solution:

1. You do not need to exit the SQL Server 2000 installation program and directly switch to the desktop.

2. Open the Registry Editor (Press "regedit" in "run" and press Enter) to locate the HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Session Manager node in the registry.

3. click the "Session Manager" node, find the "PendingFileRenameOperations" option in the window on the right, and double-click it (or right-click it and select "modify ), then, remove (empty) the values in the blank bar below it.

4. Turn off the Registry Editor, switch back to the SQL Server 2000 installer, step back, and then click Next to solve the problem!

FAQ 2:

When installing SQL Server 2005 or SQL Server 2008, the "performance counter registry Configuration unit consistency" check fails.

Solution:

1. Open the Registry Editor and navigate to the Registry's HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Windows NT/CurrentVersion/Perflib.

2. Find the Last Counter and Last Help in it. The values of Last Counter and Last Help are dynamically allocated by Windows. These two values may vary depending on the computer.

3. the Last Counter value in the previous step must match the maximum value of the Counter item in [HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Windows NT/CurrentVersion/Perflib/004, the Last Help in the previous step must match the maximum value of the Last Help item in [HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Windows NT/CurrentVersion/Perflib/004.

Note: 004 is an example of Simplified Chinese. If the English version is installed, it corresponds to [HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Windows NT/CurrentVersion/Perflib/009].

4. Close the Registry Editor and run the SQL Server Installation program again.

FAQ 3:

After SQL Server 2000 is installed, the service cannot be started. A prompt box is displayed, "the installation program fails to configure the Server. For more information, see Server Error log and c: \ windows \ sqlstp. log ".

Solution:

1. Open the Registry Editor and delete 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 uppercase letters. (This is an SQL server bug. GetComputerName is used to obtain the name of a local computer. The client network library component (DBMSLPCn. dll) converts the name to all uppercase letters. The server network library component (SSMSLPCn. dll) retains the name returned. Installation fails when the Windows computer name contains both uppercase and lowercase letters or both lowercase letters. A general network error is prompted! The solution is to change the computer name to uppercase !)

4. restart the computer and install it again.

FAQ 4:

There is an empty database in the database, which has no name in the Enterprise Manager, no tables, no users, no roles ...... It cannot be modified or deleted. An error message is displayed when you use the Enterprise Manager to create a table:

An unexpected error occurs during this operation. [Microsoft SQL-DMO (ODBC SQLState: 42000)]-empty objects or column names cannot be used. If necessary, use a space.

Solution:

1. Open the SQL properties panel and check the check box before the system directory can be directly modified! Click confirm to exit.

2. Open the master database, find the sysdatabase table in it, find the problematic database, and delete the problem to solve it!

The solutions to common problems during SQL Server database installation are described here. I hope this introduction will bring you some benefits.