Installing Microsoft SQL Server 2008
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