SQL 2017 Setup

<< Click to Display Table of Contents >>

Navigation:  Using CloudNine LAW > Administrating CloudNine™ LAW > Database Installation and Configuration >

SQL 2017 Setup

This section describes an example of a known, working setup of SQL Server 2017.

 

Installation Steps

InfoIconStep 1: Install SQL Server 2017

SQL Server 2017 with an installation of Microsoft SQL Server Management Studio 17.

1.Download the installer file for SQL Server 2017 from the Microsoft website.

2.Run the installation file. The SQL Server 2017 installation window opens.

sql2017selectaninstallationtype_zoom50

3.Select Custom then follow prompts to continue.

4.Specify SQL Server media download target location will open in a new window.  Browse to the location that you would like to save your SQL files.

  sql2017specifysqlservermediadownloadtargetlocation_zoom50

5.After setting the installation path, then select Install.

6. In SQL Server Installation Setup dialog box select the Installation tab.

sql2017sqlserverinstallationcenter_zoom50

7.  Select Install SQL Server Management Tools to download and install SQL Server Management Studio 17.6+.

8.  Select New SQL Server Standalone installation or add features to an existing installation.

9. The SQL Server 2017 Setup window with License Terms will open next.

    sql2017licenseterms_zoom50

10.  If you accept the license terms then select Next.

11. The SQL Server 2017 Setup: Feature Selection window will open in a new window.

sql2017featureselection_zoom50

Note

For CloudNine™ LAW, Database Engine Services and Client Tools Connectivity are required.  Please refer to your SQL database administrator for other features that you may need.

12.  Select or deselect options accordingly to your SQL database administrator's guidelines, then select Next.

13.  The Instance Configuration window will open. Select Named instance, if you would like to change the instance name.  The default is SQLExpress.

sql2017instanceconfiguration_zoom50

14.  Select Next after making any necessary changes.

15. The SQL Server 2017 Setup: Server Configuration window will open.  The services will vary depending on options chosen during Feature Selection.

  sql2017serverconfigurationii_zoom50

16.  SQL Server Browser service, under Startup Type, needs to be set to Automatic.

17.  Leave the password blank.  

18.  Click Next.

19.  In Database Engine Configuration dialog box, select Mixed Mode (SQL Server authentication and Windows authentication).

sql2017databaseengineconfiguration_zoom50

20.  In the Enter password and Confirm password fields, type the SQL System administrator password you want to use. Recommended: write the password down in a secure location.

21.  Under Specify SQL Server administrators, click Add Current User. Add other users as necessary, and then click Next.

22.  When the installation is complete the Complete window will open.

23.  Select Close.

InfoIconStep 2: Add SQL use Account for LAW

1. Start SQL Server Management Studio. This is located in Windows>Microsoft SQL Server Tools 17> Microsoft SQL Server Management Studio 17.

2. Login to the new SQL Server instance.

3. Expand Security, right click Logins, and then click New User.

4. In Login name type LAW_User.

5. Select SQL Server authentication.

6. In the Password and Confirm password fields type (Contact Technical support for password assistance.).

7. Deselect Enforce password expiration, Enforce password policy, and User must change password at next login.

8. In the left panel of the dialog box, click Select Server Roles and then select dbcreator.

9. Click OK.

10. Close Microsoft SQL Management Studio.

 

Important

You can use a custom login and password for SQL Server Authentication.

 

InfoIconStep 3: Add SQL Instance Name to LAW

1.On the File menu click New Case.

 Or

    On the main form toolbar click New Case.

2.The Select Database Engine dialog box appears.

selectdatabaseengine7.1_zoom50

3.  Select SQL Server/ SQL Express

4.  Click OK.

5.  New Case - Properties opens in a new window.

  caseproperties_zoom50

6.  Type the SQL instance name and select an authentication mode for the new case.

 

Note

If you are installing a full version of SQL, then you would only have the name of your SQL Instance in the screenshot above.  It would not include\SQLExpress.

 

7.  Continue the case creation process Creating a New Case.