Installing SQL Server 2000 in 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.
Step 2 – Welcome to the classic installation wizard.
Step 3 – Select where to install the server. Local / Remote ?
In some cases, you probably get the following error message after selecting LOCAL COMPUTER.
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.
Step 4 – Select Create new instance.
Step 5 – Select Server and Client Tools.
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.
Step 7 – Select TYPICAL, MINIMUM, or CUSTOM. If you wish to change the installation folder, you can do it here.
Step 8 – use Local System account for highest security privilege level.
Step 9 – Select MIXED MODE (recommended). This enables SQL Server Authentication mode. Enter password for default sa login.
Wait..wait…wait…done.
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.
Wait till wizard appears.
Select your SQL Server 2000 instance name.
Upgrade it! and wait till it completes.
Have fun with your SQL Server 2000.
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.
Step 2 – Welcome to the classic installation wizard.
Step 3 – Select where to install the server. Local / Remote ?
In some cases, you probably get the following error message after selecting LOCAL COMPUTER.
—————————as shown in this screen.
Error
—————————
A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup.
—————————
OK
—————————
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.
Step 4 – Select Create new instance.
Step 5 – Select Server and Client Tools.
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.
Step 7 – Select TYPICAL, MINIMUM, or CUSTOM. If you wish to change the installation folder, you can do it here.
Step 8 – use Local System account for highest security privilege level.
Step 9 – Select MIXED MODE (recommended). This enables SQL Server Authentication mode. Enter password for default sa login.
Wait..wait…wait…done.
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.
Wait till wizard appears.
Select your SQL Server 2000 instance name.
Upgrade it! and wait till it completes.
Have fun with your SQL Server 2000.
No comments:
Post a Comment