Installing Microsoft SQL Server 2008

Posted on October 23rd, 2015

INSTALLING MICROSOFT SQL SERVER 2008 ENTERPRISE EDITION ON A STANDALONE MACHINE

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 Reply