How do I use Microsoft SQL Authentication if my VigilEnt Security Manager GUI is in one domain, the (NETIQKB32153)

  • Document ID:7732153
  • Creation Date:02-Feb-2007
  • Modified Date:08-Sep-2008
    • Micro Focus Products:
      Secure Configuration Manager

Resolution

goal
How do I use Microsoft SQL Authentication if my VigilEnt Security Manager GUI is in one domain, the database in another and they are non-trusted?

fact
VigilEnt Security Manager 4.0

fact
VigilEnt Security Manager 4.1

fact
VigilEnt Security Manager 3.0 SR2

fix

The Microsoft SQL Server client on the machine where the VigilEnt Security Manager (VSM) GUI is installed must be set to use the TCP/IP protocol before running the GUI.  To do this, perform the following steps:

  1. Click Start | Settings | Control Panel.
  2. Double-click Administrative Tools.
  3. Double-click Data Sources (ODBC). The ODBC Data Source Administrator dialog box is displayed.
  4. Select the System DSN tab and click Add. The Create New Data Source dialog box is displayed.
  5. Select SQL Server and click Finish. The Create a New Data Source to SQL Server dialog box is displayed.
  6. In the blank for Name - Enter VigilEnt for the new data source.
  7. In the blank for Server - Enter the name for the server on which the database is installed.
  8. Click Next.
  9. Click Client Configuration.
  10. In Network Libraries, select TCP/IP and click OK. The Create a New Data Source to SQL Server dialog box is displayed.
  11. Click OK. An alias is created for the server on which the database is installed. The database client library will now use the TCP/IP protocol to connect from the GUI to the database.


Additional Information

Formerly known as NETIQKB32153