In this article, we’ll walk you through the step-by-step process of installing SQL Server 2014 and configure the initial application settings during installation.
For a full installation, you will need:
– Download the original SQL Server 2014 installer from our website.
– A licensed product key for SQL Server 2014, which you can purchase from our store for only 19.9 €, with instant delivery to your email!
1) Open the ISO file you downloaded earlier.
2) Run the “setup.exe” file as an administrator and wait for the installer to open.
3) In the opened program, go to the “Installation” section.
4) Then, click on “New SQL Server stand-alone installation or add features to an existing installation.”
5) Click “Next” without selecting any checkboxes. The updates will begin installing.
Once the installation is complete, click “Next.”
6) Leave the default option selected: “Perform a new installation of SQL Server 2014.”
7) Next, select “Evaluation.” If you have already purchased a product key from our store, enter it in the “Enter the product key” field.
8) Accept the license terms by checking the “I accept the license terms” box, then click “Next.”
9) Select “SQL Server Feature Installation” and click “Next.”
10) Check four options: “Database Engine Services,” “SQL Server Replication,” “Full-Text and Semantic Extractions…,” and “Reporting Services – Native,” then click “Next.”
11) Select “Default instance” and click “Next.”
12) In this window, you can set the startup type for any service. You can choose to set it to automatic, manual, or disable it entirely if the service is not needed for your tasks. In our example, we leave everything as default and click “Next.”
You can also go to the “Collation” menu — these are encoding settings, including sorting options and case sensitivity.
13) Proceed to the account settings for connecting to SQL Server 2014. You can choose either Windows authentication or mixed mode, which allows login via both Windows and SQL Server accounts. If you choose mixed mode, you will be prompted to create an SQL Server account.
In our example, we select “Windows authentication mode,” click “Add Current User,” and add it.
You can also go to the “Data Directories” tab. Here, you can specify locations for the root directory, system database directory, user database directory, user database log directory, and backup directory. It is recommended to set different locations on separate hard drives/partitions, with the data directory ideally on a separate hard drive.
The next tab is Filestream settings — this option allows files to be stored in the NTFS file system. It can be enabled or disabled based on your needs.
After configuring the settings, click “Next.”
14) Select “Install only” and click “Next.”
15) Finally, click “Install,” and the SQL Server 2014 installation will begin.
This process may take some time, depending on your PC’s performance.
16) If everything completes successfully, close the window.
17) After the SQL Server 2014 installation is finished, you can connect to the database server using SQL Server Management Studio (SSMS) 2014, which should have been installed along with SQL Server 2014.
Go to Windows search, type “sql,” select “SQL Server 2014 Management Studio,” and open it.
18) You can now log in with your account in SQL Server.
