SQL Considerations for LAW

<< Click to Display Table of Contents >>

Navigation:  Detailed Checklist > Database Installation and Configuration >

SQL Considerations for LAW

The Answer Center provides the minimum and recommended versions of SQL for use with your specific version of CloudNine™ LAW. It is recommended to consult the before installing SQL.

Suggestions for configuring your instance of SQL for use with LAW

 

Suggestions for SQL maintenance

Enable Named Pipes Protocol

1.Open SQL Server Configuration Manager

2.Under SQL Server Network Configuration > Protocols for MSSQLSERVER

3.Find Named Pipes, right click and enable.

4.Restart the SQL service.

Opening Windows Firewall Ports for SQL

Enable TCP/IP

1.Open SQL Server Configuration Manager.

2.In the left pane, expand SQL Server Network Configuration.

3.Click Protocols for <SQL Server instance name>.

4.In the right pane, right-click TCP/IP and select Enable.

5.A warning dialog displays with the message Any changes made will be saved; however, they will not take effect until the service is stopped and restarted. Click OK.

6.In the left pane, click SQL Server Services.

7.In the right pane, right-click SQL Server <SQL Server instance name> and select Restart.

Open port 1433

1.Open Windows Defender Firewall with Advanced Security.

2.Click Inbound Rules.

3.Under Actions, click New Rule.

4.Select Port and click Next.

5.Select TCP.

6.Select Specific local ports, enter 1433, and click Next.

7.Select Allow connection and click Next.

8.Accept all defaults Domain and Private and click Next.

9.Enter a Name for the rule.

10.(Optional) Enter a Description for the rule.

11.Click Finish.

Open port 1434

12.Open Windows Defender Firewall with Advanced Security.

13.Click Inbound Rules.

14.Under Actions, click New Rule.

15.Select Port and click Next.

16.Select UDP

17.Select Specific local ports, enter 1434, and click Next.

18.Select Allow connection and click Next.

19.Accept all defaults Domain and Private and click Next.

20.Enter a Name for the rule.

21.(Optional) Enter a Description for the rule.

22.Click Finish.

Manually Add System Account into SQL with Full Access

Add the System/Network Account into SQL and with Full Read, Write and Modify access.

 

manualuser_zoom70Open SQL Management Studio, expand the Security folder and Right Click on Logins > “New Login”

 

 

 

 

 

 

 

 

 

 

manualadd02_zoom70

On the new login screen choose ‘Search’

 

 

 

 

 

 

 

manualuser3_zoom70

On the search screen ensure you are searching for the Entire Directory, type in the username, check Names, then choose ok.

 

 

 

 

 

 

 

 

 

 

manualuser4_zoom60After you click OK, Click Server Roles and check ‘sysadmin’ then ok

 

 

 

Use this method when using SQL Server for other applications in addition to CloudNine™ LAW. This option helps to prevent users of SQL Server from accessing and modifying any other existing databases yet provides additional security for your databases. To create a custom SQL user account: · Setup a SQL Server user with create/modify permissions. · The username and password will be referenced when accessing SQL (Database management, NIST storage, File Type Database Management, and for case list storage). User: (Custom SQL login following SQL Guidelines) Pwd: (Custom password following SQL Guidelines) When using this option, the security mode for SQL Server must be set to SQL Server and Windows for mixed-mode authentication.