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

  • Document ID:7729518
  • Creation Date:02-Feb-2007
  • Modified Date:17-Sep-2007
    • Micro Focus Products:
      Secure Configuration Manager

Resolution

fact
VigilEnt Security Manager 4.x

fact
NetIQ Vulnerability Manager 5.0

fact
NetIQ Vulnerability Manager 5.5

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

symptom

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.



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

fix

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