How to Install SQL server 2008 on Windows 7

Razib Chandra Deb

Rate me:

3.86/5 (5 votes)

24 Dec 2011CPOL3 min read

226.9K

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 … Continue reading →

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.

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.

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

Step 4

Step 4: This is express edition so I do not need to enter any product key. Just Click on 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.

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.

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.

Step 9

Step 10: Now a window will appear and it will show the space required and available. 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.

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

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

Step 14

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

Step 15

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

Step 16

Step 17: Now Close this window

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.

CodeProject

This article was originally posted at http://razibdeb.wordpress.com/2011/01/20/how-to-install-sql-server-2008-on-windows-7

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Razib Chandra Deb

Student

Bangladesh

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

I read your post about the installation of SQL server 2008. I just reinstalled the same but the R2 Developer disc.

I am always getting stuck at the point of connecting after installation and presently got the message below. I am new to this and would appreciate any help.

I installed it as per instructions in the Microsoft SQL 2008 book by Mike Hotek.

Could you look at the error message and give some advice on what to do.

I disabled the firewall while installing it and has just turned it back on,

Here is the error message:

============

===================================

Cannot connect to MIBELOVED-PC\SQLEXPRESS.

===================================

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

------------------------------
Error Number: -1
Severity: 20
State: 0

------------------------------
Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectorThread()

This is the summary file after I ran the repair from the original software disc.

I cannot send the detail file because it is a long file but I could send it by another means if you suppy an email address, because this box seems to freeze up when I copied and pasted the detailed file.

Here is the summary file:

CSS

Overall summary:
  Final result:                  Failed: see details below
  Exit code (Decimal):           -2068119551
  Exit facility code:            1211
  Exit error code:               1
  Exit message:                  Failed: see details below
  Start time:                    2012-06-29 20:50:03
  End time:                      2012-06-29 21:16:18
  Requested action:              Repair
  Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\Detail.txt
  Exception help link:           http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.50.1600.1%26EvtType%3d0x0AADD6DA%400xDC80C325

Machine Properties:
  Machine name:                  MIBELOVED-PC
  Machine processor count:       2
  OS version:                    Windows 7
  OS service pack:               Service Pack 1
  OS region:                     United States
  OS language:                   English (United States)
  OS architecture:               x64
  Process architecture:          64 Bit
  OS clustered:                  No

Product features discovered:
  Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered
  Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Database Engine Services                 1033                 Developer Edition    10.50.1617.0    No
  Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         SQL Server Replication                   1033                 Developer Edition    10.50.1617.0    No
  Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Full-Text Search                         1033                 Developer Edition    10.50.1600.1    No
  Sql Server 2008 R2   MSSQLSERVER          MSAS10_50.MSSQLSERVER          Analysis Services                        1033                 Developer Edition    10.50.1617.0    No
  Sql Server 2008 R2   MSSQLSERVER          MSRS10_50.MSSQLSERVER          Reporting Services                       1033                 Developer Edition    10.50.1617.0    No
  Sql Server 2008 R2                                                       Management Tools - Basic                 1033                 Developer Edition    10.50.1617.0    No
  Sql Server 2008 R2                                                       Management Tools - Complete              1033                 Developer Edition    10.50.1617.0    No
  Sql Server 2008 R2                                                       Client Tools Connectivity                1033                 Developer Edition    10.50.1617.0    No
  Sql Server 2008 R2                                                       Client Tools Backwards Compatibility     1033                 Developer Edition    10.50.1617.0    No
  Sql Server 2008 R2                                                       Client Tools SDK                         1033                 Developer Edition    10.50.1617.0    No
  Sql Server 2008 R2                                                       Integration Services                     1033                 Developer Edition    10.50.1617.0    No

Package properties:
  Description:                   SQL Server Database Services 2008 R2
  ProductName:                   SQL Server 2008 R2
  Type:                          RTM
  Version:                       10
  SPLevel:                       0
  Installation location:         D:\x64\setup\
  Installation edition:          DEVELOPER

User Input Settings:
  ACTION:                        Repair
  AGTDOMAINGROUP:                <empty>
  AGTSVCACCOUNT:                 .\SQL2008SBSSQLAgent
  AGTSVCPASSWORD:                *****
  AGTSVCSTARTUPTYPE:             Automatic
  ASCONFIGDIR:                   Config
  ASDOMAINGROUP:                 <empty>
  ASSVCACCOUNT:                  <empty>
  ASSVCPASSWORD:                 *****
  CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\ConfigurationFile.ini
  ENU:                           True
  FAILOVERCLUSTERGROUP:          <empty>
  FAILOVERCLUSTERNETWORKNAME:    <empty>
  FARMACCOUNT:                   <empty>
  FARMADMINPORT:                 0
  FARMPASSWORD:                  *****
  FTSVCACCOUNT:                  NT AUTHORITY\LOCAL SERVICE
  FTSVCPASSWORD:                 *****
  HELP:                          False
  IACCEPTSQLSERVERLICENSETERMS:  False
  INDICATEPROGRESS:              False
  INSTANCENAME:                  MSSQLSERVER
  ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
  ISSVCPASSWORD:                 *****
  ISSVCSTARTUPTYPE:              Automatic
  PASSPHRASE:                    *****
  QUIET:                         False
  QUIETSIMPLE:                   False
  SQLDOMAINGROUP:                <empty>
  SQLSVCACCOUNT:                 <empty>
  SQLSVCPASSWORD:                *****
  UIMODE:                        Normal
  X86:                           False

  Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\ConfigurationFile.ini

Detailed results:
  Feature:                       Database Engine Services
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Failed: see details below
  Configuration error code:      0xDC80C325
  Configuration error description: The name has already been shared
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\Detail.txt
  Configuration status:          Failed: see details below
  Configuration error code:      0x30E00066@1211@1
  Configuration error description: Service 'SQLSERVERAGENT' stop request failed.
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\Detail.txt

  Feature:                       SQL Client Connectivity
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Client Connectivity SDK
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Writer
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Browser
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Server Replication
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Failed: see details below
  Configuration error code:      0xDC80C325
  Configuration error description: The name has already been shared
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\Detail.txt
  Configuration status:          Failed: see details below
  Configuration error code:      0x30E00066@1211@1
  Configuration error description: Service 'SQLSERVERAGENT' stop request failed.
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\Detail.txt

  Feature:                       Full-Text Search
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Failed: see details below
  Configuration error code:      0xDC80C325
  Configuration error description: The name has already been shared
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\Detail.txt
  Configuration status:          Failed: see details below
  Configuration error code:      0x30E00066@1211@1
  Configuration error description: Service 'SQLSERVERAGENT' stop request failed.
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\Detail.txt

  Feature:                       Analysis Services
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Reporting Services
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Integration Services
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Compact Edition Tools
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Compact Edition Runtime
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Client Tools Connectivity
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Management Tools - Complete
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Management Tools - Basic
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Client Tools SDK
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Client Tools Backwards Compatibility
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Business Intelligence Development Studio
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Server Books Online
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Microsoft Sync Framework
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

Rules with failures:

Global rules:

There are no scenario-specific rules.

Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\SystemConfigurationCheck_Report.htm

The following warnings were encountered while configuring settings on your SQL Server.  These resources / settings were missing or invalid so default values were used in recreating the missing resources.  Please review to make sure they don’t require further customization for your applications:

Service SID support has been enabled on the service.
Service SID support has been enabled on the service.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.