Jump to content

SQL Server 2014 Installation Guide


Recommended Posts

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.

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



Link to comment
Share on other sites

  • 3 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...