SQL 2017 Setup

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.

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.

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

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

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.

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.

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.

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.

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).

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.

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.

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.

3.  Select SQL Server/ SQL Express

4.  Click OK.

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

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

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