Reinstall after uninstalling Sql server 2005
Sql sercer 2005 needs to be uninstalled before reinstalling. Since the components of Sql sercer 2005 are scattered, it is necessary to find the corresponding location and uninstall one by one when uninstalling. If the uninstallation is not clean, many problems will occur when reinstalling, resulting in installation failed. Two tools are needed here: Windows Install Clean Up (msicuu2.exe) and SRVINSTE.EXE.
1.Sql server 2005 complete uninstall tutorial
Step 1: Stop all services of SQL server 2005.
Step 2: Open the Control Panel to remove the program.
Note: uninstall sequence, reverse uninstall:
Microsoft SQL Server VSS Writer Microsoft SQL Server Setup Support Files (English) Microsoft SQL Server Native Client Microsoft SQL Server 2005 Books Online (English) Microsoft SQL Server 2005 Backward compatibillty Microsoft SQL Server 2005
Step 3: Install Windows Installer Clean Up. (msicuu2.exe file). Run after installation.
Select the following items and press Remove:
Microsoft SQL Server VSS Writer Microsoft SQL Server Setup Support Files (English) Microsoft SQL Server Native Client Microsoft SQL Server 2005 Tools Microsoft SQL Server 2005 Books Online (English) Microsoft SQL Server 2005 Backward compatibillty Microsoft SQL Server 2005
Step 4: Run the SRVINSTW.exe file, choose to remove the service, and proceed to the next step.
Select the type of computer to execute as the local machine.
Select the following service names respectively.
SQL Server VSS Writer SQL Server Full Text Search (MSSQL) SQL Server Browser SQL Server Agent (MSSQLSERVER) SQL Server Active Directory Helper SQL Server (MSSQLSERVER)
Click Next to proceed with the removal.
Step 5: In the start menu, run: Regedit, delete the following registry:
HKEY_CURRENT_USER/Software/Microsoft/Microsoft SQL Server HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/MSSQLServer HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/SQLXML4
Step 6: Finally delete the following two directories:
C:/Program Files/Microsoft SQL Server C:/Program Files/SQLXML 4.
Step Seven: Restart the computer.
2.Sql server 2005 installation tutorial
Prepare the SQL Server 2005 installation CD or installation file, double-click the “setup.exe” file on the installation CD or run the installation file, enter the installation program, accept the license agreement, and click the “Next” button.
The “Install Prerequisite Components” interface appears, wait patiently for the system to automatically install the necessary components.
After waiting for a while, enter the “Welcome to the Microsoft SQL Server Installation Wizard” interface.
The “System Configuration Check” interface appears, and the system will be checked automatically.
Click Next, the installer prepares the installation wizard, and then starts the preparatory work before installation.
The registration interface pops up, enter your name and company.
Click “Next” to select the components to be installed, generally select all. You can also make more detailed settings after advanced options.
Select the default instance, and proceed to “Next”.
Set the service account, select the built-in system account of the cause, and check the following services.
Enter the authentication mode, select the mixed mode (Windows authentication and sql server authentication), and enter the password and confirm the password.
Click Next to enter the collation settings, select Chinese_PRC, and check Accent Sensitive.
Enter the error and usage report setting interface, and proceed directly to the next step.
Show all component options.
After clicking the installation, the system starts to configure the selection, and click one more step to enter the installation progress interface.
After all components are installed, the interface is as follows.
Click Finish to complete the installation.
3. Problems and solutions during installation
When there is a problem during installation, the component installation will fail, as shown in the following figure:
Issue 1: Unable to open key, please verify access,
Solution: The administrator runs the command prompt, and then enters the following code to press Enter.
Question 2: The Sql Server service cannot be started.
Solution: Do not click Retry, replace the files sqlservr.exe and sqlos.dll under C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn in the computer (sqlservr. exe and sqlos.dll replacement files are in the SP4 patch file), and then try again.