How to Set Up SQL Server Express
- 1). Connect to the Internet and install all needed Windows Updates. Go to "Start--All Programs--Windows Update." Choose "Express" and download and install all available updates. Ensure you have .NET Framework 2.0 installed. If you don't have it, Windows Update will install it for you. Restart your computer if prompted.
- 2). Download SQL Server Express. Either burn the file to a disk or run the setup file from your hard drive. Click the "sqlexpr.exe" file to start the installation wizard.
- 3). Agree to the license agreement and allow the SQL Server Component Update to run. If any other prerequisites are required, they will be installed now. Click "Next" once updates are installed.
- 4). Press "Continue" after the pre-installation check scan runs. Enter a "Name" and "Company" into the appropriate text boxes and press "Next." Select which features to install by checking the boxes next to each feature. You can also install sub-features by clicking the plus sign next to a feature to expand sub-features.
- 5). Choose whether to install a default or named instance. A named instance is normally only used if you want to install multiple instances of SQL Server or if any SQL Server instances already exist. Click "Next."
- 6). Choose a local or domain user account to associate with the SQL Server Express instance. If you have clicked "Hide advanced configuration options," you may not see this page or other configuration pages.
- 7). Choose your authentication mode and a password if necessary. Click "Next." Continue configuring each component you chose to install. The wizard will take you through a quick configuration screen for each component.
- 8). Press "Install" after reviewing your setup choices. Press "Finish" after installation is complete.
