Install SQL Server

Install SQL

  1. Download Microsoft SQL 2008 R2 (Wave 5.0 & earlier) or Microsoft SQL 2017 (Wave 6.0, with ViewPoint HF 30 or higher, or Wave 7.0).  
    NOTE: SQL Server 2017 installation steps are very similar to SQL 2008R2, which is detailed below.  
     
  2. Double-click the install file. A 'User Account Control' dialog appears. Click 'Yes' on the dialog.

     
  3. A dialog may appear announcing that ".Net Framework 3.5" needs to be installed. If so, choose 'Download and install this feature." When finished, click Close.

     
  4. The SQL Server Installation Center appears. Click on the Planning category and then on the "System Configuration Checker" to verify there are no problems.

     
  5. If problems are found, resolve them. If no problems are found, click OK to close the configuration checker.

     
  6. Click on the Installation category.

     
  7. Click on New SQL Server stand-alone installation...

     
  8. The Install Wizard starts and a License Terms box appears. Click "I accept the license terms" and then click Next.

     
  9. The system installs support files.

     
  10. Next, Feature Selection appears. Leave all defaults in place and click Next.

     
  11. Next, Instance Configuration appears. Change the instance to the "Default Instance" setting. Click Next.
    THIS STEP IS THE MOST OFTEN MISSED. YOU MUST CHANGE TO THE DEFAULT INSTANCE.

     
  12. Next, Server Configuration appears. Click the "Use the same account for all SQL Server services" button. 
    NOTE: If required for security reasons, it is possible to run 'SQL Server Database Engine' as 'NT Authority\NETWORK SERVICE'.  This will require you to  create the 'C:\Program Files (x86)\Vertical Wave\Recording Archive Service' folder, before you install the RAS server, and grant FULL CONTROL to this folder to 'NT Authority\NETWORK SERVICE'.                   If you have questions, please contact Vertical Support and reference this article.
  13. Click the drop-down box for the Account name and choose NT AUTHORITY\SYSTEM. Click OK.

     
  14. Click Next to proceed.

     
  15. Next, the Database Engine Configuration appears. Under Authentication Mode, select Mixed Mode.

     
  16. Enter an SA password for the database (make sure to follow best practices for complex passwords). Make sure to record the password for later use.

     
  17. Click Next to proceed.
     
  18. Click Next to proceed past Error Reporting and start the install. 
     
  19. When the install completes, click Close.

     

Configure SQL for TCP/IP

  1.  Click Start and Choose SQL Server Configuration Manager (this may trigger a UAC dialog. Click Yes.)  
    SQL 2017 - Open Computer Management.  Under 'Services and Applications', expand SQL Server Configuration Manager, then you can follow the other screenshots as shown below.

  2. Click on SQL Server Network Configuration.

     
  3. Double-click on Protocols.

     
  4. Right-click on TCP/IP and choose Enable.


     
  5. Click on SQL Server Services.

     
  6. Right-click SQL Server and choose Restart. This will restart the SQL Server and apply the setting change.

     
  7. Close the Server Configuration Manager.