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

From Versacall Support
Jump to navigation Jump to search
(Created page with "=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 Vers...")
 
m (Text replacement - "https://www.linkedin.com/company/versacall-technologies-inc-/mycompany/" to "https://www.linkedin.com/company/versacall/")
 
(12 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"
=Error Message=
|
 
|[[Image:CallUsBtn.png|Call Now 858-677-6766]]
<gallery widths=93 heights=93>
|
File:3108_1.png
|[[Image:SubmitTckBtn.png|link=https://www.versacall.com/customer-support/service-ticket]]
</gallery>
|
 
|[[Image:EmailUsBtn.png|link=mailto:support@versacall.com?Subject=Help%20Needed%20Wiki&body=Type%20Message%20Here]]
=Explanation=
|}
 
<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.
----
 
----
=Instructions=
<br>
To complete the steps in this section you must be logged on to the computer/server hosting the VersaCall software.
[[File:GeneralHeader.png]]
 
<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=93 heights=93>
|<big>'''Overview'''</big>
File:3108_1.png
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;"
</gallery>
|valign="top" |
 
|-
 
|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.
'''2.''' Click once on the "DatabaseRegistry.xml" file so that it is highlighted.
|}
 
|}
<gallery widths=196 heights=60>
<br>
File:tele1.png
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;"
</gallery>
|-
 
|<big>'''Requirements'''</big>
 
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;"
'''3.''' Select File - Open With - select Notepad.
|valign="top" |
 
{| class="wikitable mw-collapsible mw-collapsed" width="775px;"
<gallery widths=196 heights=60>
|-
File:tele1.png
|style="text-align: center;" | '''See Requirements Here'''
</gallery>
|-
 
|'''1.''' The VT3000 Core Software installed and running on your system.
 
|-
'''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.
|'''2.''' Physical or Remote Access to the Computer/Server where the VersaCall SQL Server Instance is running.
 
|-
<gallery widths=285 heights=131>
|'''3.''' Permission to Stop/Start a Windows Service on the Computer/Server where the SQL Server Instance is running.
File:tele2.png
|}
</gallery>
|}
 
|}
 
<br>
=Instructions - Local Database=
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;"
Use these instructions if your Address began with 127.0.0.1.
|-
 
|<big>'''Error Message'''</big>
'''1.''' Open Windows Explorer.
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;"
 
|valign="top" |
<gallery widths=313 heights=250>
|-
File:3108_5.png
|[[File:DBClosed1.png|center|503px]]
</gallery>
|}
 
|}
 
<br>
'''2.''' In the address field type in "Control Panel" - hit the Enter key.
----
 
----
<gallery widths=543 heights=96>
<br>
File:3108_8.png
[[File:InstructionHeader.png]]
</gallery>
<br>
 
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;"
 
|-
'''3.''' Select Administrative Tools from the list of options.
|<big>'''Step 1.'''</big>
 
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;"
<gallery widths=543 heights=96>
|valign="top" |
File:3108_8.png
|-
</gallery>
|Log in to Windows on the computer where SQL Server is installed - select Windows Explorer.
 
{|style="margin:left;"
 
|valign="top" |
'''4.''' Select Services.
{|class="wikitable" style="background:white; align:center;"
 
|-
<gallery widths=543 heights=96>
|[[File:DBClosed10.png|center|100px]]
File:3108_8.png
|}
</gallery>
|}
 
|}
 
|}
'''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.
<br>
 
----
<gallery widths=543 heights=96>
<br>
File:3108_8.png
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;"
</gallery>
|-
 
|<big>'''Step 2.'''</big>  
 
{|style="margin:left; width: 800px; background:#F0F0F0; 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 you service shows as "Running" in the status, please contact VersaCall Support.
|valign="top" |
 
|-
<gallery widths=543 heights=96>
|In the address field type in "Control Panel" - hit the Enter key.
File:3108_8.png
{|style="margin:left;"
</gallery>
|valign="top" |
 
{|class="wikitable" style="background:white; align:center;"
 
|-
'''7.''' Click on the service so that it is highlighted - select "Start the service from the options to the left of the service names.
|[[File:DBClosed11.png|center|338px]]
 
|}
<gallery widths=543 heights=96>
|}
File:3108_8.png
|}
</gallery>
|}
 
<br>
 
----
'''8.''' The service status should now show as "Running".
<br>
 
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;"
<gallery widths=543 heights=96>
|-
File:3108_8.png
|<big>'''Step 3.'''</big>  
</gallery>
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;"
 
|valign="top" |
 
|-
'''9.''' Return to the VT3000 web interface and log in. If you get the same error again contact VersaCall Support.
|Select Administrative Tools from the list of options.
 
{|style="margin:left;"
 
|valign="top" |
=Instructions - Network Database=
{|class="wikitable" style="background:white; align:center;"
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.
|-
 
|[[File:DBClosed12.png|center|203px]]
'''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.
|}
 
|}
<gallery widths=543 heights=96>
|}
File:3108_8.png
|}
</gallery>
<br>
 
----
 
<br>
'''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.
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;"
 
|-
<gallery widths=543 heights=96>
|<big>'''Step 4.'''</big>
File:3108_8.png
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;"
</gallery>
|valign="top" |
 
|-
 
|Select Services.
''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.
{|style="margin:left;"
 
|valign="top" |
 
{|class="wikitable" style="background:white; align:center;"
=Step by Step Guides=
|-
 
|[[File:DBClosed13.png|center|118px]]
[[VT3000_-_Back_Up_Database_-_VT3000_Core|Back Up Database(s) using VT3000 Software]]
|}
 
|}
[[VT3000_-_Back_Up_Database_-_SQL_Server|Back Up Database(s) using SQL Server]]
|}
 
|}
[[VT3000_-_Update_Database_-_VT3000_Core|Update Database(s) using VT3000 Software]]
<br>
 
----
[[VT3000_-_Update_Database_-_SQL_Server|Update Database(s) using SQL Server]]
<br>
 
{|style="margin:left; width: 100px; background:#eaf3ff; padding:5px; border:2px solid #000000;"
 
|-
 
|<big>'''Step 5.'''</big>  
=Having Trouble?=
{|style="margin:left; width: 800px; background:#F0F0F0; padding:5px; border:2px solid #000000;"
 
|valign="top" |
<gallery widths=150px>
|-
File:ticketicon.png|Submit a Service Ticket|link=https://www.versacall.com/customer-support/service-ticket/
|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.
</gallery>
{|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;"
|-
|<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;"
|+
[[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 - Update Database - SQL Server|Update VersaCall Databases using SQL Server]]
|-
|[[VT3000 - Scripting SQL Databases|How to Script an SQL Database to an Earlier Version of SQL Server]]
|-
|[[VT3000 - Back Up Database for Download - VT3000 Core|Backup VersaCall Databases using VT3000 - Download Files]]
|-
|[[VT3000 - Back Up Database Locally - VT3000 Core|Backup VersaCall Databases using VT3000 - Make a Local Backup]]
|-
|[[VT3000 - Send a Back Up of Databases - VT3000 Core|Backup VersaCall Databases using VT3000 - Send the Backup to VersaCall]]
|-
|[[VT3000 - Update Database - VT3000 Core|Update 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:SQL Server]]
[[Category:Errors]]
[[Category:Database]]

Latest revision as of 19:24, 20 April 2023

Call Now 858-677-6766 SubmitTckBtn.png EmailUsBtn.png



GeneralHeader.png

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.


Requirements
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.


Error Message
DBClosed1.png



InstructionHeader.png

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.



RelatedHowTos.png
Select a Guide Here
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



SearchHeader.png

 



VC Footer.png
Follow Us On LinkedIn View our Blog


Retrieved from "http://support.versacall.com/index.php?title=VT3000_-_Errors_-_Database_Connection_is_Closed&oldid=9450"