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. From the Microsoft SQL Server ISO, double-click 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.

    If there are any errors, address them accordingly.

  7. Click Next.

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

  9. In the Feature Selection page, select the following check boxes:

    • Database Engine Services

    • Management Tools – Basic

    • Management Tools – Complete

  10. Click Next.

    The Feature Rules operation is run.

  11. When the operation has completed, click Next.

  12. In the Instance Configuration page, specify a named instance, then click Next.

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

  14. On the Service Accounts tab of the Server Configuration page, accept the service account configurations, then click the Collation tab.

  15. Click Customize.

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

  17. From the 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:http://technet.microsoft.com/en-us/library/ms175194%28v=sql.105%29.aspx.

  18. Click OK.

  19. Click Next.

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

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

  21. Click Next.

  22. Review the data directories that are to be created, then click Next.

    For best performance, the data directories should be located on a dedicated drive or drive array. For other best performance tips, refer to:http://condrey.co/support/bp.

  23. Click Next.

  24. Click Install.

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