Difference between revisions of "VT3000 - Errors - Database Connection is Closed"

From Versacall Support
Jump to navigation Jump to search
Line 1: Line 1:
{|style="margin:left;"
{|style="margin:auto;"
|valign="top" |
|valign="top" |
{|class="wikitable" style="background:#eaf3ff;"
{|class="wikitable" style="background:#eaf3ff; width:800px;"
|-
|-
!style="text-align: left;"|<big>'''Overview'''</big>
!style="text-align: left;"|<big>'''Overview'''</big>
Line 8: Line 8:
|}
|}
|}
|}
{|style="margin:left;"
{|style="margin:auto;"
|valign="top" |
|valign="top" |
{|class="wikitable" style="background:#eaf3ff;"
{|class="wikitable" style="background:#eaf3ff; width:800px;"
|-
|-
!style="text-align: left;"|<big>'''Error Message'''</big>
!style="text-align: left;"|<big>'''Error Message'''</big>
|-
|-
|[[File:DBClosed1.png]]
|[[File:DBClosed1.png|center|503px]]
|}
|}
|}
|}
{|style="margin:left;"
{|style="margin:auto;"
|valign="top" |
|valign="top" |
{|class="wikitable mw-collapsible mw-collapsed" style="background:#eaf3ff; width: 800px;"
{|class="wikitable mw-collapsible mw-collapsed" style="background:#eaf3ff; width: 800px;"
Line 24: Line 24:
|'''1.'''  The VT3000 Core Software installed and running on your system.
|'''1.'''  The VT3000 Core Software installed and running on your system.
|-
|-
|'''2.'''  Access to the Computer/Server where the VersaCall SQL Server Instance is running.
|'''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.
|'''3.'''  Permission to Stop/Start a Windows Service on the Computer/Server where the SQL Server Instance is running.
|}
|}
 
|}
=Instructions - SQL Location and Login Information=
<br>
To complete the steps in this section you must be logged on to the computer/server hosting the VersaCall software.
=<big>'''Instructions'''</big>=
 
<br>
'''1.''' Using Windows Explorer, navigate to the following location.
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;"
 
|-
<gallery widths=112 heights=112>
|<big>'''Step 1.'''</big>  
File:DBClosed2.png
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;"
File:DBClosed3.png
|valign="top" |
File:DBClosed4.png
|-
File:DBClosed5.png
|Log in to Windows on the computer where SQL Server is installed - select Windows Explorer.
File:DBClosed6.png
{|style="margin:left;"
</gallery>
|valign="top" |
 
{|class="wikitable" style="background:white; align:center;"
 
|-
'''2.''' Click once on the "DatabaseRegistry.xml" file so that it is highlighted.
|[[File:DBClosed10.png|center|100px]]
 
|}
<gallery widths=112 heights=112>
|}
File:DBClosed7.png
|}
</gallery>
|}
 
<br>
 
----
'''3.''' Right click on the "DatabaseRegistry.xml" icon - select File - Open With - select Notepad.
<br>
 
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;"
<gallery widths=536 heights=189>
|-
File:DBClosed8.png
|<big>'''Step 2.'''</big>  
</gallery>
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;"
 
|valign="top" |
 
|-
'''4.''' At the top of the document you will see "Address" in the text. If the text reads as "127.0.0.1\SQLEXPRESS" or another name (has to show 127.0.0.1 to be local), proceed to the next section. If your address begins with anything other than "127.0.0.1" it means your databases are stored on a server on your network. You will need to contact your IT department. They will be able to determine if the server is running or not and if your username and password are still valid. In many cases the passwords have been changed, see the "Instructions - Network Database" section below.
|In the address field type in "Control Panel" - hit the Enter key.
 
{|style="margin:left;"
<gallery widths=446 heights=268>
|valign="top" |
File:DBClosed9.png
{|class="wikitable" style="background:white; align:center;"
</gallery>
|-
 
|[[File:DBClosed11.png|center|338px]]
 
|}
=Instructions - Local Database=
|}
Use these instructions if your Address began with 127.0.0.1.
|}
 
|}
'''1.''' Open Windows Explorer.
<br>
 
----
<gallery widths=100 heights=84>
<br>
File:DBClosed10.png
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;"
</gallery>
|-
 
|<big>'''Step 3.'''</big>
 
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;"
'''2.''' In the address field type in "Control Panel" - hit the Enter key.
|valign="top" |
 
|-
<gallery widths=338 heights=117>
|Select Administrative Tools from the list of options.
File:DBClosed11.png
{|style="margin:left;"
</gallery>
|valign="top" |
 
{|class="wikitable" style="background:white; align:center;"
 
|-
'''3.''' Select Administrative Tools from the list of options.
|[[File:DBClosed12.png|center|203px]]
 
|}
<gallery widths=203 heights=53>
|}
File:DBClosed12.png
|}
</gallery>
|}
 
<br>
 
----
'''4.''' Select Services.
<br>
 
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;"
<gallery widths=118 heights=122>
|-
File:DBClosed13.png
|<big>'''Step 4.'''</big>
</gallery>
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;"
 
|valign="top" |
 
|-
'''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.
|Select Services.
 
{|style="margin:left;"
<gallery widths=530 heights=58>
|valign="top" |
File:DBClosed14.png
{|class="wikitable" style="background:white; align:center;"
</gallery>
|-
 
|[[File:DBClosed13.png|center|118px]]
 
|}
'''6.''' The Status of the service will have nothing showing. This means the service is not running and we need to restart it. If you service shows as "Running" in the status, please contact VersaCall Support.
|}
 
|}
<gallery widths=530 heights=58>
|}
File:DBClosed15.png
<br>
</gallery>
----
 
<br>
 
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;"
'''7.''' Click on the service so that it is highlighted - select "Start the service from the options to the left of the service names.
|-
 
|<big>'''Step 5.'''</big>
<gallery widths=444 heights=92>
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;"
File:DBClosed16.png
|valign="top" |
</gallery>
|-
 
|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;"
'''8.''' A window will appear showing that the system is restarting the service with a progress bar.
|valign="top" |
 
{|class="wikitable" style="background:white; align:center;"
<gallery widths=380 heights=177>
|-
File:DBClosed17.png
|[[File:DBClosed14.png|center|border530px]]
</gallery>
|}
 
|}
 
|}
'''9.''' The service status should now show as "Running" after the restarting service window goes away.
|}
 
<br>
<gallery widths=530 heights=58>
----
File:DBClosed18.png
<br>
</gallery>
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;"
 
|-
 
|<big>'''Step 6.'''</big>
'''10.''' Return to the VT3000 web interface and log in. If you get the same error again contact VersaCall Support.
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;"
 
|valign="top" |
 
|-
=Instructions - Network Database=
|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.
If your IT department told you that the password and/or username has changed, follow the instructions below. If there is another reason for the error, please contact VersaCall Support for assistance.
{|style="margin:left;"
 
|valign="top" |
'''1.''' With the "DatabaseRegistry.xml" file open, go the the "Password" line. Change the password that is showing to the password that your IT department provided to you.
{|class="wikitable" style="background:white; align:center;"
 
|-
<gallery widths=446 heights=268>
|[[File:DBClosed15.png|center|530px]]
File:DBClosed19.png
|}
</gallery>
|}
 
|}
 
|}
'''2.''' Repeat this step for all of the databases you see in the XML file. Once all the passwords have been updated select File - Save.
<br>
 
----
<gallery widths=230 heights=167>
<br>
File:DBClosed20.png
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;"
</gallery>
|-
 
|<big>'''Step 7.'''</big>
 
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;"
'''3.''' Close the notepad window and all other associated windows. Open the VT3000 web interface and log in. If you get the same error again contact VersaCall Support for further assistance.
|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;"
|-
|<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" |
{|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; background:#eaf3ff; border:1px solid #2a4b8d"
{|style="margin: auto; background:#eaf3ff; border:1px solid #2a4b8d"
|valign="top" |
|valign="top" |
Line 190: Line 251:
             </inputbox>
             </inputbox>
|}
|}
 
<br>
 
[[Category:External Software]]
[[Category:External Software]]
[[Category:SQL Server]]
[[Category:SQL Server]]
[[Category:Errors]]
[[Category:Errors]]
[[Category:Database]]
[[Category:Database]]

Revision as of 22:18, 9 February 2022

Overview
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.
Error Message
DBClosed1.png
Requirements
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.


Instructions


Step 1.
Log in to Windows on the computer where SQL Server is installed - select Windows Explorer.
DBClosed10.png



Step 2.
In the address field type in "Control Panel" - hit the Enter key.
DBClosed11.png



Step 3.
Select Administrative Tools from the list of options.
DBClosed12.png



Step 4.
Select Services.
DBClosed13.png



Step 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.
border530px



Step 6.
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.
DBClosed15.png



Step 7.
Click on the service so that it is highlighted - select "Start the service from the options to the left of the service names.
DBClosed16.png



Step 8.
A window will appear showing that the system is restarting the service with a progress bar.
DBClosed17.png



Step 9.
The service status should now show as "Running" after the restarting service window goes away.
DBClosed18.png



Step 10.
Return to the VT3000 web interface and log in. If you get the same error again contact VersaCall Support.



Related - Step by Step Guides
Backup VersaCall Databases using SQL Server
Update VersaCall Databases using SQL Server
How to Script an SQL Database to an Earlier Version of SQL Server
Backup VersaCall Databases using VT3000 - Download Files
Backup VersaCall Databases using VT3000 - Make a Local Backup
Backup VersaCall Databases using VT3000 - Send the Backup to VersaCall
Update VersaCall Databases using VT3000
Restore VersaCall Databases using VT3000
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_-_Errors_-_Database_Connection_is_Closed&oldid=7217"