SQL Server 2008 Download & Installation Step by Step -
To install either 32-bit or 64-bit of the file you need to download the setup files. Here are the link you can refer directly to download these files from Microsoft official website.
Select the SQLEXPRADV_x86_ENU.exe option for 32-bit operating system and SQLEXPRADV_x64_ENU.exe for 64-bit operating system and click on the next button to download the file.
Installation Steps:
If you’re doing a fresh installation i.e. you’re installing SQL Server for the first time on your machine, below are the steps to begin with.
Step 1: Open explorer and you’ll see setup file as shown below.
Right click on the setup and run it as Administrator.
Step 2: SQL Server Installation Center.
Go to installation section, here you’ll find various options to install instance, add new features and upgrade your SQL Server. As we’re doing a fresh installation, we’ll select first option i.e. “New SQL Server stand-alone installation”.
Step 3: Setup Support Rules,
Here setup will perform a check to ensure whether you can proceed with the installation or not. If check fails at any step listed in the rules, you won’t be able to continue the installation.
Step 4: Editions and Product Key
Here it’ll ask you the type of SQL Server edition you want to install on your machine or on server. If you want express edition, no need to specify Product Key. Other edition like Enterprise, Standard, etc. requires Product Key. Click Next
Step 5: License Term
Click on “I accept the license terms” and click on Next.
Step 6: Setup Support Files.
At this step SQL Server Setup looked for some components required during installation. After successful check you’ll get Install button to proceed further. Click on the Install Button.
Step 7: Setup Support Rules
Again it’ll run the setup rules to identify problems that might occur during installation. If all checks get passed it is a good signal to proceed further. If any check fails, you won’t be able to proceed further with installation. If status is passed, click Next.
Step 8: Feature Selection.
Click Next and after this, all the steps are same as shown in above installation. After successful installation you’ll get the following window.
Now we’ve successfully installed SQL Server 2008 version on our machine. You can see the installed SQL Server services under SQL Server Configuration manager as shown below.
Hit Start button and type SSMS as shown below and it’ll open the SQL Server Management Studio.
Connect to your default instance name by entering you SYSTEM name or by just putting DOT (.) in server name box as shown below.
Conclusion
We’ve successfully installed SQL Server 2008 version on our machine. We have seen the steps involved in fresh installation and also what are the steps involved when we install another instance. In our next article, we’ll also see how to install named instance on any machine and we’ll also see articles on other SQL concepts. Till then, Keep Learning and keep sharing your feedback with toppercorps.
Step 1: Open explorer and you’ll see setup file as shown below.
Right click on the setup and run it as Administrator.
Step 2: SQL Server Installation Center.
Go to installation section, here you’ll find various options to install instance, add new features and upgrade your SQL Server. As we’re doing a fresh installation, we’ll select first option i.e. “New SQL Server stand-alone installation”.
Step 3: Setup Support Rules,
Here setup will perform a check to ensure whether you can proceed with the installation or not. If check fails at any step listed in the rules, you won’t be able to continue the installation.
Step 4: Editions and Product Key
Here it’ll ask you the type of SQL Server edition you want to install on your machine or on server. If you want express edition, no need to specify Product Key. Other edition like Enterprise, Standard, etc. requires Product Key. Click Next
Step 5: License Term
Click on “I accept the license terms” and click on Next.
Step 6: Setup Support Files.
At this step SQL Server Setup looked for some components required during installation. After successful check you’ll get Install button to proceed further. Click on the Install Button.
Step 7: Setup Support Rules
Again it’ll run the setup rules to identify problems that might occur during installation. If all checks get passed it is a good signal to proceed further. If any check fails, you won’t be able to proceed further with installation. If status is passed, click Next.
Step 8: Feature Selection.
Click Next and after this, all the steps are same as shown in above installation. After successful installation you’ll get the following window.
Now we’ve successfully installed SQL Server 2008 version on our machine. You can see the installed SQL Server services under SQL Server Configuration manager as shown below.
Hit Start button and type SSMS as shown below and it’ll open the SQL Server Management Studio.
Connect to your default instance name by entering you SYSTEM name or by just putting DOT (.) in server name box as shown below.
Conclusion
We’ve successfully installed SQL Server 2008 version on our machine. We have seen the steps involved in fresh installation and also what are the steps involved when we install another instance. In our next article, we’ll also see how to install named instance on any machine and we’ll also see articles on other SQL concepts. Till then, Keep Learning and keep sharing your feedback with toppercorps.
