Error: 'Cannot connect to database. Please check to make sure that the user name and pasword are va (NETIQKB36956)

fact
VigilEnt Security Manager 4.1

symptom
Error: 'Cannot connect to database.  Please check to make sure that the user name and pasword are valid, or use SQL authentication to log in.'

symptom
An error occurs when logging into VSM from a remote GUI. 

cause
This error can be caused when you are logging in from a GUI that is in a different domain than the database server.

fix

Enable SQL Authentication on the VigilEnt Security Manager 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:
   
   https://www.netiq.com/kb/esupport/consumer/esupport.asp?id=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.

Formerly known as NETIQKB36956