How to install Microsoft SQL Server 2008 Express with related tools?

Setp by step guide

  1. Download Microsoft SQL Server 2008 Express with Tools from the website at http://www.microsoft.com/en-us/download/details.aspx?id=22973

  1. After downloading the file, run it. It will be extracted and open the SQL Server Installation Center.

  1. On SQL Server Installation Center click the New SQL Server stand-alone installation or add features to an existing installation link.

  1. You will be asked for Product Key. You do not need any product key for SQL Express edition.  Click Next.

  1. Accept the license term and click Next.

  1. Click Install button on Setup Support Files window.

  1. Once operation is completed, if Failed is 0, click Next. Otherwise, fix the issue and then click Re-run button.

  1. Select features on Feature Selection panel and click Next.

  1. At Instance configuration select Named instance. Accept all the default settings and click Next.

  1. Click Next on Disk Space Requirements panel.

  1. At Server Configuration panel, Select NT AUTHORITY\NETWORK SERVICE into the Account Name column.

  1. On Database Engine Configuration panel make sure that Account Provisioning tab is selected. Check Windows authentication mode and click Add Current User button to specify current users as a SQL Server administrator.

  1. Click Next on Error and Usage Reporting panel.

  1. Click Next on Installation Rules panel.

  1. Click Install on Ready to Install panel.

  1. Click Next on Installation Progress panel once setup process is completed.

  1. Click Close on Complete panel to close the setup window.

  1. To check that SQL Server has been installed successfully run the SQL Server Management Studio.

  1. Type or select the Server name if it is not being selected. Select Windows Authentication for Authentication.

  1. The Microsoft SQL Server Management Studio will connect the SQL Server instance.