SQL Server 2014 Installation Guide

[FelixBeta]

A simple and straightforward guide on how to install Microsoft SQL Server 2014 database and management tool on your server. I strongly recommend to avoid any lower versions such as 2005 or 2008/R2 due to their total obsolescence and compatibility issues on modern systems.

I'm using SQL 2014 Enterprise Edition, you can easily find it all over internet (prefer respected forums/torrents).

Additional information

As stated above - this is simple guide to install SQL Server 2014 to run your server for development. There are various settings that you might consider install or remove. Always learn specific to your needs information on the web or Microsoft website directly.

Example:
Enabling Client Tools and Client Tools Backwards Compatibility will help you connecting various applications to your server, such as different PHP versions.
Feel free to share your tips and tricks for SQL Server.

Step 1: Unpack your sql 2014 .iso to any folder and run setup.exe as Administrator. Select installation tab and click New SQL Server stand-alone installation.

Step 1 Image

Step 2: Don't mark option to check for updates and just click Next.

Step 2 Image

Step 3: Wait till it scans for requirements and click Next. if needed - install .NET Framework, but usually it don't ask.

Step 3 Image

Step 4: Select SQL Server Feature Installation and click Next.

Step 4 Image

Step 5: Select Database Engine Services, Analysis Services, Management Tools - Complete and click Next.

Step 5 Image

Step 6: As you are installing SQL Server on clean machine, just select Default Instance and leave ID default. Click Next.

Step 6 Image

Step 7: Select Automatic as Startup Type for all services and configure Collation if needed. Russian users may need to make cyrillic collation.

Step 7 Image

Step 8: Click Add Current User, it will automatically add system user in list. Then click Next.

Step 8 Image

Step 9: Select Mixed Mode and enter password that will be used for "sa" login. After this, click Add Current User, it will automatically add system user in list.

Step 9 Image

Step 10: Now just click Install and wait for installation complete.

Step 10 Image

Step 11: Once installation complete you can start SQL Management Tool and connect to your server via default credentials or using sa user with defined password.

Step 11 Image

 

[Antonio]

Please make a tutorial for setup emulator ( appserv all version ). Btw, thanks for this tutorial, sir