1. Download SQL Server 2008 Express with Tools
| • | Download SQL Express 2008 with Tools from Microsoft |
| • | Go to google.com |
| • | Enter in the search term Microsoft SQL Express 2008 download |
| • | Select the result that is from Microsoft, and download either 32-bit or 64-bit depending on your operating system. |
| • | At the date of this Help topic, the latest was SQL Express 2008 R2 available from http://www.microsoft.com/express/database/ |
| • | SQL Server 2008 Express requires .NET Framework 3.5 SP1 or higher, 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. |
| • | Easiest way to get this is to do a Windows Update on your server or do a search for the download online |
| • | SQL Server 2008 Express requires Windows Installer 4.5 or higher, 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. |
| • | Easiest way to get this download is to do a search for the text Windows Installer 4.5 download |
| • | 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. |
| • | Easiest way to get this download is to do a search for the text Windows PowerShell download |
2. Install SQL 2008 Express
| 1. | Run the file you downloaded to install SQL 2008 Express. |
| • | For example, the file may be called SQLEXPRWT_x86_ENU.EXE (or SQLEXPRWT_x64_ENU) |
| 2. | At the "SQL Server Installation Center", choose "System Configuration Checker" to make sure you are ready to install SQL 2008 Express |
| 3. | 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. |
| 4. | Select "New installation or add features to an existing installation" |
| 5. | Continue with the step up |
| 6. | At the "Feature Selection" page. Select "Database Engine Services" and "Management Tools - Basic" if not all already selected |
| 7. | In the "Instance Configuration" page, specify SQLExpress in both the "Named instance" and "Instance ID" fields. |
| 8. | At 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 |
| 9. | On the Database Engine Configuration page, enable Mixed Mode |
| 10. | Enter and confirm a password for the Built in SQL server system administration account (note this is the user sa). |
| 11. | Do 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 as well as the "Current User" (Service Account) and the logged in computer administrator user. |
12. Complete the installation.
3. Return to the Network SQL Express configuration for AyaNova and continue the steps to enable the protocols, add firewall exceptions, restart the SQL services or reboot the computer, and continue with the networking steps.