How to Install Microsoft SQL Server


Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network.


.Net Framework

.NET 3.5 SP1 is a requirement for SQL Server 2014 when you select Database Engine, Reporting Services, Master Data Services, Data Quality Services, Replication, or SQL Server Management Studio, and it is no longer installed by SQL Server Setup. 

-If you run Setup and you do not have .NET 3.5 SP1, SQL Server Setup requires you to download and install .NET 3.5 SP1 before you can continue with the SQL Server installation. (Install .NET 3.5 SP1 from Microsoft .NET Framework 3.5 Service Pack 1.) The error message includes a link to the download center, or you can download .NET 3.5 SP1 from Windows Update. To avoid interruption during SQL Server Setup, you can download and install .NET 3.5 SP1 before you run SQL Server Setup.

-If you run Setup on a computer with Windows Server 2008 R2 SP1 or Windows 8, you must enable .NET Framework 3.5 SP1 before you install SQL Server 2014.

Windows PowerShell

SQL Server 2014 does not install or enable Windows PowerShell 2.0; however Windows PowerShell 2.0 is an installation prerequisite for Database Engine components and SQL Server Management Studio. If Setup reports that Windows PowerShell 2.0 is not present, you can install or enable it by following the instructions on the Windows Management Framework page.

Install SQL Server 2014 on Windows

Video Tutorial


1. Double click on setup.exe file. Choose the Installation section in order to start the installation.

2. Enter the product key and click Next:

3. Accept the license term in order to continue.

4. Click check box in order to get updates.

5. Choose the first option in order to install SQL Server, and then select which features to install. We are going to choose our features manually in the next step. Click Next to continue

6. In this step, you can choose what features to install. It is highly recommend NOT to choose all the features on a production server if you don't need them. Choose only the features that you need or might need. Conversely you might want to select all using a development server in order to give you more flexibility in your development environment. Once you choose to use another feature you will be able to add it in production later on.

7. SQL Server allows you to install multiple instances of the same version or different versions of the server. If you choose a name that will help you in the future to recognize the instance which you are working with. Theoretically you can use any instance name that you want.

8. Security is important for every product and every business. By following simple best practices, you can avoid many security vulnerabilities. SQL Server works as a group of services in the background. In this step you can select the service accounts for the SQL Server actions. Each service in SQL Server represents a process or a set of processes to manage authentication of SQL Server operations with Windows. Each service can be configured to use its own service account. For more information you can read this article. 

SQL Server supports several collations. A collation encodes the rules governing the proper use of characters for either a language, such as Hebrew or Polish, or an alphabet, such as Latin1_General (the Latin alphabet used by western European languages). Typically, you should choose a SQL Server collation that supports most languages commonly used by users at your organization.

9. SQL Server can operate in one of two security (authentication) modes: (a) Windows Authentication mode which allowed a user to connect through an operating system user account. or (b) Mixed Mode which allowed users to connect to an instance of SQL Server using either Windows Authentication or SQL Server Authentication.

10. An instance of Analysis Services is a copy of the msmdsrv.exe executable that runs as an operating system service. Each instance is fully independent of other instances on the same server, having its own configuration settings, permissions, ports, startup accounts, file storage, and server mode properties. Server mode is a server property that determines which storage and memory architecture is used for that instance. In this step you can add windows users in order to give them administrative permissions for the Analysis Service. It is highly recommended to add the machine Administrator as well as other users who will need to manage this service. You can get more information in this link.

11. Choose if you want to install and configure the Reporting Service or just Install, which mean you will need to configure it later on.

12. Before you install and use the Microsoft SQL Server Distributed Replay feature, you should review the important security information in this link.

13. Installing the Microsoft SQL Server Distributed Replay features.

14. The SQL Server Installation program will show us a report of all our configuration (steps 1-19). Once you select Next, the installation will start.

15. Installing MSSQL Server 2014.

16. Installation Completed.

No comments:

Powered by Blogger.