PARTNER

Selasa, 12 Oktober 2010

Installing SQL Server 2000 in Windows 7 Guide

Installing SQL Server 2000 in Windows 7 is pretty much the same as installing in any version of Windows. I provide the guide here just for clarity and to help newbie.
As you have seen in my previous post at Running SQL Server 2000 in Windows 7, I have successfully installed and run SQL Server 2000 in Windows 7 RTM.
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.

Notes:
The only issue that I have right now is I can’t apply the latest security patch for SQL Server 2000 such as:
  • KB899761-v8.00.2040
  • KB948110-v8.00.2050
  • KB960082-v8.00.2055
  • KB948111-8.00.2273
  • KB960083-v8.00.2282
I keep getting Not enough storage error or just a dumb error “installation did not complete“. It’s really not recommended to run SQL Server 2000 in your production server without these updates.
Error 1:
—————————
Setup Error
—————————
Not enough storage is available to process this command.
—————————
OK
—————————
Error 2:
After applying compatibility mode to Windows XP SP2 or SP3.
—————————
KB899761(ENU) Setup Error
—————————
KB899761(ENU) installation did not complete.
—————————
OK
—————————

Source : http://www.sudarpo.net/2009/09/installing-sql-server-2000-in-windows-7-guide/
Share:

0 komentar:

Posting Komentar

Blog Archive

Blogger templates