If you are planning to user Reporting Services then select an option “Install and Configure”.Ĭlick on “ Add Current User” to add Display Replay Controller Administrator. On the “ Analysis Services Configuration” click on “ Add Current User” to add Analysis Services Administrator. Specify the password for SA ( SQL Administrator) account.Ĭlick on Add Current User if you want to authorize current user as SQL Administrator else you can click on Add and select another user.

Windows Authentication Mode and SQL Server System Administrator (SA) account. This allows us to use dual authentication mechanism i.e. On the Database Engine Configuration window, we’ll select an option of Mixed mode. On the Server Configuration window click on next. On the “ Instance Configuration” window, we’ll select the default instance and continue. For this practical we selected all the features. Select list of features that you are planning to use. On the setup role window, select an option “ SQL Server feature Installation“. You can safely ignore the warning but not the errors. On the Setup Support Rule, please ensure that all the test passed. You can ignore the same and click on next to continue. If you are not connected to internet then you might see an error message. Product update window would recommend you to keep your Server updated with the latest updates and patches.

On the Product Key window, specify the SQL Server License key and then click on next to continue.Īccept the license term and then click on next. On the Setup support rules window, click on Ok. On the SQL Server Installation Center, click on Installation and then click on “ New SQL Server stand-alone installation or add features to an existing installation“. Run an executable to start the installation of SQL Server 2012. Steps to Install SQL Server 2012 on Windows Server 2012 R2ĭownload SQL Server executable and then copy it to the server on which you want to create the Database.

You can refer to this article, if you are planning to deploy Citrix XenApp, Citrix XenDesktop, VMWare vCenter Server, VMWare Horizon View 7, etc. I am not an expert in SQL Server therefore we’ll talk about the simple steps to install Microsoft SQL Server 2012, moreover I’ve installed all the features even if we are not using all of them. In this article, we’ll learn the steps to install Microsoft SQL Server 2012 on Windows Server 2012 R2. It is the most recommended and trusted database for all the critical applications. Microsoft SQL Server is the best database that almost all the Organizations are using to create databases.

Download sql server 2012 r2