Installing Microsoft SQL Server 2008


MS SQL Server is a useful database tool. It gives a user the ability to create databases, edit existing ones and generate reports. It also supports the development of Business Intelligence apps. The Server can be installed in standalone machines as well as networked machines. Today we are going to look at how to install Microsoft SQL Server 2008 Enterprise in a standalone machine. This tutorial is useful if you want to install the server in your personal machine in order to learn SQL.


Step 1: Run Setup the setup.exe file inside the SQL Server parent directory.

Figure 1: setup.exe


Step 2: In SQL Server Installation Centre select Installation then New SQL Server stand-alone installation or add features to as existing installation.

Figure 2: SQL Server Installation Centre


This will bring the Setup Support Rules, which will check your system against 6 rules. Should any of the rules fail; the installation will not proceed until the causative issue is resolved.


Figure 3: Setup Support Rules


Click OK to proceed to the next step, Product Key. Here you can enter the product key or specify whether you want the Enterprise Evaluation, which is valid for 180 days. When you are done click Next.

Figure 4: Product Key


Read and accept the Licence Terms and click Next.

Figure 5: Licence Terms


In Setup Support Files, click Install and wait for the actions to complete.

Figure 6: Setup Support Files


The next step is the Setup Support Rules. Some warnings may be generated, but ignore them for now. If the system passes them click Next.

Figure 7: Setup Support Rules


The Feature Selection window allows you to specify which features you want to install. Check the associated boxes and click Next.

Figure 8: Feature Selection


In the Instance Configuration window select Default instance, then click Next.

Figure 9: Instance Configuration

The Disk Space Requirements displays the space requirements for the selected features. If your systems meet them then you can proceed Next >.

Figure 10: Disk Space Requirements


In the Server Configuration dialog window, under Service Accounts change the Account Name to NT AUTHORITY\SYSTEM then click Next.

Figure 11: Server Configuration


In Database Engine Configuration leave the Authentication Mode at Windows authentication mode. Also click at Add Current User and proceed Next >.

Figure 12: Database Engine Configuration


In Analysis Services Configuration click Add Current User to give the current user administrative access to Analysis Services. Click Next >.

Figure 13: Analysis Services Configuration

In Reporting Services Configuration leave the selection at Install the native mode default configuration.

Figure 14: Reporting Services Configuration


Under Error and Usage Reporting leave the current checkboxes cleared and click Next.

Figure 15: Error and Usage Reporting


The Installation Rules dialog window is similar to the other rules you have passed in the previous steps. In case of no failed rules or warnings proceed to the next step.

Figure 16: Installation Rules


The Ready to Install window shows the summary of which SQL Server’s features will be installed. Click Install and it will display the Installation Progress.

Figure 17: Ready to Install

Figure 18: Installation Progress


After all features have been installed successfully, the Installation Progress window will display their status. Click Next.

Figure 19: Installation Progress


The SQL Server 2008 setup is now Complete. Close the Setup window and you are good to go!

Figure 20: Complete



Leave A Comment