1 / 37

Part 1 - Installing SQL Server 2008 Express Edition on Windows Server 2008 R2

Part 1 - Installing SQL Server 2008 Express Edition on Windows Server 2008 R2. This guide assumes you are installing SQL server to be used with MDT 2012/2010 on Windows Server 2008 R2 server in a domain environment. It is intended for use in home lab or test environment.

umeko
Download Presentation

Part 1 - Installing SQL Server 2008 Express Edition on Windows Server 2008 R2

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Part 1 - Installing SQL Server 2008 Express Edition on Windows Server 2008 R2 This guide assumes you are installing SQL server to be used with MDT 2012/2010 on Windows Server 2008 R2 server in a domain environment. It is intended for use in home lab or test environment. This guide covers how to Install the SQL Server Configure the SQL Server Configure Windows Firewall to allow SQL Server through the firewall Build a database for use with MDT 2012/2010

  2. Click OK

  3. Click Next

  4. Click Next Accept the licence terms

  5. Click Install

  6. Click Next

  7. Select Database Engine Services Click Next

  8. Select Named Instance Make a note of the Named instance (SQLExpress) Click Next

  9. Click Next

  10. Click on Use the same account for all SQL Server services

  11. Enter the username and password for an Administrator account in your domain. Click OK Reminder: this guide is intended for use in a home lab or test environment. Hence it is sufficient to use the Administrator account in your domain for this.

  12. Select Windows authentication mode Add user accounts you want to give administrator access to the SQL Server. You can also add AD Security Groups to this list Click Next

  13. Click Next

  14. Click Next

  15. Click Install

  16. Click Next

  17. Click Close

  18. Configure The SQL Server Open the SQL Server Configuration Manager

  19. Expand SQL Server Network Configuration Select Protocols for SQLEXPRESS Right click on enable Named Pipes

  20. Select SQL Server Services Right click on SQL Server Browser and select Properties

  21. Change to Automatic

  22. Right click on SQL Server Browser and select Start

  23. Right click on SQL Server (SQLEXPRESS) and select Restart

  24. Configure Windows Firewall Open Windows Firewall Click on Allow a program or feature through Windows Firewall

  25. Click on Allow another program…

  26. Click Browse… Browser to C:\Program Files (x86)\Microsoft SQL Server\90\Shared Open sqlbrowser

  27. Click Add

  28. Once again add another program to allow through the firewall Browse to C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn Open sqlsevr

  29. Build A MDT Database Open the Deployment Workbench and expand your Deployment Share Expand Advanced Configuration Right click on Database and select New Database

  30. Enter the hostname of your server on which you installed SQL Server 2008 Express Enter SQLEXPRESS Choose Named Pipes

  31. Enter a name for your database

  32. Enter the name of your Deployment Share as the SQL Share

  33. Click Next

  34. A database has been created and linked with your deployment share. Click Finish

  35. This is what the Database page should look like

  36. End of Part 1 Part 2 of this series will demonstrate how to populate and use the database in a couple of deployment scenarios. Instructions are available on my blog.emeneye.wordpress.com

More Related