Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about the common problems and solutions in the installation of SQL Server database. The article is rich in content and analyzes and describes for you from a professional point of view. I hope you can get something after reading this article.

FAQ 1:

When installing Sql Server 2000, "the previous program created a pending file operation, and the computer must be restarted before running the installer", which is still invalid after restart.

Solution:

1. Instead of quitting the Sql Server 2000 installer, switch directly to the desktop.

two。 Open the registry editor (type "regedit" in "run" and enter), and navigate to the HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Session Manager node of the registry.

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

4. Close the registry editor, switch back to Sql Server 2000 installer, take a step back, and then click next to solve the problem!

FAQ 2:

A performance counter registry hive consistency check failure was encountered during installation of SQL Server 2005 or SQL Server 2008.

Solution:

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

two。 Find Last Counter and Last Help inside. The values of Last Counter and Last Help are dynamically assigned by Windows, which vary from computer to computer.

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

Note: 004 is an example of simplified Chinese. If you install the English version, it should be [HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Windows NT/CurrentVersion/Perflib/009].

4. Close the registry editor and run SQL Server's installer again and there should be no problem.

FAQ 3:

The service failed to start after the Sql Server 2000 installation is complete, and the prompt box pops up: setup failed to configure the server. Refer to the server error log and c:\ windows\ sqlstp.log for more information.

Solution:

1. Open Registry Editor and delete all information about Microsoft sql server under current_user and local_machine/software/microsoft/.

two。 Delete the installation directory and the Microsoft SQL Server folder under C:/Program Files.

3. Change the computer name to all uppercase letters. (this problem belongs to sql server's bug,GetComputerName used to get 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 uppercase and lowercase letters or both lowercase letters, prompting a general network error! The solution is to change the computer name to all uppercase!

4. Restart the computer, and then install the OK.

FAQ 4:

There is an empty database in the database, which has no name, no tables, no users, no roles in Enterprise Manager. Cannot be modified or deleted. Using Enterprise Manager, an error message pops up when doing operations such as creating a new table:

An unexpected error occurred during the operation. [Microsoft SQL-DMO (ODBC SQLState:42000)]-you cannot use blank object or column names. Use a space if necessary.

Solution:

1. Open the SQL properties panel and check the check box before allowing direct changes to the system directory! Then click OK to exit.

two。 Open the master database, find the sysdatabase table inside, find the problem database, delete the problem and solve the problem!

These are the common problems and solutions of SQL Server database installation shared by Xiaobian. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.