Home » » SQL 2000 IN WINDOWS 7

SQL 2000 IN WINDOWS 7

Written By Easy Life on Tuesday, February 21, 2012 | 2/21/2012 07:52:00 PM

Installing SQL Server 2000 in Windows 7 Sudarpo.Net - SQL Server 2000 Windows 7

SQL Server 2000 Installation Guide.
Step 1 – You are likely to see Program Compatibility Assistant when you run the setup. Ignore it, just Run the program.
Sudarpo.Net - SQL Server 2000 Windows 7
Step 2 – Welcome to the classic installation wizard.
Sudarpo.Net - SQL Server 2000 Windows 7
Step 3 – Select where to install the server. Local / Remote ?
Sudarpo.Net - SQL Server 2000 Windows 7
In some cases, you probably get the following error message after selecting LOCAL COMPUTER.
—————————
Error
—————————
A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup.
—————————
OK
—————————
as shown in this screen.
Sudarpo.Net - SQL Server 2000 Windows 7
This is a known issue with SQL Server 2000 installation and Microsoft Support has the solution. It will tell you to modify registry setting. You can backup and delete PendingFileRenameOperations as mentioned. If you don’t feel safe, just rename to “xxPendingFileRenameOperations” or anything you like. It will do the trick.
Sudarpo.Net - SQL Server 2000 Windows 7
Step 4 – Select Create new instance.
Sudarpo.Net - SQL Server 2000 Windows 7
Step 5 – Select Server and Client Tools.
Sudarpo.Net - SQL Server 2000 Windows 7
Step 6 – Use default instance name or rename it as you see fit. I would recommend you to rename the instance if you are going to install another version of SQL Server.
Sudarpo.Net - SQL Server 2000 Windows 7
Step 7 – Select TYPICAL, MINIMUM, or CUSTOM. If you wish to change the installation folder, you can do it here.
Sudarpo.Net - SQL Server 2000 Windows 7
Step 8 – use Local System account for highest security privilege level.
Sudarpo.Net - SQL Server 2000 Windows 7
Step 9 – Select MIXED MODE (recommended). This enables SQL Server Authentication mode. Enter password for default sa login.
Sudarpo.Net - SQL Server 2000 Windows 7
Wait..wait…wait…done.
Sudarpo.Net - SQL Server 2000 Windows 7
After installation is complete, you can apply SQL Server 2000 Service Pack 4 as well. Ignore the Program Compatibility Assistant again and run the update.
Sudarpo.Net - SQL Server 2000 Windows 7
Wait till wizard appears.
Sudarpo.Net - SQL Server 2000 Windows 7
Select your SQL Server 2000 instance name.
Sudarpo.Net - SQL Server 2000 Windows 7
Upgrade it! and wait till it completes.
Sudarpo.Net - SQL Server 2000 Windows 7
Have fun with your SQL Server 2000.
Share this article :
 
Copyright © 2015. CENTRAL GOVERNMENT EMPLOYEES NEWS - All Rights Reserved
Proudly powered by Blogger