ODBC Error: 'A data access error occurred (Error Code 0). General Network Error. Check your network (NETIQKB29518)

  • 7729518
  • 02-Feb-2007
  • 17-Sep-2007


VigilEnt Security Manager 4.x

NetIQ Vulnerability Manager 5.0

NetIQ Vulnerability Manager 5.5

ODBC Error: 'A data access error occurred (Error Code 0). General Network Error.  Check your network documentation.' when attempting to login to the Console.


A data access error occurred (Error Code 0).
Error Source: Microsoft OLE DB Provider for ODBC Drivers
Error information:  [Microsoft] [ODBC SQL Server Driver] [Shared Memory] General network error.  Check your network documentation.

The maximum concurrent user connections within SQL server have been exceeded.


To resolve the above error, increase the maximum concurrent user connections or set the number to unlimited on the SQL server where the VigilEnt database is installed.  The following steps below outline how to increase this number:

  1. Launch 'SQL Server Enterprise Manager' by clicking Start | Programs | Microsoft SQL Server | Enterprise Manager.
  2. Within the SQL Server Group node, right-click the SQL server and select Properties.
  3. Click the Connections tab.
  4. Under 'Connections', change the Maximum concurrent user connections (0 = unlimited):  to a larger number, or set it to 0.
  5. Click OK to accept the change.
  6. You will be prompted to restart the SQL Server Service.  Click Yes to restart the service so that the change can take effect.

Additional Information

Formerly known as NETIQKB29518