Follow

Microsoft SQL Server 2012 & 2014 Install Guide

Created by: Justin Johns
Created date:
Last Updated date:

Problem

The following are the minimal requirements for installing MS SQL Server 2012 & 2014 for use with AD software.

 

Resolution

  1. Run the SQL Server Installation Setup executable and wait for the SQL Server Installation Center window to appear.
  2. Choose the Installation tab and click New SQL Server stand-alone installation or add features to an existing installation.
  3. Enter your product key and click Next.
  4. Accept the License Terms, and click Next.
  5. On the Setup Role page, select the SQL Server Feature Installation option and click Next.
  6. On the Feature Selection page, check Database Engine Services, Management Tools – Basic, and Management Tools – Complete and click Next. (Note: You can also modify the directories, if desired.)
  7. On the Instance Configuration page, select either Default Instance or Named Instance and click Next. (Note: If using a Named Instance, be sure to remember the name.)
  8. On the Server Configuration page, open the Collation tab and ensure the Database Engine is set to SQL_Latin1_General_CP1_CI-AS and click Next. (Note: You may also change the Service Accounts, if desired.)
  9. On the Database Engine Configuration page, under the Server Configuration tab, select Mixed Mode, enter a password for the SQL system administrator (SA) account, add the domain "service account" as an administrator, and click Next. (Note: You can also modify the Data Directories, if desired.)
  10. At the Ready to Install page, confirm everything is correct and lick Install.
  11. Wait for the installation to complete and then close Setup.
  12. Open SQL Server Configuration Manager.
  13. In the left pane, expand SQL Server Network Configuration.
  14. Select the Protocols entry for your newly installed SQL instance.
  15. In the right pane, right-click Named Pipes and click Enable.
  16. In the left pane, select SQL Server Services.
  17. In the right pane, right-click the SQL Server service for your newly installed SQL instance and click Restart.

 

Notes

32-bit and Express versions of MSSQL are not supported.

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk