SQL Server 2014 Installation illustration tutorial (with SQL Server 2014 downloads) _mssql

January 1, 2015, the beginning of the new year, should have done a good job to do something meaningful to span a year. As a result, old habits-before going to bed must toss the computer, say dry, to the new DELL computer installed virtual machine, download SQL Server 2014, install SQL Server 2014.

After the SQL Server 2014 installation is complete, unlike SQL Server 2008 R2, it provides a BIDS development tool, unlike SQL Server 2012, which provides a SSDT development tool, that is, the BI development tool (SSIS, SSRS, SSAS) is not after installing SQL SERVER 2014. A separate installation is required, and this content will be mentioned in another article.

The end of the article is the DELL new machine show.

Download Address

Everyone is interested, you can not go to search, in Baidu Cloud disk I share the English version of SQL SERVER 2014.

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

or to http://www.jb51.net/softs/221200.html.

installation process

The following procedures are installed on the virtual machine on the WINDOWS SERVER 2008 R2 version of the operating system, and generally my own computer except Office and common tools, all development tools must be on the virtual machine, because the cost of each upgrade tool is too high.

Double-click the setup installation.

New SQL Server ...

Evaluation version has a 180-day probation period, if you have Key words will be better.

Next.

Pre-installation inspection, although successful in this step, but the back has failed, the harm of reloading the. NET FRAMEWORK 3.5 SP1.

Next.

Next.

No SharePoint also can not play, so the default installation of the first.

All installed by default, although the BI only need to use SSIS, SSRS, SSAS but in order to successfully install or select all, anyway, the virtual machine space is sufficient.

Oddly, the previous installation check was passed, but there was an error here. If you do not see this error, continue to install on it.

Back to the WINDOWS SERVER 2008 R2 Management interface, add Features in item 3rd adds support for 3.5 SP1.

Check the first one on it, next, always the next step.

The process of waiting for installation.

When the installation is complete, reboot the computer.

Repeat the above steps after restarting the computer until the check is done.

My habit is to change the name of the default instance-this is BIWORK2014.

Account these are used by default, later need to configure the time to change.

Take a look at the default collation what is it? I am here because the operating system is the reason of English, so it is not Chinese, and notice here is ci,case insensitive, the case is not sensitive.

The Add current User is fine.

Ditto.

Configure everything to the last time you want to configure it separately, so this is only installed.

Add Current user.

Next.

Click Install.

In this virtual machine quickly, probably less than 30 minutes on the smooth installation completed, the previous installation of 2012, the slowest time to wait 2 hours, it seems this time the DELL is very good.

Start a look.

The default keyword color changed back to the previous 2008 feeling, 2012 of the font color is not good-looking, too ugly! It looks a lot more comfortable when you change it back.

Attention

After the SQL Server 2014 installation is complete, unlike SQL Server 2008 R2, it provides a BIDS development tool, unlike SQL Server 2012, which provides a SSDT development tool, that is, the BI development tool (SSIS, SSRS, SSAS) is not after installing SQL SERVER 2014. A separate installation is required, and this content will be mentioned in another article.

DELL Computer

Originally had a DELL CORE I5, 8G memory, installed a few virtual machine for several years, now completely is not run up. CORE i7,8g memory, 1T hard drive, WIN8.1 also without touch screen in domestic need 6600 RMB. If it is 16G memory, with a touch of words estimated to need 8000 RMB, and looking for a long time there is no 16G, even if there is really can not afford to buy. This DELL, CORE I7, 8G, 1T plus touch screen in the United States is 949 $, plus the tax is about 1100 $, the synthetic RMB is about 6600. The same price, get the things are completely different, and this section in the domestic DELL website, including JD, suning are not found. The problem is that this computer is really Made in China, shipped to the United States high configuration than the domestic low configuration is also cheaper, unable to spit the slot!

DELL Real Machine Show

Heat sink at the bottom, the two sides are no heat sink, the screen connection is also no slots, there is no optical drive, so very thin.

Win8.1 first use of the not very accustomed, may be just out of the Win8 pit, the Win8 impression is not very good. But this time at the beginning hesitated to put back the Win 7, and later still feel that should be determined to try new things. It turned out to be right, and Win 8.1 was pretty cool to use.

The Dell real-machine show, which is already the fourth Dell PC, is a loyal user of Dell. The previous DELL computer can tow two screens, three screens to work together is very cool. The new DELL can also drag two screens (USB to VGA) but the effect is not as good as the previous Dell, because the new Dell screen resolution of 1920 x 1080, but the other two screen resolution is not up to, the font becomes very fuzzy.

15.6 inch LED backlit touch Display with IPS and FHD resolution (1920 x 1080)

Continue to tease exhibition, reading, learning should still be the 2015 's main rhythm!

The new Year has come and the 2014 has passed! Do not summarize, do not look back, 2015 go forward!

Wish you all a New year! Happy New Year!