3.3 Install a New Instance of SQL Server

NOTE:These procedures and displayed interface are specific to SQL Server 2014. Procedures and interface will vary based on the version of SQL Server you are using.

  1. Launch the Microsoft SQL Server installation file, setup.exe.

  2. In the SQL Server Installation page, click Installation.

  3. Select New SQL Server stand-alone installation or add features to an existing installation.

  4. In the Product Key page, enter your product key, then click Next.

  5. In the License Terms page, accept the license terms, then click Next.

  6. In the Product Updates page, include all Microsoft SQL Server product updates, then click Next.

    The Install Rules operation is run.

  7. If there are any errors, address them accordingly, then click Next.

  8. In the Setup Role page, select SQL Server Feature Installation and click Next.

  9. In the Feature Selection page, select the appropriate instance features and the location for the instance data and click Next.

    The Feature Rules operation is run. If there are any errors, address them accordingly.

  10. In the Instance Configuration page, specify a named instance and click Next.

  11. In the Server Configuration page, click the Collation tab.

  12. Click Customize.

  13. Click the Windows collation designator and sort order option.

  14. From the Collation designator drop-down menu, select an acceptable collation and settings for your locale.

    For example, in North America, an acceptable collation would be Latin1_General_100 with the Accent-sensitive check box selected.

    We recommend that you select a collation that aligns with the Windows locale of the server where the Engine is installed.

    For more information on collation and locales, refer to this Microsoft document:.

  15. Click OK.

  16. Click Next.

  17. In the Database Engine Configuration page, select the Mixed Mode (SQL Server authentication and Windows authentication) option, enter and confirm a SQL Server administrator password, then click Add Current User.

    Storage Manager does not support Windows authentication mode (also known as Integrated Security).

  18. Click Next.

  19. In the Ready to Install page, click Install.

  20. When the installation has completed, click Close to close the wizard.

  21. See Section 3.4, SQL Server Post Configuration Considerations or possible adjustments to the newly created SQL Server instance.