www.remmis.com\sql2017_x64.exe www.remmis.com\sql2017_MS_x64.exe www.remmis.com\SQLData.zip www.remmis.com\DRESQLData.zip www.remmis.com\SQL2008R2_x64.exe www.remmis.com\sql2014_x64.exe www.remmis.com\sql2016_x64.exe Workstation Setup www.remmis.com\install.doc Server Setup 1. Install sql2017_x64.exe a. Make sure Browser is set to Automatic b. Set Authentication to Mixed Mode c. Set SA password to Remmis123 d. Deselect all but Database Services in choices window e. Continue finishing setup 2. Install sql2017_MS_x64.exe (Management Studio) a. Cancel Restart (only needed for Azure) 3. Open SQL Configuration Manager a. Click on SQL Server Network Config (usually second from bottom) b. Click on Protocols for SQLExpress c. Enable TCP/IP (right click) d. Right click on TCP/IP and select Properties e. Click IP Addresses Tab f. Set IPAll TCP port to 1433 and close properties window g. Set ALL TCP Dynamic Ports to 0(zero) h. Click on SQL Server Services (usually on top) i. Stop SQL Server Browser (right click) j. Stop SQL Server (SQLEXPRESS) (right click) k. Start SQL Server (SQLEXPRESS) (right click) l. Start SQL Server Browser (right click) 4. Turn of Firewall or Open Filewall Ports(see below) www.remmis.com\sql_ports_setup.docx Setup TCP and UDP rules (one rule for each) a. Click Start > Run and type firewall.cpl. The Windows Firewall window opens. b. Click on the “Advanced Settings” link on the left pane. The Windows Firewall with Advanced security window opens. c. Click on the “Inbound Rules” option. d. On the left pane, click on “New rule”. e. Under “Rule Type” select the option “Port” and click next. f. Select “TCP” or "UDP" and “specific local ports” options. g. Key in the port number. TCP 135, 1433-4022 UDP 1434 h. Click Next. i. Select the option “Allow the connection”. j. Click Next, do not change any option here and click Next again. k. Specify a name for this rule. RemmisTCP or RemmisUDP l. Click Finish. Open SQL Configuration Manager a. Stop SQL Server Browser (right click) b. Stop SQL Server (SQLEXPRESS) (right click) c. Start SQL Server (SQLEXPRESS) (right click) d. Start SQL Server Browser (right click) Error: ODBC Driver 17 for SQL Server Delete the following: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations Sample Connection String Driver={SQL Server};server=SERVERNAME\SQLExpress;uid=sa;pwd=Remmis123;Trusted_Connection=No;database=Remmis This connection string in found in r:\Remmis\Tables\SQL.loc (r = server share letter) Other: DigitalRE.ini [Installation Type] Closing Attorney [Path] c:\DigitalRE\ c:\DigitalRE\Tables\ c:\DigitalRE\Files\ C:\Program Files (x86)\DigitalRE\Templates c:\DigitalRE\Temp\ c:\DigitalRE\Setup\ [Message] Auto [Display] 16771022 13487565 Remmis.ini [Installation Type] Closing Attorney [Path] c:\Remmis\ c:\Remmis\tables\ c:\Remmis\files\ C:\Program Files\Close IT Plus\templates\ c:\Remmis\temp\ c:\Remmis\controls\ c:\Remmis\setup\ c:\Remmis\files\ [Message] Auto [RelCode] False [BC] [LastCltNo]