Installing SQL Server
If you have a functional instance of SQL 2008 or above on your computer, you do not need to uninstall and re-install as I have described here.
1. Download the appropriate SQL installation exe file for your computer. You need at least SQL 2008 to run DNN7.
There are several SQL versions available for from Microsoft. The one you select will depend on whether you have a 32 or 64 bit computer and whether you want to install the management console in addition to the database.
You will use the management console to create new databases when setting up new instances of DNN, among other things. The only reason NOT to install the management console would be to save a small amount of disk space.
You can find the file to download by Googling ‘download sql 2008 express’ and identify the Microsoft site for downloads.
Download the appropriate file to a known location so you can find it for installation. I have a folder named 'Downloads' where I automatically put things so I know where to look for them.
SQLEXPRWT_x64_ENU.exe is the file I used on my 64-bit laptop.
HINT ** On the Microsoft download page under Details and Install Instructions, you may find other things that need to be installed for SQL Server to run. One item I identified here as missing on my machine was the Windows PowerShell. To find missing software, Google the item to find them on Microsoft’s website.
2. Double click on the downloaded installation file.
You may be prompted to install the .Net Framework before proceeding to the SQL installation.
SQL installation dialog will appear. (may take a few minutes)
3. Click on Installation --> New installation or add features to an existing installation
4. Click the ‘I accept the license terms’ checkbox. Click Next.
If no SQL installation exists on machine (which should be the case if you uninstalled all instances like I did, or if you have a virgin machine), a license box appears.
If an instance of SQL exists, dialog asks if you want to install another instance or modify existing instance. In my case, I had deleted all old instances, so I just got the license dialog.
5. Set up support rules will be checked and results displayed. (Sorry, I missed capturing this image.)
All items must Pass except Windows Firewall is okay with a ‘warning’. If something fails, you’re on your own to solve the issue!
6. Select all the install options. You can change the installation folders, but probably just accept the defaults.
7. This step creates an instance of SQL Server. The default name for the instance is SQLExpress. Leaving this as the name has the advantage of not having to translate the name you assign in remaining installation instructions.
If you had a previous version installed named SQLExpress, it will appear in the list of installed instances and you will have to name your new instance something else.
If you want to change the name, enter the new name in the 'Named Instance' box.
Remember the name of your instance. You will need it later.
8. Accept the default accounts listed to run the SQL services.
9. Select Mixed Mode authentication mode instead of Windows authentication.
You will find Windows authentication recommended by some and mixed authentication by others. I find it better to have mixed authentication because it makes it possible to set up local database owners/users that are identical with those on the production server and I never seem to get Windows authentication to work on my local machine.
Enter a password for the ‘sa’ account.
The login being used to install this instance (your personal computer login') will also be created as an administrator by default. (so both sa and your login will have access to the database.)
10. Chose to report errors of SQL server….or not. Click Next
It will take several minutes to install.
You should receive a notification that the installation was successful. Click Close.
To check the installation
1. Start button --> Microsoft SQL Server 2008 RC --> SQL Server Management Studio
2. Enter Server Name. If you accepted the default during installation, this will be .\SQLEXPRESS . Note the ' .\' that is required before the server name. This indicates the instance is on the local server.
Select Mixed Authentication from the dropdown list.
2, Enter the Login name ‘sa’ and password .
If the set up has been successful, you will see in the Object Explorer box the name of the server instance and a list of folders under the instance.
3. To close the management console, click File --> Exit
Here's a good video about installing SQL.