How to Install a SQL Server Database

Don't forget to read the previous article, namely> Beginner Programming Guide.

As I explained in the previous article, SQL Server Database is very widely used by large companies in the world, especially in Indonesia. Some of the big companies that I have worked with, they use Micorosoft's product database. For those of you who want to work in large companies, you must learn this SQL Server database. Because usually when applying to large companies you will be asked if you master the SQL Server Database? Therefore, on this JNM website, I try to provide a basis for this SQL Server material so that you can learn and develop it.

If you have read the Understanding SQL Server article, then you should already know that SQL Server has a paid version and a premium version. Here I only use the Free version, actually it's almost the same and hopefully the concept I provide can be of use to you.

Download SQL Server

Before you install this SQL Server database, you must have the master software from SQL Server itself. Where to download it? because there is a free version, you can download it directly on the microsoft website. Some of the tutorials that I provide use the SQL Server 2014 Express version. You can download it with KLIK LINK INI

To download, please select the language: ENGLISH then you can select the one in the image above, namely SQLEXPRADV_86 for 32bit, and 64 for 64bit (please adjust the type of bit on your computer)

How to Install SQL Server

If you have downloaded SQL Server 2014 Express you can install it directly, here's how:

Double click the SQL Server software that you downloaded

So, it will appear :

Select the one I gave the red mark, namely Newe SQL Server stand alone installation

Select I Accept the license term. then you can immediately click Next

If the image above appears, immediately click Next

 The image above has a Product update, it's okay, you can just click Next

 Click Next

At this stage must be considered

I chose the Default instance, this function is for you to connect to the Client Server, you just need to use the Computer Name of the server. If so, you can click Next

 Click Next Again

At this stage it is quite important too. I suggest you choose like the image above. Then enter the password according to your wishes.

Its function is that we will provide the System Administrator (sa) user on the SQL Server.

If you have clicked Next

 Click Next Again

 The picture above is the installation process. Please wait for the process. The image above is an installation in progress or loading.

If it appears as shown above, it means that the installation has been completed or has been successful.

How to Use SQL Server

If you have successfully installed SQL Server like the guide above

To use it you can search or click SQL Server 2014 Management Studio

 If you have found it, you can click SQL Server 2014 Management Studio

Please click Connect

If the image above appears, it means that you have successfully logged into SQL Server.

The sever I use is JAVANET001. that is the name of the computer that I use. It will certainly be different from the name of your computer.

This is the Step by step Guide on How to Install SQL Server Databases, hopefully it will be useful for you, after this you can create databases and tables using SQL Server in the next JNM article.

Apart from being a programming information medium, we also share articles related to Android trick tips.

Android Trick Tips article

Share on Facebook

Share on Twitter

Share on Google+

Share on LinkedIn

Subscribe to receive free email updates: