Data access errors occur when attempting to log into VigilEnt Security Manager from a remote GUI. (NETIQKB29737)

  • Document ID:7729737
  • Creation Date:02-Feb-2007
  • Modified Date:26-Nov-2007
    • Micro Focus Products:
      Secure Configuration Manager

Resolution

fact
VigilEnt Security Manager 4.x

symptom
Data access errors occur when attempting to log into VigilEnt Security Manager from a remote GUI.

symptom
Error Code 3149: A data access error occurred.

symptom
Error: ' [Microsoft] [ODBC SQL Server Driver] [SQL Server] [Login failed for user '(null)'.  Reason:  Not associated with a trusted SQL server connection'

symptom

Error is as follows:

A data access error occurred (Error code 3149).
Error Source:  Microsoft OLE DB Provider for ODBC Drivers
Error information:  [Microsoft] [ODBC SQL Server Driver] [SQL Server] [Login failed for user '(null)'.  Reason:  Not associated with a trusted SQL server connection.



cause
This occurs when the remote machine is located in a separate domain than the VigilEnt Security Manager Server ( VSM ).  This error can occur despite the fact that there is a trust established between the two domains.

fix

To resolve the above error message, three items need to be implemented.  Please follow the steps below to enable SQL authentication within your environment.

Enable SQL Authentication on the VSM server:

  1. Click Start | Programs | Vigilent | Vigilent Security Server to launch the Configuration Utility on the VSM server.
  2. Select the Database tab.
  3. Change the Enable SQL Authentication setting to True.
  4. Click Apply.
  5. Restart the Vigilent Security Server service on the VSM server for the change to take effect.  Please reference the following link if needing assistance on restarting the service: NETIQKB25651

 

Confirm that SQL authentication is enabled, in mixed mode, on the SQL server where the VigilEnt database is located.

  1. Launch the 'SQL Enterprise Manager' from the SQL server.
  2. Right-click the SQL server located under the 'SQL Server Group' node and select Properties.
  3. Click the Security tab.
  4. Under Authentication, verify that it is set to SQL Server and Windows.

 

Enable SQL Authentication on the client side GUI.

  1. Launch the VSM GUI.
  2. Click Configure from the logon box.
  3. Select the Enable SQL Authentication checkbox and click OK.
  4. Logon to VSM.


Additional Information

Formerly known as NETIQKB29737