Velocity was unable to connect to the database

When an operator first launches to Velocity, the first task is to make connection to the Velocity database in SQL Server.

image-20240718-211200.png

Velocity reads the value called SQL Server at the follow Windows Registry location and tried to make a connection to the SQL instance.

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Hirsch Electronics\Velocity\Client
image-20240718-211436.png

Troubleshooting

  • Check to see if the the SQL Server service is running. If it is not running, start the service.

  • Using Microsoft’s TCPView from the Sysinternals suite. Can help troubleshoot potential issues with the network connection. In the below example, we can see Velocity performed a Sys Sent, but did not receive a message back from the SQL Server.

  • Launching SQL Server Management Studio and trying to connect to the SQL Instance can also provide useful information regarding reasons you are unable to connect to the SQL Instance.

  • If you can connect to the SQL Instance but you cannot view the Velocity database, it might be lack of permissions to the Velocity database. You should work with the SQL administrator to add the appropriate permissions to the Velocity Users group.

 

Â