SQL server 2014 installation illustration tutorial (including SQL SERVER 2014 download), 2014sql

SQL server 2014 installation illustration tutorial (including SQL SERVER 2014 download), 2014sql

In January 1, 2015, at the beginning of the new year, we should have done something meaningful for the next year. As a result, old habits-before you go to bed, you must take a look at the computer, just do it, install a VM for the new DELL Computer, download SQL server 2014, and Install SQL SERVER 2014.

After SQL server 2014 is installed, SQL server 2008 R2 does not provide a BIDS development tool, nor does SQL SERVER 2012 provide an SSDT development tool, that is, BI development tool (SSIS, SSRS, SSAS) does not exist after SQL SERVER 2014 is installed. You need to install it separately. This content will be mentioned in another article.

The last part of this article is the DELL new machine Sao Bao exhibition.

If you are interested, you do not need to search. I shared the English version of SQL SERVER 2014 on Baidu cloud disk.

SQL SERVER 2014 download link: http://pan.baidu.com/s/1c0zr8mW password: 9h6g

Or to http://www.bkjia.com/softs/221200.html

Installation Process

The following process is completed on the windows server 2008 R2 operating system on the VM. Generally, except for Office and common tools, all development tools must be on the VM, because the cost of each tool upgrade is too high.

Double-click setup.

New SQL Server...

The Evaluation version has a trial period of about 180 days. It is better if you have a Key.

Next step.

Check Before installation. Although this step is successful, the subsequent installation fails and the. net framework 3.5 SP1 is reinstalled.

Next step.

Next step.

No SharePoint is available, so the first method is installed by default.

All are installed by default. Although BI only needs to use SSIS, SSRS, and SSAS, you should select all for successful installation. The VM space is sufficient.

It is strange that the installation check is passed, but an error occurs here. If you do not see this error, you can continue to install it.

Return to the windows server 2008 R2 management interface, and Add Features in item 3rd to Add 3.5 SP1 support.

Select the first one. Next, continue to the next step.

Waiting for installation.

After the installation is complete, restart the computer.

After restarting the computer, repeat the above steps until the check passes.

My habit is to change the default Instance name-here is BIWORK2014.

All accounts use the default one. You can change it later when you need to configure it.

What is the default Collation? I am not Chinese because the operating system is in English, and note that CI, Case Insensitive, is Case Insensitive.

Add Current User.

Same as above.

All configurations are configured separately when you finally want to configure them, so only install them here.

Add current user.

Next step.

Click Install.

On this Vm, the installation was completed in less than 30 minutes. In the past, when 2012 was installed, the slowest time waited for two hours. It seems that this time DELL was awesome.

Start it.

The default keyword color is changed back to 2008. The font color of 2012 is really ugly! It looks a lot more comfortable this time.

Note:

After SQL server 2014 is installed, SQL server 2008 R2 does not provide a BIDS development tool, nor does SQL SERVER 2012 provide an SSDT development tool, that is, BI development tool (SSIS, SSRS, SSAS) does not exist after SQL SERVER 2014 is installed. You need to install it separately. This content will be mentioned in another article.

DELL Computer

Originally there was a dell core I5 with 8 GB memory. It had been installed with several virtual machines for several years and cannot be fully run now. CORE I7, 8 GB memory, 1 TB hard drive, WIN8.1 not equipped with Touch Screen in China requires around 6600 RMB. If the memory is 16 GB, it is estimated that it will take about 8000 RMB for a touch, and it has not been 16 GB for a long time. Even if there is one, it is really hard to afford it. The DELL, CORE I7, 8 GB, 1 TB touch screen is $949 in the United States, and the tax is about $1100. The synthetic RMB is about 6600. At the same price, what we get is completely different, and this DELL website in China, including JD and Suning, cannot be found. The problem is that this computer is a solid Made in China, and it is cheaper to ship it to the United States than the low configuration in China!

DELL real machine Exhibition

The cooling port is below, and there is no cooling port on both sides. There is no slot at the screen connection, and there is no optical drive between the left and right, so it is thin.

Win8.1 was not used to it at the beginning. It may be the reason why Win8 had been pitted, and it was not very good at Win8. But at first I hesitated to install Win 7, and later I thought I should try new things. Later, it was proved that the result was correct, and Win 8.1 was very helpful.

Sao Bao, DELL real machine exhibition, which is already the fourth DELL Computer, DELL's loyal user. A previous DELL Computer could drag two screens, and it was so nice to work on three screens together. Although this new DELL can also drag two screens (using a USB to VGA), the effect is not as good as that of the previous DELL, because the new DELL screen resolution reaches 1920x1080, but the resolution of the other two screens cannot keep up, the font becomes blurred.

15.6 inch LED backfill Touch Display with IPS and FHD resolution (1920x1080)

Continue the Sao Bao exhibition, read books, and learn the main rhythm of 2015!

The New Year has arrived, and the year 2014 has passed! Don't sum up, don't look back, 2015 move forward!

I wish you a better year! Happy New Year!