1. Download SQL Server 2008 Express with Tools
| • | Download SQL Express 2008 with Tools from (219 MB) from http://go.microsoft.com/?linkid=9394725 |
| • | SQL Server 2008 Express requires .NET Framework 3.5 SP1, if your server does not have .NET Framework 3.5 SP1 you will need to download .NET Framework 3.5 SP1 and install it on your server. You can download .NET Framework 3.5 SP1 from http://go.microsoft.com/fwlink/?LinkId=120550 |
| • | SQL Server 2008 Express requires Windows Installer 4.5, if your server does not have Windows Installer 4.5 you will need to download Windows Installer 4.5 and install it on your server. You can download Windows Installer 4.5 from http://go.microsoft.com/fwlink/?LinkId=123422 |
| • | SQL Server 2008 Express requires Windows PowerShell 1.0, if your server does not have Windows PowerShell 1.0 you will need to download Windows PowerShell 1.0 and install it on your server. You can download Windows PowerShell 1.0 from http://go.microsoft.com/fwlink/?LinkId=120552 |
2. Install SQL 2008 Express
| 1. | Run SQLEXPRWT_x86_ENU.EXE (or SQLEXPRWT_x64_ENU) to install SQL 2008 Express. |
| 2. | At the "SQL Server Installation Center", choose "System Configuration Checker" to make sure you are ready to install SQL 2008 Express |
| 3. | Click to view. |
| 4. | When the "System Configuration Checker" has validated that you are ready to install SQL 2008 Express, return to the "SQL Server Installation Center" and click on Installation. |
| 5. | Click to view. |
| 6. | Select "New SQL Server stand-alone installation or add features to an existing installation" |
| 7. | Click to view. |
| 8. | A setup support check will run. Make sure there are no errors or warnings, press OK. |
| 9. | The "SQL Server 2008" Setup will now appear, on the Product Key page, click Next. |
| 10. | Check the box "I accept the license terms" and click Next. |
| 11. | Click "Install" to install the Setup Support Files. |
| 12. | When the Setup Support Files install is complete, click Next. |
| 13. | You will now be in the "Feature Selection" page. Select "Database Engine Services" and "Management Tools - Basic" and then click Next. |
| 14. | In the "Instance Configuration" page, specify SQLExpress in both the "Named instance" and "Instance ID" fields. |
| 15. | Click to view. |
| 16. | Click Next twice. |
| 17. | You will now be in the "Server Configuration" page. Change the SQL Server Database Engine's Account Name to "NT AUTHORITY\SYSTEM" and SQL Server Browser's Startup Type to Automatic, then click Next. |
| 18. | Click to view. |
| 19. | On the Database Engine Configuration page, enable Mixed Mode |
| 20. | Enter and confirm a password for the Built in SQL server system administration account (note this is the user sa). |
| 21. | Before you can continue, you will need to specify the group(s) that you want to have unrestricted access to SQL Server. Click "Add..." and select the group(s). It is recommended that you at least add Administrators and the "Current User" (Service Account). |
| 22. | When you are done here, click Next three times, and then click Install. |
| 23. | When the installer completes, click Next and then Close. |
3. Enable Protocols
Now that SQL 2008 Express is installed, we need to enable the Network options (because for some reason SQL Express has these disabled by default).
| 1. | In the Start Menu, open Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Surface Area Configuration |
| 2. | In the Surface Area Configuration utility, click the link "SQL Server Configuration Manager" |
| 3. | Expand "SQL Server Network Configuration" and select Protocols. |
| 4. | Enable TCP/IP and enable Named Pipes |
| 5. | Right click on the TCPIP, select Properties, and enable the server's IP address too. |
| 6. | Close the SQL Server Configuration Manager. |
4. Add Firewall Exceptions
If you have a software firewall installed on your server, you will need to add exceptions for the SQL Server and SQL Browser services.
If you are using Windows Firewall, do the following:
| • | In your Control Panel, open the Windows Firewall applet. |
| • | Go to the Exceptions tab. |
| • | Click Add Program |
| • | Browse to and select "C:\Program Files\Microsoft SQL Server\MSSQL.10\MSSQL\Binn\sqlservr.exe" |
| • | Click OK. |
| • | Click Add Program |
| • | Browse to and select "C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe" |
| • | Click OK and then click OK again. |
If you are using a third-party software firewall, you will need to follow their instructions to add exceptions to sqlservr.exe and sqlbrowser.exe.
5. Restart the Services or Reboot the Server
When you have completed all of these steps, you will need to restart the SQL Server and SQL Browser services to complete the process.
6. Return to the Network SQL Express configuration for Addressinator! and continue with Step #4