Difference between revisions of "VT3000 - Errors - Database Connection is Closed"
Jump to navigation
Jump to search
SupportAdmin (talk | contribs) |
SupportAdmin (talk | contribs) m (Text replacement - "https://www.linkedin.com/company/versacall-technologies-inc-/mycompany/" to "https://www.linkedin.com/company/versacall/") |
||
(4 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
=Overview= | {|style="background:transparent; color:black" border="0" height="230" align="center" valign="bottom" | ||
These instructions explain how to resolve the "Database Connection is Closed" error received when logging into VT3000. This error can be received in any of the VersaCall programs as they are all related to the same issue. | |+style="background:transparent| | ||
|-align="center" | |||
| | |||
|[[Image:CallUsBtn.png|Call Now 858-677-6766]] | |||
| | |||
|[[Image:SubmitTckBtn.png|link=https://www.versacall.com/customer-support/service-ticket]] | |||
| | |||
|[[Image:EmailUsBtn.png|link=mailto:[email protected]?Subject=Help%20Needed%20Wiki&body=Type%20Message%20Here]] | |||
|} | |||
<br> | |||
---- | |||
---- | |||
This error occurs because the VersaCall software cannot communicate with the SQL Server where the databases are stored. To fix this error we need to determine if the SQL Server instance is local or if we are communicating with a server on your network. | <br> | ||
[[File:GeneralHeader.png]] | |||
<br> | |||
=Requirements= | {|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | ||
|- | |||
'''1.''' The VT3000 Core Software installed. | |<big>'''Overview'''</big> | ||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
'''2.''' Access to the Computer/Server where the VersaCall | |valign="top" | | ||
|- | |||
'''3.''' Permission to Start | |These instructions explain how to resolve the "Database Connection is Closed" error received when logging into VT3000. This error can be received in any of the VersaCall programs as they are all related to the same issue. This error occurs because the VersaCall software cannot communicate with the SQL Server where the databases are stored. To fix this error we need to determine if the SQL Server instance is local or if we are communicating with a server on your network. | ||
|} | |||
|} | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Requirements'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
< | |valign="top" | | ||
{| class="wikitable mw-collapsible mw-collapsed" width="775px;" | |||
|- | |||
|style="text-align: center;" | '''See Requirements Here''' | |||
|- | |||
|'''1.''' The VT3000 Core Software installed and running on your system. | |||
< | |- | ||
|'''2.''' Physical or Remote Access to the Computer/Server where the VersaCall SQL Server Instance is running. | |||
|- | |||
''' | |'''3.''' Permission to Stop/Start a Windows Service on the Computer/Server where the SQL Server Instance is running. | ||
|} | |||
|} | |||
File: | |} | ||
< | <br> | ||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Error Message'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
< | |valign="top" | | ||
File: | |- | ||
< | |[[File:DBClosed1.png|center|503px]] | ||
|} | |||
|} | |||
''' | <br> | ||
---- | |||
---- | |||
File: | <br> | ||
< | [[File:InstructionHeader.png]] | ||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
= | |- | ||
|<big>'''Step 1.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
''' | |valign="top" | | ||
|- | |||
< | |Log in to Windows on the computer where SQL Server is installed - select Windows Explorer. | ||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:DBClosed10.png|center|100px]] | |||
|} | |||
|} | |||
File:DBClosed11.png | |} | ||
< | |} | ||
<br> | |||
---- | |||
'''3.''' Select Administrative Tools from the list of options. | <br> | ||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
File:DBClosed12.png | |<big>'''Step 2.'''</big> | ||
< | {|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | ||
|valign="top" | | |||
|- | |||
'''4.''' Select Services. | |In the address field type in "Control Panel" - hit the Enter key. | ||
{|style="margin:left;" | |||
|valign="top" | | |||
File:DBClosed13.png | {|class="wikitable" style="background:white; align:center;" | ||
< | |- | ||
|[[File:DBClosed11.png|center|338px]] | |||
|} | |||
'''5.''' Scroll down the list of service names until you see "SQL Server (SQLEXPRESS)" if the name of your instance is different you will see that instead of SQLEXPRESS. | |} | ||
|} | |||
|} | |||
File:DBClosed14.png | <br> | ||
< | ---- | ||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
'''6.''' The Status of the service will have nothing showing. This means the service is not running and we need to restart it. If | |- | ||
|<big>'''Step 3.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Select Administrative Tools from the list of options. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:DBClosed12.png|center|203px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 4.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Select Services. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:DBClosed13.png|center|118px]] | |||
|} | |||
= | |} | ||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
File: | {|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | ||
|- | |||
|<big>'''Step 5.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Scroll down the list of service names until you see "SQL Server (SQLEXPRESS)" if the name of your instance is different you will see that instead of SQLEXPRESS. | |||
{|style="margin:left;" | |||
< | |valign="top" | | ||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:DBClosed14.png|center|border530px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 6.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|The Status of the service will have nothing showing. This means the service is not running and we need to restart it. If your service shows as "Running" in status, please contact VersaCall Support. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:DBClosed15.png|center|530px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | ---- | ||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 7.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Click on the service so that it is highlighted - select "Start the service from the options to the left of the service names. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:DBClosed16.png|center|444px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | ---- | ||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
{|style="margin: | |- | ||
|<big>'''Step 8.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|A window will appear showing that the system is restarting the service with a progress bar. | |||
{|style="margin:left;" | |||
|valign="top" | | |valign="top" | | ||
{| class=" | {|class="wikitable" style="background:white; align:center;" | ||
|- | |||
|[[File:DBClosed17.png|center|380px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 9.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|The service status should now show as "Running" after the restarting service window goes away. | |||
{|style="margin:left;" | |||
|valign="top" | | |||
{|class="wikitable" style="background:white; align:center;" | |||
|- | |||
|[[File:DBClosed18.png|center|530px]] | |||
|} | |||
|} | |||
|} | |||
|} | |||
<br> | |||
---- | |||
<br> | |||
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;" | |||
|- | |||
|<big>'''Step 10.'''</big> | |||
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;" | |||
|valign="top" | | |||
|- | |||
|Return to the VT3000 web interface and log in. If you get the same error again contact VersaCall Support. | |||
|} | |||
|} | |||
<br> | |||
---- | |||
---- | |||
<br> | |||
{|style="margin:auto;" | |||
|+ | |||
[[File:RelatedHowTos.png|center]] | |||
|align="center" | | |||
{| class="wikitable mw-collapsible mw-collapsed" width="400px;" | |||
|- | |||
|style="text-align: center;" | '''Select a Guide Here''' | |||
|- | |- | ||
|[[VT3000 - Back Up Database - SQL Server|Backup VersaCall Databases using SQL Server]] | |[[VT3000 - Back Up Database - SQL Server|Backup VersaCall Databases using SQL Server]] | ||
Line 171: | Line 266: | ||
|[[VT3000 - Restore Database - VT3000 Core|Restore VersaCall Databases using VT3000]] | |[[VT3000 - Restore Database - VT3000 Core|Restore VersaCall Databases using VT3000]] | ||
|} | |} | ||
| | |} | ||
<br> | |||
---- | |||
<br> | |||
{|style="margin:auto;" | |||
|+ | |||
[[File:SearchHeader.png|center]] | |||
|align="center" | | |||
{|class="wikitable" | |||
|- | |- | ||
| | |<inputbox>type=search</inputbox> | ||
|} | |||
| | |||
|} | |} | ||
| | <br> | ||
| | ---- | ||
<br> | |||
[[File:VC Footer.png|center]] | |||
{|style="background:transparent; color:black" border="0" height="200" align="center" valign="bottom" cellpadding=10px cellspacing=10px | |||
|+style="background:transparent| | |||
|-align="center" | |||
| | |||
|[[File:LinkedIn.png|Follow Us On LinkedIn|link=https://www.linkedin.com/company/versacall/]] | |||
| | |||
|[[File:BlogIcon.png|View our Blog|link=https://www.versacall.com/blog/]] | |||
|} | |} | ||
<br> | |||
[[Category:External Software]] | [[Category:External Software]] | ||
[[Category:SQL Server]] | [[Category:SQL Server]] | ||
[[Category:Errors]] | [[Category:Errors]] | ||
[[Category:Database]] | [[Category:Database]] |
Latest revision as of 19:24, 20 April 2023
![]() |
![]() |
![]() |
Overview
|
Requirements
|
Error Message
|
Step 1.
|
Step 2.
|
Step 3.
|
Step 4.
|
Step 5.
|
Step 6.
|
Step 7.
|
Step 8.
|
Step 9.
|
Step 10.
|
|
![]() |
![]() |