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

This article focuses on "common problems and solutions when installing SQLServer database". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn the common problems and solutions when installing SQLServer database.

FAQ 1:

When installing SqlServer2000, "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 SqlServer2000 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/SessionManager node of the registry.

3. Click the "SessionManager" 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 SqlServer2000 installer, take a step back, and then click next to solve the problem!

FAQ 2:

The performance counter registry hive consistency check failed during installation of SQLServer2005 or SQLServer2008.

Solution:

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

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

3. The value of the previous step LastCounter must match the maximum value of the Counter entry of [HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/WindowsNT/CurrentVersion/Perflib/004], and the LastHelp of the previous step must match the maximum value of the LastHelp entry of [HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/WindowsNT/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/WindowsNT/CurrentVersion/Perflib/009].

What are the problems when installing the SQLServer database

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

FAQ 3:

After the SqlServer2000 installation is complete, the service cannot be started, and the pop-up prompt box "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 Microsoftsqlserver under current_user and local_machine/software/microsoft/.

two。 Delete the installation directory and the MicrosoftSQLServer folder under C:/ProgramFiles.

3. Change the computer name to all uppercase letters. (this problem belongs to sqlserver'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. [MicrosoftSQL-DMO (ODBCSQLState:42000)]-you cannot use blank object or column names. If necessary, use a space.

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!

At this point, I believe you have a deeper understanding of "common problems and solutions when installing SQLServer database". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.