How to Install SQL server 2008 on Windows 7


In my previous post I show How to Install IIS on Windows 7. Now I am going to show How to Install Microsoft SQL Server 2008 Express Edition.

First you need the installer, download it from here.

Requirements:

Visual Studio 2010 or VS 2008 SP1

Step 1: Double click on the installer. It will take some time to extract. After that an window  will open as follow.

First window of installation

Step 1

Step 2: From this window click on the Installation menu (See Left). Now there will be appear some option under Installation. From right, click on the option New SQL Server stand-alone installation or add features to an existing installation.

Note: After Clicking on that a window may appear as bellow. Just click on the button Run Program of that.

Click Run Program

Note

Step 3: Now setup will take a moment to complete some operation. To continue there can not be any operation with status failed. If any operation fails then it will not be possible to continue installation. Click OK

Every operation should be passed

Step 4

Step 4: This is express edition so I do not need to enter any product key. Just Click on Next

Next

Step 4

Step 5: Check Accept the terms and click NEXT

Check Accept Terms & Condition and Click Next

Step 5

Step 6: Now Click Install button. Some setup support files will be installed.

Install Setup Support Files

Step6

Step 7: Now again It needs some operation to be completed. Every operation must be  passed or warning or skipped. If any operation fails then it is not possible to continue. Click Next.

There can not be any operation with failed status

Step 7

Step 8: Now select the features which do you need. Here I am selecting Database Engine Services, Busines Intelligence Development Studio, Management Tools basic & SQLl Client Connectivity SDK. Click Next.

Select Services

Step 8

Step 9: Here we need the name and instance ID. I am selecting Default Instance but keep the name “SQLExpress” in your mind for future use. Click Next.

Check Default instance

Step 9

Step 10: Now a window will appear  and it will show the space required and available. Click Next.

Click Next

Step 10

Step 11: Here select the account name from the dropdown list for SQL Server Database Engine-

NT AUTHORITY\NETWORK SERVICE and Click Next.

Select NT AUTHORITYNETWORK SERVICE

Step 12: Now select which mode do you want to use. Here I am selecting the Mixed mode.
For mixed mode I have to provide the password for the root account (username “sa” default) and adding my current user by which i will also be able to access database engine without default administrator account (username : sa ).

Select NT AUTHORITY\NETWORK SERVICE

Step 12

Step 13: Click Next

Click Next

Step 13

Step 14: Now again every operation must be passed or skipped. If there is any operation with status failed then installation will not be possible. Click Next

There must not be any operation with status failed.

Step 14

Step 15: Now finally it is going to start the installation. Click Install

Start Installation

Step 15

Step 16: Now wait till installation is complete. Setup is complete. Click Next

Next

Step 16

Step 17: Now Close this window

Close

Close

Exit this

Exit this

At last Exit this window

Installation is complete.Install SQL Server 2008 SP1. If you face any problem just let me know. After installation to see how to connect and perform basic operation by Management Studio see my next post.

Thanks.

Advertisements

About Razib Chandra Deb

I completed my BSc in CSE from CSE Department of KUET. Currently I am working as a Software Engineer in Samsung R&D Institute Bangladesh(SRBD). I am interested in image processing.
This entry was posted in Uncategorized and tagged , , . Bookmark the permalink.

45 Responses to How to Install SQL server 2008 on Windows 7

  1. Hmm, not bad. Carry on.
    A nice blog title (razibdeb) would be appreciated. 🙂

  2. bikash says:

    nice tutorial dosto…go ahead

  3. chaminda says:

    it’s really nice, Thanks

  4. Ashish says:

    TITLE: SQL Server Setup failure.
    ——————————

    SQL Server Setup has encountered the following error:

    The collation was not found.

    Error code 0x84B40000.

    ——————————
    BUTTONS:

    OK
    ——————————

  5. achyut says:

    It worked for me thanx…alot…very..good …description not…even a single step ..missed…

  6. Rajendra says:

    SQL Server Setup failure after step-15.
    ——————————

    SQL Server Setup has encountered the following error:

    The collation was not found.

    Error code 0x84B40000.

  7. garima says:

    there is an error occured when follow the above steps….error is previous releases of microsoft visual studio 2008 failed….so tell me what to do?????its very urgent

  8. srivatsava says:

    after installing it is asking about server name and user id where as in the installation process we give only password so, how can we open database engine……….

    • BHARGAVI says:

      yes, my problem also same,but installation very qcikly so many steps i thimk skipped y.GIVE ME response quickly

  9. Maureen says:

    Thanks you very much – at least I have been able to install this successfully. I will now get on with installing SQL Server 2008 SP1

  10. mohamed riswan says:

    while install sql2008 for windows7,a MOF error occured,wat can i do

  11. Denise says:

    Thanks!

  12. maina says:

    i uninstalled sql server 2008.but instances are still present
    how to remove instances of sql server…

  13. Swapna says:

    Hi I have done step by step installation and was successful but after installation i could not find and sql server management studio(i selected mixed mode) during installation.

    I tried to open sql server configuration manager and saw “The Remote Procedure Call Failed [0X800706be]. Please help me.

  14. I got these error at the final state:
    1. Your SqL server 2008 completed with failures.
    2. The MOF compiler could not connect with WMI server. This is either because of semantic error such as an incompatibility with existing WMI repository or an actual error as the failure of the WMI server to start.
    3.The system could not find the path.

  15. enkachu says:

    The “Restart Computer” step of the “Setup Support Rules” fails when I try to install SQL Server 2008 Express on Windows 7. Any idea about this?

  16. rabeea says:

    thanks alot sir…. u done a great job

  17. biplab says:

    i am getting restart computer error i tried several times after restart but generating same error please help me

  18. gowda says:

    at the installation rules i am getting an error that is “previous releases of micrpsoft visual studio 2008” in windows 7,32bit os so what will be the solution for these pls help me

  19. Maryam Jamil says:

    when going to installation it says browse for sql server installation media
    what to do with that??

  20. praveen says:

    thanq u struggled a lot before>>>

  21. vinay says:

    can you tell is the sql server installation is reommended on windows 7machine in Active directory

  22. nasir says:

    even after following your steps n successful installation me not able to find. server management studio on my start menu

  23. veerababu says:

    very gud

  24. Curiouspoo says:

    During installation… on step 8… I did not get the Database Engine option…and then it directly went to step 10..

  25. On step 8 we need an uncompressed drive to install the package. (If the destination drive is compressed, and you don’t want to uncompress the whole drive, then you just need to uncompress the destination folder “Microsoft SQL Server”.)

  26. siddu says:

    is it possible to install ms sql server 2008 without visual studio….?

    • Hema says:

      Hi
      We tried to install sql server 2008. But its showing some error at the validation stage. The error code is 0x84b40000. Collation was not found. We tried to edit collatiin default value manually. But, its freezed couldnt edit further and the installation was stopped immediatly. Kidly guude ms in this. Its ver urgent request.

  27. hey it’s asking me to browse an installation media

  28. shivu says:

    thanks a lot

  29. criptov says:

    its help us to other I can understand his to install

  30. Z3t says:

    your blog really helps me
    thanks a lot

  31. Francis Nderitu says:

    OK thanks, I have a system developed on vb6.0 and am using SQL server 2008R2 as the system data base, what do I need to do for this system to run on a LAN, the server machine is running windows7 and the work stations as well.
    Pls help

  32. Francis Nderitu says:

    On above every time the error, SQL Sercer name does not exist, even when I use the IP address to point the server

  33. anup549 says:

    this link will help you

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s