One SQL Server 2000 installation Adventure

Recently, I encountered a strange SQL Server installation experience, here write it, and friends to learn, explore.

My system is WIN2000 Standard Server version, the first time you install the system to properly install and run SQL Server2000. Due to the fact that the Access file database tables in office installed in the recent system cannot be opened, the WIN2000 operating system has been reinstalled and the operating system has been installed successfully without the office systems being reinstalled more than once.

First, the encounter:

I installed the Office2000 and Borland Delphi7, then can normal operation and management of Office files, Delphi can also be normal operation. Then I start reinstalling SQL Server2000, but when I go to the local computer, the system pops up a warning message box that says "A previous program installation has created a pending file operation on the installation computer." You must restart your computer before running Setup! "。 I'm not going to reboot many times.

Second, the process:

I recall that I did not uninstall SQL Server2000 properly before reinstalling the operating system. Because the operating system was reinstalled, the folder where SQL Server was installed was manually removed, and the registry was run, and all the dependencies of SQL Server were removed from the registry. Restart installation of SQL Server, and the warning message above can still appear. I repeatedly looked up SQL Server dependencies in the registry and cleaned it up with Windows Optimizer master, and restarted multiple times. The failure still exists.

I'm analyzing a program that might have a conflict with a SQL Server installer. I press the F8 key when I reboot the system, select "Safe Mode" to enter the system, run SQL Server Setup, when the previous warning box information is gone, then go all the way next, copy and install the file, but when the data server is configured, it is found to be running for a long time, At that time is going to work, I think anyway, just let it continue to "configure" it, then let the machine run, decided to work the next day to see the results ┉┉

The next day at work, I went straight to the computer, the results found that the computer is still "Configure the server", more than 10 hours have not been configured well, it seems safe mode is not good, had to restart the computer in normal mode.

Go to Control Panel-Add/Remove program, at this time I see the installed items are: Borland Delphi7, Office2000, PowerWord 2002 Professional Edition, I think is not to want these installed programs and SQL Server installation program conflict, I removed the above program one at a A and then reinstalled SQL Server for each deletion to find out which program was in conflict. The results are still not installed successfully. Do you really want to format the hard drive? Because I just did not have WIN2000 boot CD, because the unit LAN all the computers are founder computer Rocky series, the computer configuration is the same, I put a piece also installed WIN2000 server version and SQL Server2000 hard disk as the main disk installed to my computer, My computer's hard drive as from the disk, the main disk and from the disk have been divided into C, D, E, f four areas. With the main disk boot system, into the "My Computer", you can see the letter is assigned to the order of C, D, E, F, G, H, I. I then to the G area of the format, and then I removed the main disk, only installed from the disk, power-on reboot, I saw the WIN2000 server's startup interface, enter the password, entered the system. I hold the mood to try, start the SQL Server2000 installer again, you say strange not strange, enter the "local computer" time, press "Next", the previous warning message did not appear, the system entered the familiar installation interface, I all the way NEXT, really shun Ah, all the way to the end, Configure the server and quickly install the SQL Server successfully. I can't believe my eyes. I go into SQL Server Enterprise Manager, view the database and table, and manipulate the table, everything is OK. I'm happy in the tray. See the icon for SQL Server Service Manager.

Wonder, I entered the "My Computer", into D disk, found in D disk originally installed in all the content is not, oh, I remember, I used to install the SQL Server and other applications I was installed in D disk, I formatted the "G" area is actually D disk, but also the conflict of the program grid dropped.

Then I immediately install Office2000, is also a good trip, soon Office2000 also installed. The other programs are then installed successfully. The system and application software are now running normally.

Iv. Lessons Learned

An unforgettable installation went by, and I was wondering what caused the SQL SEVER2000 to fail at the time of reinstallation? I have a careful recollection of reinstalling WIN2000:

First: When I decided to reinstall the system, I did not uninstall SQL Server and other installed applications with the normal uninstall program.

Second: I want to mention this powerword. I first installed in the system PowerWord 2002 mini version, and then feel that this version of the professional vocabulary is very small, I did not normally uninstall PowerWord 2002 Mini version of the case, installed PowerWord 2002 Professional Edition, of course, can run PowerWord Professional Edition. When I reinstall the operating system, and the same as above, did not use the normal uninstall program to uninstall the installed PowerWord 2002 Professional Edition and other application software. I use the software of Windows optimization Master to uninstall PowerWord files, but in the Control Panel "Add/Remove program" can still See "PowerWord 2002" This item, select PowerWord 2002, click the "Delete" button, Strange is also can pop up Jinshan installation interface, select "Delete" , it also shows "finish". Repeated operations do not always delete this item. In addition, when I use another hard drive as the main disk to boot the system, when I entered the "My Computer" found that the "I" area of the letter is the Kingsoft icon, rather than the normal default disk icon, open this "I" area when the installation of Jinshan also run. Strange, is it related to this situation? Here also ask friends to present your opinion.

Third: The lesson is that each time you reinstall the system, it is best to use the normal method to uninstall the program and then reinstall the system.

The above is a little summary of me, write to discuss together with you.