How to Install SQL 2008 Server in Windows 7

May 1, 2011 — 4 Comments

I recently got HP Elite Book 8540w which comes with Windows 7.
I want to install SharePoint 2010 in my laptop with SQL Server 208 R2. Before I can Install SharePoint 2010 in Windows 7, I want to install SQL Server 2008 R2

1. Download SQL Developer Edition from your MSDN or Trail Version

2. Double Setup

3.  In SQL Server Installation Center, click on System Configuration Checker.  This will launch a tool to check for
conditions  that prevent a successful SQL Server Installation. If everything is okay, click on Installation.

 

SQL_Server_Installation_Center_2008_R2

4. Click on the "Installation" hyperlink in the left side of the screen.

SQL_Server_Installation_Center_installation

5. The Next button is available only if all check results are successful, or if failed checks do not block installation

SQL_Server_2008_R2_Setup_Support_Rules

 

6. Specify the edition of SQL Server to install in Windows 7  and enter the Product Key and click next

SQL_Server_2008_R2_Setup_product_key

7. Read the license agreement and if you agree with it, check the "I accept the license terms" check box, and then click the Next button.

SQL_Server_2008_R2_Setup_Licence_Terms

8. Setup is installing a required component in Windows 7

SQL_Server_2008_R2_Setup_setup_support_rules_2

9. The following is a new page on SQL Server setup, its name is Setup Role.

Choose "SQL Server feature installation" to install SQL Server Database Engine, Analysis Services, Integration Services, Reporting Services.

Choose "Analysis Services with SharePoint Integration" if you want SQL Server setup to add PowerPivot for SharePoint to a SharePoint farm.

Choose "All Features With Defaults" to install all features of SQL Server in one box.

SQL_Server_2008_R2_Setup_SetupRole

10. Select the features for your installation.

SQL_Server_2008_R2_Setup_Feature_Selection

11. Setup is running rules to determine if the installation process will be blocked.

SQL_Server_2008_R2_Setup_Installation_Rules

12. Instance Configuration: Specify the name and instance ID for the instance of SQL Server. Instance ID becomes part of the installation path.
In this case, I created a folder in C called SQLServerDirectory and this is where I am going to keep SQL Instance

SQL_Server_2008_R2_Setup_Instance_Configuration

13.  Disk Space Requirements: Review the disk space summary for the SQL Server features you selected

SQL_Server_2008_R2_Setup_DiskSpaceRequirement

14: Server Configuration: Specify the service accounts and collation configuration.

In this case, my laptop is connected to the domain and I am using domain\username and password for the installation. 

If the computer is not part of a domain, use a local user account without Windows administrator permissions.
You can create this account using Control Panel -> User Accounts.

SQL_Server_2008_R2_server_configuration

 

15.  On the Database Engine Configuration page, choose the authentication mode to use for your SQL Server installation.  If you select Mixed Mode we need to enter and confirm the password for the (sa) login when you choose Mixed Mode Authentication

SQL_Server_2008_R2_Database_Engine_Confi_Account_Provi

Database Engine Configuration: Data Directories

SQL_Server_2008_R2_Database_Engine_Configuration

16. Analysis Services Configuration. If you want to use the current users account, just click on Add Current User

SQL_Server_2008_R2_Analysis_Service_Configuration

17. Reporting Service Configuration: Specify the Reporting Service configuration mode

SQL_Server_2008_R2_Report_service_configuration

 

18. On the Error and Usage Reporting page, optionally clear each check box to disable error reporting.

SQL_Server_2008_R2_Setup_error_reporting

 

19. Installation Configuration Rules:  Setup is running rules to determine if the installation process will be blocked.

SQL_Server_2008_R2_Setup_Installation_confi_Rules

20. Read to Install: Verify the SQL Server 2008 R2 features to be installed

Ready_to_install_SQL_2008_r2

21.  Installation Process for SQL 2008 Server R2 in Windows 7

SQL_Server_2008_R2_Setup_InstallationProcess

22. Complete: Your SQL Server 2008 R2 installed completed successfully in Windows 7

SQL_Server_2008_R2_Setup_Complete

4 responses to How to Install SQL 2008 Server in Windows 7

  1. 

    My brother suggested I would possibly like this website. He was totally right. This submit truly made my day. You cann’t consider just how a lot time I had spent for this information! Thank you!

  2. 

    in this installation what criteria would you use to login?

    • 

      I was installing SQL for SharePoint 2010 and my laptop was connected to domain. My login was domain\user name.
      If your comptuer is not connected to DC, I believe you can use your Admin account or use SA

Leave a Reply

Please log in using one of these methods to post your comment:

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