SQL Server 2000 Installation Problems

SQL Server 2000 Installation Problems

1. InstallProgramNote: A previous program has created a pending file operation on the installation computer. You must restart the computer before running the installation program.

 

Solution: Enter Regedit in the running window, open the Registry Editor, and go to HKEY_LOCAL_MACHINE \ SYSTEM \ controlset001 \ Control \ Session Manager.
Find pendingfilerenameoperations and delete the key value (this key value is a temporary project of the installer, as long as the corresponding application is cleared ),
Close Registry Editor. Reinstall SQL Server 2000.

 

2. the command line option syntax error prompt is displayed when the installation is halfway through.

 

Solution: the installation directory of this installer cannot contain Chinese characters, such as D: \ Xiaomi backup \ Xiaomi. In this way, you can directly use the English installation directory eg: e: \ SQL2000.

 

3. It is not associated with a trusted SQL server connection

 

Solution: This is mainly because the SQL Server login authentication mode is mixed Authentication Mode, because the SQL Server Authentication mode is Windows serious mode by default, leading to errors, start the SQL Server Enterprise Manager, select the server for which you want to set the Authentication mode, right-click, select Properties, select Security Options in the pop-up Properties dialog box, select "SQL Server and Windows" for identity authentication, and click OK.

 

4. In the displayed dialog box, "Access Denied" is displayed, and a dialog box is displayed, "this operation is being performed on the MSSQL Server service"

 

Solution: Check that SQL Server verification is not enabled. Click Start-run (win key + r) -Enter cmd-in the pop-up DOS box, enter net star MSSQLServer to open (close and change star to stop ). However, after I changed it, I still couldn't, and then re-installed it again. During the installation, the default installation was not followed, when I select the Authentication Mode in the middle, I select the SQL Server and Windows Hybrid Authentication mode, without the default Windows Authentication mode. After that, it will be fine.

 

although all the problems have been solved, I still don't know much about them. Welcome to a discussion.