• Register
  • FAQs
  • Contact
  • Time Zone
  • Chat on WhatsApp

Installing SQL Server 2008 Express with Tools

Wednesday 11 June 2014, by Younus Kazi

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.

 

About The Author

This article was posted by .

Join the discussion by adding your comments below:

« Back to the Learning Blog

We are providing affordable IT training courses at times to suit you - enhance your employability and stand out from the crowd.

Become an IT expert and get that competitive edge that employers are looking for.

Popular Courses

Useful Links

Contact Us

London Academy of IT
Unit 15, Boardman House
64 Broadway
Stratford
London E15 1NT
United Kingdom
UK: +44 (0)208 432 6218
USA: +1 610-234-7870
CANADA: +1 416-900-1211
WhatsApp: +44 0749 461 6045
Chat with London Academy of IT on WhatsApp

Share this page now!

2012 - 2024 © London Academy of IT Limited. All Rights Reserved.
Registered in England & Wales with company no. 07923992.