Asked By Kevin on 17-May-11 12:01 AM

Jitendra Faye replied to Kevin on 17-May-11 12:05 AM

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 http://www.sudarpo.net/2009/09/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.

A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup.

as shown in this screen.
Sudarpo.Net - SQL Server 2000 Windows 7

This is a known issue with SQL Server 2000 installation and http://support.microsoft.com/kb/312995. 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 http://msdn.microsoft.com/en-us/library/ms677973%28VS.85%29.aspx.

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


Sudarpo.Net - SQL Server 2000 Windows 7

After installation is complete, you can apply http://www.microsoft.com/downloads/details.aspx?FamilyId=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en 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.

Sahil Kumar replied to Kevin on 17-May-11 12:08 AM

I did try it on my laptop (SQL Server 2008 Express on Windows 7 Home Premium x64, Core i5, 4 GB RAM), worked fine.

Visual Studio and SQL Server on Windows 7


When attempting to install SQL Server 2008 RTM or SQL Server 2005 RTM/SP1/SP2 on Windows 7 RC, you will receive a warning dialog stating that SQL Server has known compatibility issues with this version of Windows.  Since SQL Server is redistributed by Visual Studio, installations in which the user selects to install SQL Server along with Visual Studio will be affected.  The issues that trigger the compatibility warning have been fixed in SQL Server 2008 SP1 and SQL Server 2005 SP3.


The recommended workaround is to install Visual Studio with SQL Server and then upgrade to SQL Server 2008 SP1 or SQL Server 2005 SP3 using Windows Update.  You can also choose to install SQL Server 2008 SP1 before installing Visual Studio. 


The steps below are shown for installing Visual Basic 2008 Express Edition with SP1 plus SQL Server 2008 on Windows 7 RC:


1.     Download Microsoft Visual Basic 2008 Express Edition with SP1 from the http://www.microsoft.com/express/download/.

2.     During setup, make sure to select “Microsoft SQL Server 2008” from the “Optional Components” page.

3.     As soon as SQL Server 2008 installation begins, you will receive a compatibility warning dialog.

4.     Select Run Program to continue the installation.

5.     You will then be presented with a second compatibility warning dialog when running “setup.exe”.  Select Run Program again.

6.     After installation has completed, launch Windows Update.

7.     Select Check for updates in the left-hand pane.   

8.     Under the optional updates, you should see a checkbox for “Microsoft SQL Server 2008 Service Pack 1”.

9.     If for some reason, you don’t see “Microsoft SQL Server 2008 Service Pack 1” listed as an optional update, please go http://go.microsoft.com/fwlink/?LinkId=151639 to download the service pack.

10.   Check the box next to the entry and select OK.   

11.   Windows update will then install SQL Server 2008 SP1.

12.   Once installation has completed, you may be prompted to reboot.



More Links/Information

http://go.microsoft.com/fwlink/?LinkId=135960 (http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en)

http://go.microsoft.com/fwlink/?LinkId=151639 (http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&displaylang=en)


If you’re installing SQL Server 2005 Express (any Express edition) or SQL Server 2008 Express (Runtime Only) you can just download the SQL Server Express package containing the latest service pack. This may seem counter-intuitive if you already have some Express package, but installing it and then downloading and applying service pack is going to take longer than downloading a package already containing the latest service pack and installing it. Plus, in case of SQL Server 2008 Express, the service pack package is actually bigger than the SQL Server Express package, since the service pack is shared with all SQL Server 2008 editions.


http://www.microsoft.com/downloads/details.aspx?FamilyID=01af61e6-2f63-4291-bcad-fd500f6027ff&displaylang=en (http://www.microsoft.com/downloads/details.aspx?FamilyID=01af61e6-2f63-4291-bcad-fd500f6027ff&displaylang=en)

http://go.microsoft.com/fwlink/?linkid=135970 (http://www.microsoft.com/downloads/details.aspx?FamilyID=3181842a-4090-4431-acdd-9a1c832e65a6&displaylang=en)

http://go.microsoft.com/fwlink/?linkid=135973 (http://www.microsoft.com/downloads/details.aspx?FamilyID=b448b0d0-ee79-48f6-b50a-7c4f028c2e3d&displaylang=en)

http://go.microsoft.com/fwlink/?linkid=135974 (http://www.microsoft.com/downloads/details.aspx?FamilyID=d434dc36-a24d-44ee-937e-553c382557e3&displaylang=en)


If need to install SQL Server 2008 Express edition other than Runtime Only on Windows 7 RC and need to avoid the warning dialogs, you can create SQL Server 2008 with Service Pack 1 package yourself. Please follow steps described by Peter Saddow http://blogs.msdn.com/petersad/archive/2009/02/25/sql-server-2008-creating-a-merged-slisptream-drop.aspx.



TSN ... replied to Kevin on 17-May-11 12:11 AM


Ravi S replied to Kevin on 17-May-11 12:16 AM

try this


SQL Server 2005 came out long before Windows 7 and (largely due to UAC) they don’t actually get on out of the box. Symptoms include prerequisite warnings about IIS7, getting an abrupt error when you finish the installation and although the SQL server service may start SQL Management Studio will not. This is simply what you need to do to get a working SQL Server 2005 including SQL Management Studio on Windows 7.

Download and install the latest x32/x64 http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=enhttp://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en.

Install SQL Server 2005 from your installation media and ensure that towards the end you select to NOT start the SQL service. Personally since I use SQL Server 2005 on my workstation as a test environment I’m happy assign it the Local System account.

Download and install http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en…and just before it finishes installing you’ll see something like this…

SQL Server 2005 User Provisioning Tool for Vista

SQL Server 2005 User Provisioning Tool for Vista

This is the SQL Server 2005 User Provisioning Tool for Vista and it lets you know that admin users on the Vista workstation (Windows 7 in our case) will not have admin rights in SQL Server unless explicitly stated. Close it for now since because the SQL service is not running, any new users will not be saved. The SP3 installation will now finish, abruptly.

Reboot your workstation to allow the SQL services to start.

From the start menu run the ‘SQL Server 2005 Surface Area Configuration’ tool. Select the “Add New Administrator” link and select which users you wish to assign access to. There is no confirmation, the dialog just goes away without any error messages.

Start SQL Management Studio and you’ll now be able to login. No errors, just a fully working SQL Server on Windows 7 :)

refer the links also
Anoop S replied to Kevin on 17-May-11 12:32 AM
Which version of SQLare you installing - full version or is it the Express version? If it is the express version then the management tools don't install by default. Go to http://www.microsoft.com/sqlserver/2005/en/us/express.aspx and scroll about 1/3 the way down the page and look for a link to the management tools.