Install a New Instance of SQL Server

Installation procedures will vary based on your version of SQL Server. The following procedures are specific to Microsoft SQL Server 2022.

The following instructions assume you are installing a single instance of SQL Server on a Windows Server host with no Azure integration.

1. Double-click setup.exe from the Microsoft SQL Server ISO.

2. Click Installation on the SQL Server Installation Center page.

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

4. Complete the following procedures in the SQL Server Setup wizard:

   1. Edition: Select the SQL Server edition, enter the product key, and select the license option, then click Next.

   2. License Terms: Accept the license terms and click Next.

   3. Global Rules: View the results, then click Next.

   4. Microsoft Update: Click Use Microsoft Update to check for updates, then click Next.

   5. Install Rules: Review the results, then click Next.

   6. Azure Extension for SQL Server: Uncheck Azure Extension for SQL Server, then click Next.

   7. Feature Selection: Check Database Engine Services.

   

   8. Review the installation paths, then click Next.

      NOTE: For larger installations, consider installing the SQL Server instance on a separate volume by changing the Instance Root Directory path parameter.

   9. Feature Rules: Review the results then click Next.

   10. Instance Configuration - Select the appropriate instance type, modify the Instance ID if desired, then click Next.

   11. Server Configuration: Select the Collation tab, then click Customize.

       

       1. Select Windows collation designator and sort order in the Customize the SQL Server 2022 Database Collation dialog, then select your desired collation from the drop-down menu, preferably one that aligns with the Windows Server hosting the 24.3 Engine.
          

          If you are unsure which collation to use, select Latin1_General_100, which is a safe option for File Dynamics CEDM.

          NOTE: Select one of the *_100 or later collations, as these offer the best compatibility for advanced options such as Supplementary characters.

           

          Refer to the following Microsoft document for more information on collation and locales:
          https://learn.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support.

          IMPORTANT: 24.3 requires the use of a Windows collation. Legacy SQL collations are not supported.

       2. [Optional] Select Accent-sensitive and Supplementary characters.

       3. [Optional] Select options for Kana-sensitive, Width-sensitive, and Variation selector-sensitive if you understand their impact with specific Asian character sets.

       4. Deselect all other options.

       5. Select Windows Code Page (1252) for the Char/Varchar Storage Options.

          IMPORTANT: File Dynamics CEDM does not currently support the use of UTF-8 as a character storage option.

       6. Click OK to close the customization dialog, then click Next.

   12. Database Engine Configuration: Complete the following procedures in this panel:

       1. Select Mixed Mode (SQL Server authentication and Windows authentication).

       2. Enter a password for the sa account in the Enter password and Confirm password fields.

       3. Click Add Current User to add your current account to the SQL Server administrators list.

       

       4. Review your selections, then Click Next.

   13. Feature Configuration Roles: Review any messages, then click Next.

   14. Ready to Install: Perform a final review of all installation options, then click Install.

   15. Complete: Click Close once the installation is complete to exit the setup wizard.

5. From the Windows Start Menu launch SQL Server Configuration Manager.

   1. Expand SQL Server Network Configuration in the left-hand pane.

   2. Click Protocols for MSSQLSERVER (or the name of the database instance you chose earlier).
      

   3. Right-click TCP/IP and select Properties.

   4. Click the Protocol tab.

   5. Set the Enabled field to Yes.

   6. Set the Listen All field to Yes.

   7. Click the IP Addresses tab.

   8. Set the TCP Port field to 1433 under the IPAll heading at the bottom.
      

   9. Click OK.

   10. Close the SQL Server Configuration Manager.

6. Launch Windows Firewall with Advanced Security.

   1. Click Inbound Rulesfrom the left-hand column.

   2. Click New Rule from the Actions column.

   3. Select Port on the Rule Type page.
      

   4. Click Next.

   5. Enter 1433 in the Specific local ports field on the Protocol and Ports page, then click Next.

   6. Click Next on the Action page to accept the default setting.

   7. Click Next on the Profile page to accept the default settings.

   8. Specify a name (e.g., SQL Server) for the new inbound rule in the Name field on the Name page .

   9. Click Finish.