The SQL Server is not available

Introduction
The SQL Server is not available. Check that the service is running and you have a valid network connection.

Description of Solution
This error comes up when launching Velocity and the Operators and/or Workstations table have more than one entry with the same value.

Solution
To resolve the issue connect to SQL Management Studio. Start >All programs >Microsoft SQL Server 2008 R2 >SQL Server Management Studio. Once in the connect screen, connect to the SQL instance hosting the Velocity database. Once connected expand Databases>Velocity>Tables.

  1. Locate dbo.Operators table. Right click and Select Edit Top 200 rows to open the table. Once the table is open check the Name column for duplicate operator names.
  2. Locate dbo.Workstations table. Right click and Select Edit Top 200 rows to open the table. Once the table is open check the WorstationName column for duplicate workstation names.
  3. If duplicate values are found in any of these tables you will need to get with your Administrator or DBA and correct duplicate values

ICPAM Product Advisory – Holiday Schedule for 2021

Customers using Cisco Physical Access Gateways with ICPAM with Holiday Schedules for 2021 and beyond need to download and apply updated configurations to continue normal operation.

Download Identiv Solution for Cisco Gateway Holiday Schedule Issue

For ICPAM customers and partners experiencing issues with Cisco Physical Access Gateway communications, please download the following critical information and files to restore full functionality.

Download Identiv Resolution to Cisco Certificate Expiration