Difference between revisions of "VT3000 - Install - SQL Server 2008 - 2016"

From Versacall Support
Jump to navigation Jump to search
Line 1: Line 1:
=Overview=
{|style="margin:left;"
The installation of SQL Server Express 2008 to 2016 is slightly different from newer versions.
|valign="top" |
 
{|class="wikitable" style="background:#eaf3ff;"
 
|-
=Requirements=
!style="text-align: left;"|<big>'''Overview'''</big>
 
|-
'''1.''' Permission to download software.
|The installation of SQL Server Express 2008 to 2016 is slightly different from 2017 & newer versions.
 
|}
'''2.''' Permission to install software on the computer/server being used.
|}
 
{|style="margin:left;"
|valign="top" |
{|class="wikitable mw-collapsible mw-collapsed" style="background:#eaf3ff; width: 800px;"
!style="text-align: left;"|<big>'''Requirements'''</big>
|-
|'''1.''' A computer/server with at least 60 GB of hard drive space available.
|-
|'''2.'''  Permission to download software
|-
|'''3.''' Permission to install software on the computer/server being used.
|}


=Instructions=
=Instructions=

Revision as of 19:41, 7 September 2021

Overview
The installation of SQL Server Express 2008 to 2016 is slightly different from 2017 & newer versions.
Requirements
1. A computer/server with at least 60 GB of hard drive space available.
2. Permission to download software
3. Permission to install software on the computer/server being used.

Instructions

The steps below are shown on a SQL Server Express 2008 R2 system, but the instructions are the same for any installation of SQL Server Express 2012 or above. If you already have a full version of SQL Server installed on your network, skip to the Existing SQL Server Requirements section.


1. Download and install Microsoft SQL Server 2008 R2 RTM – Express with Management Tools - search the title on google - ensure you select the link to Microsoft. The link will look like the one in the screen shot below. You can use later versions (2012, 2014 or 2016) of SQL Server, but you must install the version “with Management Tools”.

  • 3164 16.png
  • 3164 17.png


2. Select Continue on the Microsoft page.

  • 3164 18.png


3. Select to register if you want or select No - select the Next button.

  • 3164 19.png


4. Select SQLEXPRWT_x64_ENU.exe for a 64 bit operating system. VersaCall VT3000 software is only compatible with 64-bit operating systems. Select the Next button.

  • 3164 20.png


5. Select Save from the "Run or Save" menu.

  • 3164 21.png


6. The download should save to your Downloads folder - navigate the Downloads folder - right click on the "SQLEXPRWT" file - select Run As Administrator.

  • 3164 22.png
  • 3164 23.png


7. Wait until the software has fully extracted.

  • 3164 24.png


8. Select "New Installation or add features to an existing installation".

  • 3164 25.png


9. Select to Accept the license agreement - select the Next button.

  • 3164 26.png


10. Select all Features shown in the image below - select Next button.

  • 3164 27.png


11. Leave the Named Instance and Instance ID unchanged – select the Next button.

  • 3164 28.png


12. Select Automatic for the SQL Server Browser - select the Next button.

  • 3164 29.png


13. Select Mixed Mode for Authentication Mode - enter SQLServer123 for the password – select the Next button.

  • 3164 30.png


14. Error Reporting can be unchecked – select the Next button.


15. When installation is complete - select the Close button - close all open windows.

  • 3164 31.png


16. Select the Windows Start button – select All Programs - Windows 10 users go to the next step.

  • Windows 7

  • Windows 8 & UP

  • 3164 32.png


17. Select Microsoft SQL Server 2008 R2 - select Configuration Tools - select SQL Server Configuration Manager.

  • 3164 33.png


19. Expand SQL Server Network Configuration – select Protocols for SQLEXPRESS.

  • 3164 34.png


20. Change each protocol - right click on the protocol name - select Enable.

  • 3164 35.png
  • 3164 36.png


21. Select SQL Server Services.

  • 3164 37.png


22. Restart SQL Server and SQL Server Browser - right click on the service - select Restart.

  • 3164 38.png


23. Close all open windows - Click Here for Software Installation Guide.


Related - Step by Step Guides
Add VersaCall Databases to an Existing SQL Server Instance
Guide for Installing SQL Server 2017 & Above
Additional Help
Submit a Ticket - https://www.versacall.com/customer-support/service-ticket
Training Videos - https://www.versacall.com/training

 
Retrieved from "http://support.versacall.com/index.php?title=VT3000_-_Install_-_SQL_Server_2008_-_2016&oldid=6451"