What options and steps should I take to install SQL 2005 & SQL 2008?

Answer: SQL2005 is the new release of Microsoft SQL Server database engine.  You can download directly from our website at the following link.

Click here to download SQL Server.

If you are running Windows 7, you will need to download and install SQL Server 2008 Express directly from the Microsoft website – click here.

We also recommend you download and install the SQL Server Management Studio Express (what a name) from the same Microsoft page.  It is a great tool for managing SQL databases.  You will need to download from Microsoft’s website and get the correct version for the SQL Server version you are installing.

We recommend installing directly at the server.  When installing through remote connectivity you could encounter security or other issues.  This does not mean it cannot be installed remotely but we are unable to provide assistance if remote installation issues arise.

You can install SQL 2005 over a prior version of SQL / MSDE.  The install program will simply upgrade to the newest version and keep all existing databases.  However, we do recommend you backup your databases first as a precaution.

You do not need to download the version of SQL with Advance Services or the Toolkit.  Before installing SQL 2005, you must be logged in with full Administrative rights.  The information below explains the best options for installing SQL Server and enabling TCP/IP protocol for SQL Server.

The SQL Server 2005 install is fairly straight forward.  However, we recommend you take use the defaults of the installation prompts with the following exceptions:

1.  Uncheck the option to Hide Advanced Configuration Options

SQL2005-1

2. Select the Default Instance option.  Named instances will create much confusion later.

SQL2005-2

3. Select Mixed Mode authentication and enter a private password for the ‘sa’ (system administrator) account.  Be sure to keep the password as you may need it one day.

SQL2005-3

Taking these steps will keep the SQL Server installation simple by giving the SQL Server the same name as the computer.

Enable TCP/IP

Once the SQL Server 2005 is installed, you should also take the following steps to Enable TCP/IP:

1. Click on Windows Start / All Programs / Microsoft SQL Server 2005 / Configuration Tools / SQL Server Configuration Manager
2. Double click on SQL Server 2005 Network Configuration
3. Click on Protocols for MSSQLServer
4. Right click on TCP/IP and left click on Enable.  Do the same for Named Pipes.

SQL2005-4

5. Double click on SQL Server 2005 Services
6. Right click on Restart to restart the server using the additional protocols

SQL2005-5
7. Close SQL Server Configuration Manager

Be sure to note the name of the SQL Server as you may need it when connecting ExpressMaintenance the first time.

SQL Server 2005 will now be installed and ready for use.

For more information on recommended SQL 2005 Server Properties – click here.